You would need to use dynamic sql and even then I am not sure is would work. Something like:

Declare @sql varchar(max)

Set @sql = 'insert into ' + @dbname +...

Checking everything is part of the job. First things to look for are Table Scans and Clustered Index Scans(basically a table scan). If you can eliminate these you...

There is aseries of articles on this site by Troy Ketsdever called Toward Integrity that might help you make a decision on the design. The first article is here:...

Wish I could help more, but I can't find anything related to this error in SQL 2005. Found lots of stuff for SQL 2000 though. I know this...

I use SQL Server in a generic manner when referring to the physical server on which any SQL Server components reside (SSIS, SSRS, SSAS, Database Engine). So in this...

Marios,

Are you using SQL 2000 or 2005? I know you are in a 2005 forum so I assumed 2005, but I found this MS link for this...

The only thing I have read about this is what you have already mentioned. The DLL needs to be in the .NET framework folder on the developer's machine so...

Do you want the data as well? If you want to copy the data and the structure you just need to use select into in the dynamic sql. ...

NaN means not a number so I would assume you have null values. You also need to be careful that your divisor is not 0 or you will get...

Good advice all around. The only thing I will add is that you need to make sure trailing blanks are removed on insert from varchar fields as the ANSI...

You would need to use dynamic SQL to create the table. Like:

[font="Courier New"]DECLARE @sql VARCHAR(MAX)

SET @sql = 'Create Table test_table_' + CONVERT(VARCHAR(15), GETDATE(), 112) + '(test_id int primary key,...

About the only thing I use triggers for is for change logging on the key tables. Other than that any business logic is either in the middle layer or...

Nice article Grant. Not sure if I'll use it or not, since there are other ways of collecting the information without MOM, but since we have MOM it might...

I thought it was a good question, but I must admit to having thought that you could answer Yes if you thought that the question meant that each individual query...

How do you find a problem where between 8am-9am the application is in use and performance is fine, then from 9am on it grinds down, but according to the customer...