It's always bullet proof when you query the system tables to find information (unless an object is named : ";--drop table dbo.Users").

Anyhow, I'd strongly suggest you read articles on sql injection. ...

Never seen or heard of that problem.  I don't see how I cna help you at the moment.

Use only as a last resort.  This is a dangerous tool when used inappropriately.

Search for sql injection for more details.

Are you sure that the service is started?

Hwo do you know you are even connected to the server?

What's the query you are trying to run?

DECLARE @sql AS nVARCHAR(4000)

SET @sql = 'SELECT WHATEVER FROM ' + @ObjectName

EXEC (@SQL)

You can't do that... and it's really not a good idea to even try to!

What do you need to be able to do exactly?

Or another solution, just for the kicks of it.

Select valid data into newtable

truncate oldtable

drop old table

rename new table

you can change the drop rename by and insert if you want to...

You cannot use the alias name of the column untill the order by clause... or untill the whole query becomes a derived table.

You'll have to rewrite the query to use...

This one : .

.

What's the url??

How would that return a dataset instead of a varchar(?)?

BTW, you'll need to use >= AND then < (because the 2nd date is at midnight so you'll want to filter that out).

This should do it (yesterday, tomorrow).

DATEADD(D, -1, DATEDIFF(D, 0, GetDate()))

AND

DATEADD(D, +1, DATEDIFF(D, 0, GetDate()))

More details on what I'd like to offer : starting from any of these identities (single entity, single id) :

Technicians

Bills of work

Bills (to be paid by our clients)

Contracts

Inventory

Orders for inventory

Clients

go to...