Thanks for the reply.

You can connect directly to TFS from SQL Server Management Studio. It will allow you to create a solution and add scripts to it, check them in...

Thanks for pointing out. But the issue is still handleable with Len() function and without using nvarchar.

Declare @v-2 varchar(100)

Declare @i int

Set @v-2 = ' ~ 1234 ...

In SSMS,

Right Click Database --> Tasks --> Generate Scripts

Select * from TestServer.TableA

Except

Select * from ProductionServer.TableA

And

Select * from ProductionServer.TableA

Except

Select * from TestServer.TableA

If youare deleting all rows from the tables, Use Truncate command to accomplish your task.

OR

Try deleting in Batches.

This option is discussed in the following link.

http://www.rikertothebridge.com/2009/03/deleting-data-in-sql-server-without-exploding-your-transaction-log/comment-page-1/

For different DDL Statements (CREATE, DROP), Template Explorer in SSMS is the best place to get the idea and then BOL.

For scripts, it depends upon your needs. I personally have...

Duplicate post. Already answered this question in another post.

Glad it helped you.

declare @xml xml

set @xml = '<items><item id="1" ISDELETED="D"></item><item id="2" ISDELETED="D"></item><item id="3" ISDELETED="D"></item></items>'

Update MyTable

Set ISDELETED = B.ISDELETED

From MyTable A

Inner Join

(

select xmlcol.value('@id','int') as ID,

xmlcol.value ('@ISDELETED', 'char(1)') as IsDeleted

from @xml.nodes ('/items/item') tbl...

I am not replacing the Original string. I have used Len() function and in that Function I have...

Hi mr_adeelalisyed,

The reference posted by you in

http://www.java2s.com/Tutorial/SQLServer/0400__Transact-SQL/SimpleSELECTquerywrittenusingvariablesforfieldnames.htm

gives a slight hint of issue that you might be facing.

I think you are trying to execute

TransactionErrorAuditID, TransactionErrorAuditSequentia, ErrorCode, ErrorMessage

But...

Already Posted a solution...

Declare @v-2 varchar(100)

Declare @i int

Set @v-2 = '12~12~~1234~13~~12~3~~'

Select @i = Len(@v) - Len(Replace(@v,'~',''))

Select @i

Declare @v-2 varchar(100)

Declare @i int

Set @v-2 = '12~12~~1234~13~~12~3~~'

Select @i = Len(@v) - Len(Replace(@v,'~',''))

Select @i

Simple Solution would be adding another column as Year and add 2009 / 2010 in that column and Define A composite Primary Key on Year Column and Demandid column.

Lost... Didn't read the question properly....