Help with UDF

[gjmac2]

I am new to SQL, so please bear with me.

I am trying to copy a table from one database to another within enterprise manager. Would I use a custom view to copy the table of should I use a User Defined Function?

The database names at "DT" and "QA Reporting database". The name of the table I am trying to copy is "Case".

Any assistance would be much appreciated.

 

[gmmastros]

I suspect that the problem you are having is caused by the name of the table. CASE is a reserved word in SQL Server. As such, I would recommend you change the name.

Additionally, you could try...

Click Tools -> Query Analyzer

Copy/Paste this...

Select *
Into   [QA Reporting database].dbo.[case]
From   [DT].dbo.[case]

-George

"the screen with the little boxes in the window." - Moron

 

[AlexCuse]

try somethign like this:

select * 
into TargetDatabase.dbo.Table1
from SourceDatabase.dbo.Table1

Remember if you create a table this way you will ned to recreate any indexes or constraints that existed on the previous table.

Hope this helps,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[AlexCuse]

I think some reading on Views and UDF's would be in order too. Here are some random google results:


Views:

http://www.odetocode.com/Articles/299.aspx

Functions:

http://www.extremeexperts.com/SQL/Articles/UDFFunctions.aspx

Hope this helps,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom