Oracle dynamic sql

[mudskipper]

Heeeeey. How am I the butt of the joke after what MS and LE posted?

Edit : Don't forget to look closely

You still think I'm wrong?

You cannot use a variable name for a table directly.
You have to build a sql string and execute that.

Believe me.

[mudskipper]

You still think I'm wrong?

You cannot use a variable name for a table directly.
You have to build a sql string and execute that.

Believe me.

Or don't believe me - try it yourself.

SqlServer:

create table suityTest (suityString varchar(20));
insert into suityTest values ('value1')

declare @tablename varchar(20) = 'suityTest';
declare @value varchar(20) = 'value1';

-- this will work
select * from suityTest where suityString = @value;

-- this will work
declare @suitySQL varchar(max) = 
'select * from ' + @tablename  +
' where suityString = ''' + @value +'''';
exec (@suitySql)

-- this will fail
select * from @tablename where suityString = @value

[suityou01]

MS, the article I linked to shows you to be wrong. Please read it.

[suityou01]

Or to be fair you grasped the wrong end of the stick and started arguing the wrong point.

[mudskipper]

MS, the article I linked to shows you to be wrong. Please read it.

Your article says:

The string can also contain placeholders for bind arguments. However, you cannot use bind arguments to pass the names of schema objects to a dynamic SQL statement.

[suityou01]

Example uses the order date to build the name of the table that should contain the data, and then incorporates that name into an INSERT statement.

Glad we are arguing the same point now.

[suityou01]

Your article says:

The string can also contain placeholders for bind arguments. However, you cannot use bind arguments to pass the names of schema objects to a dynamic SQL statement.

Can't see that quote anywhere in the article. Then again I am bouncing around in the back of a taxi at present.

[mudskipper]

Can't see that quote anywhere in the article. Then again I am bouncing around in the back of a taxi at present.

I was quoting from your Oracle example.

[mudskipper]

Glad we are arguing the same point now.

Ah, you mean the section headed "B. Executing a dynamically built string"

Exactly which bit of what I said are you disagreeing with?

[suityou01]

Ah, you mean the section headed "B. Executing a dynamically built string"

Exactly which bit of what I said are you disagreeing with?

The bit where you say you can't pass a bind var as a table name.

Why are you quoting from an oracle article to support you SQL server argument?