Can we auto generate columns in SQL SERVER 2000? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Script Library

Can we auto generate columns in SQL SERVER 2000?

Author

Topic

samsuree
Starting Member

2 Posts

Posted - 2006-06-02 : 01:38:00

Hi,
Can we able to auto generate columns in sql server 2000?
I have a tabe with two fields No and Name. I need to auto generate no for each name i am going to enter. Can any give me a solution for this? If so i will be thankful to u.

This is my mail id suresh@tracy.in

Do reply me as soon as possible.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-02 : 01:47:31

use identity. Create the field No as identity. Something like

create table yourtable
(
    No   int identity(1,1),
    Name varchar(100)
)

Also, please post in the appropriate forumn. The Script Library is for workable script for sharing with others.

KH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources