Can we drop multiple objects without using dynamic sql ?
Yes, It is possible. We can directly pass multiple table names using comma seperated.
drop table tabl1, tabl2, tabl3 and so on.
To do multiple inserts
Insert into tabl1 values (val1, val2), (val1, val2), (val1, val2) and so on.
Yes, It is possible. We can directly pass multiple table names using comma seperated.
drop table tabl1, tabl2, tabl3 and so on.
To do multiple inserts
Insert into tabl1 values (val1, val2), (val1, val2), (val1, val2) and so on.
No comments: