SQL Server Education (by the geeks, for the geeks)
Many a times need arises to access/modify windows folder structures from SQL server. Though SQL Server is not meant for this purpose, however here is a T-SQL script to delete files …
T-SQL script to delete files Read MoreHi Friends, This one is about SQL Server removing duplicate records in SQL Server 2005 and above. Consider the below table with duplicate records. Create table tblDup(Sno int identity, Col1 varchar(50)) GO …
SQL Server Removing Duplicate Records Read MoreWhat are the differences between Delete and Truncate in SQL Server? This is one of the most frequently asked questions in SQL server interviews and the answer varies depending upon your …
Delete VS Truncate in SQL Server Read More