Getting Id from table

Question

hi all SELECT t.configlookupid INTO emptype FROM configlookup t WHERE t.configlookupkey='EmployeeType' AND t.configlookupvalue= EmpType; this is my query . iam not getting id while inserting data. please help me

Jignesh Trivedi · Answer

Hi select ... Into is used to copy information from one table into another table. It inserted data into new table. So as per me it returns no of row affected it does not return inserted id. hope this will help you.

Raja T · Answer

Hi Method 1 : INSERT INTO SELECT This method is used when table is already created in the database earlier and data is to be inserted into this table from another table. If columns listed in insert clause and select clause are same they are are not required to list them. I always list them for readability and scalability purpose. USE AdventureWorks GO ----Create TestTable CREATE TABLE TestTable ( FirstName VARCHAR ( 100 ) LastName VARCHAR ( 100 )) ----INSERT INTO TestTable using SELECT INSERT INTO TestTable ( FirstName  LastName ) SELECT FirstName  LastName FROM Person.Contact WHERE EmailPromotion = 2 ----Verify that Data in TestTable SELECT FirstName  LastName FROM TestTable ----Clean Up Database DROP TABLE TestTable GO Method 2 : SELECT INTO This method is used when table is not created earlier and needs to be created when data from one table is to be inserted into newly created table from another table. New table is created with same data types as selected columns. USE AdventureWorks GO ----Create new table and insert into table using SELECT INSERT SELECT FirstName  LastName INTO TestTable FROM Person.Contact WHERE EmailPromotion = 2 ----Verify that Data in TestTable SELECT FirstName  LastName FROM TestTable ----Clean Up Database DROP TABLE TestTable GO http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/