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 2005 Forums
 Transact-SQL (2005)
 delete

Author  Topic 

mcupryk
Yak Posting Veteran

91 Posts

Posted - 2011-03-08 : 13:40:16
delete

KlausEngel
Yak Posting Veteran

85 Posts

Posted - 2011-03-08 : 14:29:26
create your ID column as identity column :
[FinancialContactID] int identity (1,1)

Then try something like this:


INSERT INTO tblFinancialContact (
[ProviderID],
[FinancialContactPrefix],
[FinancialContact],
[FinancialPosition],
[FinancialPhone],
[FinancialExtension] ,
[FinancialFax] ,
[FinancialEmail]
)
SELECT
[ProviderID],
[FinancialContactPrefix],
[FinancialContact],
[FinancialPosition],
[FinancialPhone],
[FinancialExtension] ,
[FinancialFax] ,
[FinancialEmail]
FROM tblServiceProvider
Go to Top of Page
   

- Advertisement -