MS-SQL

• User Defined Trim function in MS-SQL
• Backup and Restore the Database in MS-SQL by using Stored Procedure
• Generate 8 Digit Random Alpha Numeric Password in MS-SQL
• Copy table data from one database to another database
• List all the tables names from the another database
• Find the Missing Records from Source table and Insert Missing Records into Destination Table
• Enable and Disable Trigger in MS-SQL
• User Defined Contain function in MS-SQL
• Encryption and Decryption in MS-SQL
• Drop All Tables, Stored Procedures,Function,Trigger and Views in SQL Server
• Get the first character in each word
• Get the First and Last date of the Previous Month
• Working Days Count in MS-SQL
• SQL Optimization Tips
  
• Full Text Index in MS-SQL Server
  
• Create Job in Sql Server 2008
  
• Send Mail from SQL Server 2008
• Merge Statement in MS SQL Server