How to insert multiple rows with a subquery?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Which is better statement or preparedstatement?

0 Answers  


What is a virtual table in sql?

0 Answers  


How to connect ms access to sql servers through odbc?

0 Answers  


How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  


Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  






How to apply cascading referential integrity in place of triggers?

0 Answers  


When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  


What is difference between rownum and rowid?

0 Answers  


What are partitioned views and distributed partitioned views?

0 Answers  


What do you understand by user-defined function in the sql server?

0 Answers  


What do you mean by normalisation?

0 Answers  


What is a data source file?

0 Answers  


Categories