Interview Questions - How to insert data into the table which contains only identity column?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

How to insert data into the table which contains only identity column?

Nov 2 2011 11:26AM by Vivek Johari

Question

Suppose we have a table whose structure is given below Create table addcounter( counterid int identity(1,1) ) Now how can we insert values in the table?

Answer

By using the following Insert Statement

INSERT INTO addcounter DEFAULT VALUES;

Read More.. [32134 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: how to SHRINK the database?
Next: Identity Property In SQL Server

Vivek Johari

115 · 1% · 445

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"How to insert data into the table which contains only identity column?" rated 5 out of 5 by 10 readers

How to insert data into the table which contains only identity column?

Question

Answer

Your Comment