Tag Archives: SQL Tips

Export to Excel from SQL Server using T-SQL script

Posted on September 15, 2011 by uday arumilli

Export to Excel from SQL Server using T-SQL script This post helps in understanding Export to Excel from SQL Server using T-SQL Script. Typically to export data from sql server to excel we can user varius options : Import / … Continue reading →

Posted in SQL Development, SQL Scripts | Tagged , , , , | Leave a comment

How to Truncate only the Selected Tables from Database

Posted on June 16, 2011 by uday arumilli

How to Truncate only the Selected Tables from Database How to Truncate only the Selected Tables from Database? This stored procedure helps you out in truncating the selected tables. These tables has to be passed as a string parameter to … Continue reading →

Posted in SQL Scripts | Tagged , , , , | Leave a comment

How to use CASE in Where Condition

Posted on March 23, 2011 by uday arumilli

How to use CASE in Where Condition We had a situation in which we had to use case in where condition. This post helps in understanding “How to use CASE in Where Condition”. Lets consider a situation where we need … Continue reading →

Posted in SQL Development, SQL Scripts | Tagged , , , | Leave a comment