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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 select info

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2006-03-23 : 04:33:33
any easy way to select all fields matching a criteria in one table into another without having to specify all the fields in the insert into table (dfld.....

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-03-23 : 04:42:23
Somthing like this ???

Select * Into <SecTable> From <Primary Table>
Where <Codition>

or

Insert <TableName>
Select * From <TableName>



Sucess Comes to those who Believe in Beauty of their Dream..
Go to Top of Page
   

- Advertisement -