First one is better...

I use first option generally

Can you please provide some more details?

You need to use squar brackets with underscore like this:

SET @appnaam2=@appnaam +'[_]%'

It will works

+1 🙂

Mark-101232 (10/10/2013)

---

Your XML isn't very clear, but see if this helps

DECLARE @x XML='

<root>

<INPUT>

<CID>17064</CID>

<OwnerID>17064</OwnerID>

<TaskId>0</TaskId>

...

Excellent Question 🙂

Great discussion & explanations!

EXECUTE sp_msforeachtable @command1="Print 'Test'", @Command2 ="ALTER TABLE Foo.tblFoo CHECK CHECK CONSTRAINT all"

Bhuvnesh (10/8/2013)

---

select * from TABLE where countryid = @country

select * from TABLE where countryid = @country OR stateID = @stateid

select * from TABLE where...

Use PIVOT

+1 🙂

Thanks a lot guys for your help....

I have created the script now :-D:-P

SELECT 'UPDATE table_1 T

SET labeltext ='+ T.labeltext

'WHERE LanguageID = 10

AND LabelKey...

sqlnaive (9/30/2013)

---

SELECT 'UPDATE table_1

SET labeltext ='+ T.labeltext +

'WHERE LanguageID = 10

AND LabelKey ='+ T.LabelKey +

'AND FileID =' + T.FileID

Try this one. You are forgetting one "+" on the...

+1

+1 🙂