Hi Gopi,

i was explaing about insertion syntax,

not about selection process. In both 2005 and 2008 will display ans for selection command for insertion command.

bcoz sqlseerver 2005 doesn't support this syntax like insert into #test values('1','A'),(' ','B')

With Regards

Sutha