Solved

MS SQL - create Table query issue

Posted on 2013-06-16
1
518 Views
Last Modified: 2013-06-16
Hi,

I wrote this query to create a table, but it is not working properly, here is the syntax I am using below:

CREATE TABLE Degrees

(DegreeID INT AUTO_INCREMENT,
DegreeName VARCHAR(100),
Description TEXT,
CONSTRAINT DegreeID_PK
PRIMARY KEY (DegreeID) );
0
Comment
Question by:Jack_son_
1 Comment
 
LVL 5

Accepted Solution

by:
DOSLover earned 500 total points
ID: 39251345
What error are you getting? You can specify auto increment using identity:

CREATE TABLE Degrees
(DegreeID INT PRIMARY KEY IDENTITY,
DegreeName VARCHAR(100),
Description TEXT );

Open in new window

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question