thanks... nice one

thank you... 🙂

i was looking for such a stuff... this can be used for anything which needs to be applied on all the tables...

viz.

sp_msforeachtable "grant select on ? to...

Yeah!... i have executed the query in SSMS 2005... and I get the result as "-1,0,1"

we should get our points back... 😀

john-byrne (6/27/2010)

---

Since the question is wrong then everyone who...

thanks, understood now...:-)

Christian Buettner-167247 (6/25/2010)

---

ziangij (6/25/2010)

---

since there is only one column, why is this working as well ?

SELECT @t = @t + @comma + a.a

,@comma = ','

...

since there is only one column, why is this working as well ?

SELECT @t = @t + @comma + a.a

,@comma = ','

FROM #a a

ORDER BY 2

Result...

good question ... thanks...:-)

agreed ! i used to be a dotnet guy.. but was forced to move to do DBA tasks... now I am managing ETL tasks, writing SQL scripts primarily and writing...

and database_id < 2

this was enough to answer the question...:-)

nice question.... thanks 🙂

good question... thanks 🙂

thanks Elliott 🙂

i was looking for various concurrency options in SSIS package, your example has helped me... looking forward for Part 2.

thanks 🙂

yep, i too assumed it to be NULL and i got it correct... 😀

antony-688446 (6/13/2010)

---

Come on, give the guy a break - you can see that Null has been cropped...

i guess bitbucket has already provided the alias in his question!

malleswarareddy_m (6/14/2010)

---

good question on select into...

I had one point to add.

the following gives an error.

select IDENTITY(int,100,5),* into #temp3 from

testread

there no...

luckily didn't correct the syntax error, hence got it right.

Ideally such kind of questions should be put in a different category so that people don't assume that syntax error...