Need and advantages of using computed columns
Posted By Admin on Sep 02, 2012
Tags:Column,sql,table,index, subquery, persistence, trigger, performance

How to Implement switch case in SQL
Posted By Admin on May 12, 2012
Tags:Case,When,switch,else,condition,clause,update,delete,select

Loop through all records in Sql server with while statement
Posted By Admin on May 03, 2013
Tags: While, loop, iteration,break, continue, table, cursor

Capitalise first character of every word
Posted By Admin on Mar 21, 2012
Tags:sql, tuning, capitalise, word, string

Nested Transaction, SavePoint and error handling in sql server
Posted By Admin on Mar 19, 2013
Tags:Transaction, Error, SavePoint, Commit, Rollback, Log

Different string functions in SQL-Part 2
Posted By Admin on Mar 17, 2012
Tags:sql, tuning, patindex, replace, replicate, reverse, right, soundex, space, str, upper, stuff. unicode

Different string functions in SQL-Part 1
Posted By Admin on Mar 12, 2012
Tags:sql, tuning, ASCII, char, charindex, datalength, diffrence, left, len, ltrim, rtrim, nchar

Change structures-constraints of table using alter command
Posted By Admin on Jul 14, 2012
Tags:Alter,Sql,Table,Constraints,Columns,Delete,Roles

How to use transaction in sql server for data consistency
Posted By Admin on Feb 16, 2013
Tags:Consistency, ACID, DML, statement,rollback, commit, isolation

Delete duplicate records from table in SQL
Posted By Admin on Apr 23, 2013
Tags:Redundant, consistency, ACID, database, column, table