Viewing 7 posts - 31 through 37 (of 37 total)
Yes i got it , i did an insert with the table column in it , without the identity column and it worked .
thanks
December 11, 2009 at 11:19 am
I did try all this .
is there anyway before i can remove the identity column as non - identity
after insert i can change it to identity column...
December 11, 2009 at 9:37 am
Yes it worked , thanks a lot , i needed to put spaces after delete from and before insert into.
now i need i need to put a data range ,...
December 7, 2009 at 12:46 pm
fetch next from c1 into @db_name,@table_name,@date,@col
WHILE (@@FETCH_STATUS = 0)
begin
set @sql = 'delete from ' +@db_name +'.dbo.'+@table_name+'insert into '+@db_name+'.dbo.'+@table_name+' SELECT distinct top 100* FROM [112.64.104.210,3824].'+@db_name+'.dbo.'+@table_name --+ 'WITH...
December 7, 2009 at 12:10 pm
Viewing 7 posts - 31 through 37 (of 37 total)