?
Solved

MS SQL - create Table query issue

Posted on 2013-06-16
1
Medium Priority
?
532 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 2000 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

August and September have been big months for VMware—from VMworld last month to our new Course of the Month in VMware Professional - Data Center Virtualization. We reached out to Andrew Hancock, resident VMware vExpert, to have a more in-depth discu…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

600 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