Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kulfi
Starting Member
33 Posts |
 Posted - 2011-09-25 : 06:54:57
|
| i am using this query and the new table is created but where is it saved can any one tlle me.thanks ----Create CAD_Login CREATE TABLE CAD_lOGIN([Group Name] VARCHAR(100),[Employee ID] VARCHAR(100), [First Name] VARCHAR(100),[Last Name] varchar(100)) ----INSERT INTO CAD_lOGIN using SELECT INSERT INTO CAD_lOGIN ([Employee ID],[Group Name],[First Name],[Last Name]) SELECT [Employee_ID],[Group Name],[First Name],[Last Name] FROM [Cad_Data_base].[dbo].[CAD_Data_Base] ----Verify that Data in CAD_Login SELECT [Group Name],[Employee ID], [First Name],[Last Name] FROM CAD_lOGIN ----Clean Up Database DROP TABLE CAD_lOGIN GOEhsan |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-25 : 07:30:29
|
| It was created in the database you were connected to when you ran the query. The table is dropped (deleted) at the end, so it won't be there later.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Save the Table