Monday, December 28, 2009
Thursday, November 26, 2009
You need to have a login for the mentioned below site, signup and download the utility.
This tool was made by Liron Levi.
Thursday, September 10, 2009
Tuesday, July 28, 2009
Wednesday, May 27, 2009
Its not recommended and not efficient as it requires another column but its a solution which can help you out in some cases.
1. Add a column in your table which stores the reverse of the string
SET NewColumnName = REVERSE(ColumnName)
Tuesday, May 05, 2009
FROM sys.dm_db_missing_index_details mid
WHERE Database_ID = DB_ID()
ORDER BY 2
Monday, April 06, 2009
A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, variable, and any combination of these connected by one or more operators. The expression cannot be a subquery.
For example, in the AdventureWorks sample database, the TotalDue column of the Sales.SalesOrderHeader table has the definition: TotalDue AS Subtotal + TaxAmt + Freight.
Friday, March 27, 2009
--Procedure which Inserts unique IDs in table and returns the New ID
Wednesday, March 18, 2009
DECLARE @getInputBuffer CURSOR
SET @getInputBuffer = CURSOR FOR
SELECT Text FROM Table
FROM @getInputBuffer INTO @String
WHILE @@FETCH_STATUS = 0
Tuesday, January 13, 2009