Category Archives: SQL Development

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

New features added in SQL Server 2012

Posted on August 3, 2011 by uday arumilli

New features added in SQL Server 2012 Time to Denali – SQL 2012 Now Code name Denali is ready with CTP3. Now here are the list of new features added in sql server 2012. Operating System Support & Prerequisites ü … Continue reading →

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 2 Comments

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