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 5393
What is proper subset of candidate key?
How to rebuild indexes with alter index ... Rebuild?
What do you understand by triggers and mention the different types of it?
How to delete multiple rows with one delete statement in ms sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Why normalization is used?
What is model database? : SQL Server Architecture
What happens if the update subquery returns multiple rows in ms sql server?
What does this statement do @@rowcount?
Explain the concepts and capabilities of sql server?
What part does database design plays a role in performance of an sql server-based application?
What is cursors?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to delete database objects with "drop" statements in ms sql server?
Why is sql server log file full?