Sql Server

1. User Defined Function to Parse HTML 
2. Case Sensitive search in SQL Server
3. Check Primary Key Exists or not in Table
4. Insert Values into Identity column 
5. Identity Column in SQL Server
6. SQL Server Database BackUp using C#
7. Exporting Query Results to CSV using SQLCMD 
8. SQL Server String Functions
   1. STR Function 
   2. SPACE Function 
   3. LOWER Function 
   4. SUBSTRING Function 
   5. UPPER Function 
   6. STUFF Function 
   7. LEN Function
   8. Unicode Function 
   9. LEFT Function
   10. CHARINDEX Function
   11. CHAR Function 
   12. ASCII Function
9. Simple script to backup all SQL Server databases
10. How to pass table as parameter in stored procedures in SQL Server (Table-Valued Parameters) 
11. Return SQL Query Result as XML in SQL Server- AUTO Mode
12. Return SQL Query Result as XML in SQL Server
13. Select random records from database (MySQL, Oracle, MS SQL)
14. SQl Server Tricks-Part2
15. SQl Server Tricks-Part1