View Full Version : sql server insights

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