How to create a dll in dotnet

To get something you never had, you have to do something you never did-Bimal Patel

Wednesday, December 29, 2010

Insert multiple rows in one query(Sqlserver)

INSERT INTO pantscolor_t (procode,color,pic)
SELECT '74251', 'Black', '511black.jpg'
UNION ALL
SELECT '74251', 'Charcoal', '511charcoal.jpg'
UNION ALL
SELECT '74251', 'Khaki', '511khaki.jpg'
UNION ALL
SELECT '74251', 'Navy', '511navy.jpg'
UNION ALL
SELECT '74251', 'OD Green', '511odgreen.jpg';

No comments:

Post a Comment