N a g a s a i

Here is how you can convert get date in different formats SELECT GETDATE() AS GetDate, CONVERT ( VARCHAR ,GETDATE(),0) AS '0' , C...

We can use sp_depends , sp_depends displays information about database object dependencies, such as the views and procedures that depend on ...

I am working a lot with excel and CSVs for my SSIS packages these days. so I need to some input files as CSV files from SQL Server. Here is ...

Some times you might want to know what are the triggers available across your database. Here is how you can know by using the below query. ...

It is believed that lord Krishna possesses 64 kinds of arts called "Chausath Kalas".  Kala means performing an art.  Here are the ...