Kingston Dhasian (4/5/2010)

Jeff Moden (4/5/2010)

This is such a terrible idea that I have to...

Can you give bit more clarification using sql statement for trigger?

well identity columns value is going to differ in delete and insert.so how can i make it worth?

There's no unique key in table so that i can associate 'IsDelete' with new inserted record.

So cant use separate table even.

Delete + Insert is as per the business logic so that can not be changed.

Any alternative than storing values in separate table before delete?

Hello,

i got the solution.

I should append 'N' to the value which contains Foreign language or special characters.

As to recognize it as foreign language.

Eg. Insert into TableName Values(N'??????????')

Regards,

Actually,

It does support newly Inserted Foreign language characters but fails for Updating records with Foreign language characters.

I am finding it very strange.

I have already tried installing Languages Using 'Regional and...

Thanks David.

Thanks To all.

Hi All,

I guess it worked for me using

Select * from table where ','+col+',' LIKE '%,2,%'

Thanks SSC veteran 😀

Id of 1 and 4

I should get result as

RowId ValueStr

1 1,2,3,4

4 2

Id of 1 and 4.

I should get result as

RowId ValueStr

1 1,2,3,4

4 2

Regards,

Nilesh.

Nope.

I wanted number of rows containing ONLY 2

Regards,

Hello,

Thanks for your reply.

In this case i am able to see results for other data with same languageID.

Please refer to attached file.

Hi,

This query will return me only 1 record. ie. Record with only 2 in it.

Regards,

Hey Guys...

i got it....

Thanks