Very Computer

by **Dr. Crowba** » Sat, 29 Jun 2002 00:15:40

Hi. Is there a restriction on using a variable for a table name? Such as

by **Aaron Bertrand [MVP** » Sat, 29 Jun 2002 00:35:04

Quote:> Hi. Is there a restriction on using a variable for a table name?

Yes.

Try

--
www.aspfaq.com / www.perfhound.com

by **Anith Se** » Sat, 29 Jun 2002 00:43:44

Also see,
http://www.algonet.se/~sommar/dynamic_sql.html

- Anith

> Hi. Is there a restriction on using a variable for a table name? Such as

by **Cory Stei** » Sat, 29 Jun 2002 01:10:15

Try this. I should work for you.

Cory Stein, MCP, MCDBA, MCSE

Quote:>-----Original Message-----
>Hi. Is there a restriction on using a variable for a

table name? Such as

>.

by **Aaron Bertrand [MVP** » Sat, 29 Jun 2002 01:27:30

Quote:> I should work for you.

:-)

by **Steve Kas** » Sat, 29 Jun 2002 01:32:19

And to make this or other dynamic SQL solutions safe from
malicious SQL injection, here's a solution. If you will always
have a one-part table name (never dbo.tname or dbname..tname),
you can use QUOTENAME and forgo the quotename_ex()
function.

create function quotename_ex (

) returns nvarchar(512) as begin

end
go

create procedure [Select * from] (

) as

go

[Select * from] 'pubs..[authors]'
go

drop function quotename_ex
drop procedure [Select * from]

Steve Kass
Drew University

> Try this. I should work for you.

> Cory Stein, MCP, MCDBA, MCSE

> >-----Original Message-----
> >Hi. Is there a restriction on using a variable for a
> table name? Such as

> >.

Very Computer

restrictions on table naming?

restrictions on table naming?

restrictions on table naming?

restrictions on table naming?

restrictions on table naming?

restrictions on table naming?

restrictions on table naming?