hi all,
SELECT t.configlookupid INTO emptype
FROM configlookup t
WHERE t.configlookupkey='EmployeeType' AND t.configlookupvalue= 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 TrivediPosted Nov 3, 2015, 6:03 AM
Raja TPosted Nov 3, 2015, 5:41 AM
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
GOThis 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 AdventureWorksGO
----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