Viewing 15 posts - 31 through 45 (of 46 total)
main thing is:-
IDENTITY_INSERT is already ON for table 'master.dbo.TblA1'. Cannot perform SET operation for table 'TblA2'.
December 13, 2012 at 3:13 am
Good question.......
where main consideration is - The default collation setting for SQL Server is Case Insensitive
September 25, 2012 at 11:42 pm
nice question...........
it is table variable........not temp or static table
September 6, 2012 at 5:24 am
Mainly...........
The "ROLLBACK TRANSACTION" does not work with table variables.
September 6, 2012 at 4:57 am
Great question...................:)
September 6, 2012 at 4:26 am
Sparse columns are a property of the storage layer, rather than the logical table. Therefore a SELECT…INTO statement does not copy over the sparse column property into a new table.
August 29, 2012 at 8:19 am
Good question but tough......
August 29, 2012 at 8:13 am
means, i have to create table first then to execute the mentioned statement...........
August 29, 2012 at 7:48 am
Yes both script execute successfully, using SQL server version 9.0.5000 [Sql server 2005]
With "Command(s) completed successfully".
August 29, 2012 at 1:10 am
Viewing 15 posts - 31 through 45 (of 46 total)