Monday, October 28, 2013

when I was sleeping

sql server added multiple values on insert thusly:
 DECLARE @tbl TABLE (
test VarChar(100) NOT NULL
);
insert into @tbl values('xzczxc'),('erter')
select * from @tbl


No comments:

Post a Comment