Hi Wietz,

Sorry for not replying early enough. I tried executing the code which i had posted. It was not working simply because sp_executesql takes only one nvarchar parameter. I realised...

Hi Mr. Chris Morris,

I guess you are taking my sentence all wrong. I am trying to remove gaps within a column which has incremental values and not that of an...

Oh yes if the table has some dependency then it is a very poor idea. Moreover if there is a primary key-foreign key constraint then it wont even allow to...

Yes ofcourse ps it will create gaps. So here we can nullify all the identity entries and rebuilt them.

Hi Yogesh,

Try using more than 1 variable and combine the variables and then execute the command. For instance

DECLARE @sql1 nvarchar(4000)

DECLARE @sql2 nvarchar(4000)

SELECT @sql1 = ‘ SELECT [name], [address] ‘ +...

Hi Harsh,

The thing which Chris Harshman mentioned is good and pretty valid also. The thing which he mentioned can be written in code as follows:

create table #temp3(a int , b...

If you want to use a table for a stored procedure, you can create a function which will return a table and then use this function in your stored procedure....