View Full Version : sql server insights

  1. Facts about MS SQL Server database corruption
  2. Recursive Queries in SQL Server
  3. How To: Optimize SQL Queries
  4. How to Bulk Update Using SQL Server XML
  5. Important SQL Server Statements/Searchs
  6. Getting rownumber in View in SQL2000
  7. Finding number of weekdays given from date and todate.
  8. Check to see weather the column already exists, if not add the column
  9. All database backup in a single query
  10. Dynamic SQL - A Quick Tutorial
  11. Essential SQL Server Date, Time and DateTime Functions
  12. SQL Server 2005 T-SQL XML Parser
  13. Delete Duplicate record from SQL Server2000