Agreed, Adam.

Depends.

You'll have to give us a lot more information than that.

You can only do this in a CLR function.

Jez: does that example work on SQL2000? I thought that the ::fn_get_sql function only worked on SQL2005.

Either 1) your ADO.NET connection timeout is too low, or 2) your program cannot find (or access) the SQL server that you are trying to connect to.

The answer to (1)...

hitesh.p (3/19/2008)

---

Scenario:

----------

There are around 30 HMIs accross 3 production plants that will fire update comfirmation on PartsManufacturing Table which is centrally located in SQL Server. It is likely that multiple...

Glad to help.

Glad I could help.

Gail, my understanding is that, in the abscence of statistics, the optimizer will, having nothing else to go on, order the predicates as they were ordered in the query statement.

You cannot parametize object names in SQL.

Try this:

Declare @TableName varchar(255)

Select @TableName = 'AdventureWorks.HumanResources.Employee '

Declare @sql varchar(max)

Select @sql = N'SELECT * FROM ' + @TableName + ' WHERE EmployeeID = 1'

EXECUTE...

Right. Clearly I was typing SUBSTRING and thinking LEFT.

Corrected:

Rats! Cory has it right, my answer is wrong...

Column order in predicates is only relevant if SQL Server has no statistics available on the referenced columns.

No, it won't make any difference.

The point of the prior posters was that SQL Server cannot just change the column...