Friday, April 27, 2018

Multiple Insert || Multiple Add Columns



---------------------------------------------
INSERT INTO temp_user (id, name, salary)
VALUES ('1', 'A', '1001'),
('2', 'B', '1002'),
('3', 'C', '1003'),
('4', 'D', '1004'),
('5', 'E', '1005'),
('6', 'F', '1006'),
('7', 'G', '1007'),
('8', 'H', '1008');
---------------------------------------
Alter table Hotels
Add
HasPhotoInReadyStorage  bit,
HasPhotoInWorkStorage  bit,
HasPhotoInMaterialStorage bit
--------------------------------------------

No comments:

Post a Comment

javascript Filter/index off

 var family = [{"name":"Jack",  "age": 26},               {"name":"Jill",  "age"...