Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6679 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepak
Madhu, actually the answer which u have given is quite
common. Now i m gonna tell u a new one. The above question
has one more solution that is stated below:
"Insert into Table_name DEFAULT values"
that's it.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to install sql server 2005 express edition?
Which is better statement or preparedstatement?
Can we store videos inside the sql server table?
how to trace the traffic hitting a sql server? : Sql server database administration
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Why do you need a sql server?
What Is Rdbms?
What are the advantages of using stored procedures in sql server?
What is database architecture? : SQL Server Architecture
Can you index views?
What is the difference between upgrade and migration in sql server?
What is xdr?
How to loop through returning rows?
What are the types of subscriptions in SQL Server replication?
What is abstracting periodical?
