Gopinath Srirangan (3/22/2011)
And are you sure this below code executed successfully in 2005 ?insert into #test values
('1','A'),
('','B')
Thanks
It will not work in 2005. That's the server I use daily and I wish this syntax would work because it could simplify my job significantly when inserting a bunch of values manually.