Tag Archives: SQL Scripts

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

Truncate Table with Foreign Key constraint

Posted on June 28, 2011 by uday arumilli

Truncate Table with Foreign Key constraint This post helps you in automating the process of Truncate Table with Foreign Key constraint”. We recently working for a client on data migration project. There was a requirement for truncating tables. But we … Continue reading →

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , | 1 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