Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
SQL statement
Hi,
How can I create a temp table that has a primary auto increment.
CREATE TABLE #TEMPPRJ
(
TPPrjID INT PRIMARY KEY Auto_increment,
TPProject char(24) NULL
)
How can I create a temp table that has a primary auto increment.
CREATE TABLE #TEMPPRJ
(
TPPrjID INT PRIMARY KEY Auto_increment,
TPProject char(24) NULL
)
it says incorrect syntax near Auto_increment.
there is more stuff to this question
Asked:
4-
3
1 Solution
For your reading pleasure:
http://msdn.microsoft.com/en-us/library/aa258255(SQL.80).aspx
Best regards,
Kevin
http://msdn.microsoft.com/en-us/library/aa258255(SQL.80).aspx
Best regards,
Kevin
no points please...just something else to read about besides what Kevin posted.
http://sqlservernation.com/blogs/tipweek/archive/2009/02/23/identity-columns.aspx
http://sqlservernation.com/blogs/tipweek/archive/2009/02/23/identity-columns.aspx
select * from #TEMPPRJ
output is:
TPPrjID TPProject
01 58695
02 58659
03 59865
now I want to append to the temp table a column with data from
customer table
select customername from customer
output is:
TPPrjID TPProject
01 58695
02 58659
03 59865
now I want to append to the temp table a column with data from
customer table
select customername from customer
Change this statement:
INSERT INTO #TEMPPRJ(TPProject)
SELECT 'Test'
UNION SELECT 'Another Test';
To something like this:
INSERT INTO #TEMPPRJ(TPProject)
SELECT DISTINCT ProjectColumnName
FROM Customer
INSERT INTO #TEMPPRJ(TPProject)
SELECT 'Test'
UNION SELECT 'Another Test';
To something like this:
INSERT INTO #TEMPPRJ(TPProject)
SELECT DISTINCT ProjectColumnName
FROM Customer
If you mean, you want to join on project to get the customer name then do something like this:
SELECT t.*, c.customername
FROM #TEMPPRJ t
INNER JOIN Customer c ON c.TPProject = t.TPProject
OR something to that effect. If you meant to insert new rows of TPProject values based on customername values in your customer table, see my original suggestion using INSERT INTO.
SELECT t.*, c.customername
FROM #TEMPPRJ t
INNER JOIN Customer c ON c.TPProject = t.TPProject
OR something to that effect. If you meant to insert new rows of TPProject values based on customername values in your customer table, see my original suggestion using INSERT INTO.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Open in new window