You are working for an online gaming company and as usual when we talk about games we need to manage scores. Some features in your system had recently changed. Before when a user get connected you only shown him its last score, but now you have to present

I won't be using the table variable even if number rows are even greater than 10. Most probabably always i would like to use temp table. some advantage - you can create it using SELECT INTO clause. - with table variable you can't use ALTER comman...

I won't be using the table variable even if number rows are even greater than 10. Most probabably always i would like to use temp table. some advantage - you can create it using SELECT INTO clause. - with table variable you can't use ALTER comman...

and forgot to add.. disadvantage with data() is, it will fail in case there are spaces in values of column....

and forgot to add.. disadvantage with data() is, it will fail in case there are spaces in values of column....

The advantage with the data() is you don't need to convert the numeric values into character string to Concatenate them ... used the sample data provided by Tejas Declare @tbl table (id int,sid int) insert into @tbl select 1,11 union ...

The advantage with the data() is you don't need to convert the numeric values into character string to Concatenate them ... used the sample data provided by Tejas Declare @tbl table (id int,sid int) insert into @tbl select 1,11 union ...