Click here to Skip to main content
15,892,697 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
select OriginalTable.nextval into new_doc_nv from dual;
  insert into OriginalTable
(id,name)
    values (new_doc_nv,pname);



i want to take this statment into T-sql
can you help me guys to convert this code in T-sql
i have tried many things but not working

What I have tried:

SQL
DECLARE  @tmp TABLE(new_doc_nv INT NOT NULL,new_item_nv INT NOT NULL);


SQL
INSERT INTO @tmp
         ( new_doc_nv )
SELECT dbo.OriginalTable.ID FROM dbo.Documents;

SQL
INSERT INTO dbo.OriginalTable
         (ID, 
		 Name )
values(new_doc_nv,@name)
Posted
Updated 10-Nov-16 0:38am

1 solution

See SELECT...INTO : SQL SELECT INTO Statement[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900