stored procedure help.

[trialproduct2004]

Hi all

i am new to sql server.

i want to write stored procedure in sql server to insert values into
two table whose structure is same.

i have one condition depending on which i am inserting values into
either of this table

e.g insert into table1 values()...
instead of table1 i want to user variable name.

how can i use variable in insert query instead of exact table name.

can someone help me.

thanks in advance.

[Hans Kesting]

> Hi all

i am new to sql server.

i want to write stored procedure in sql server to insert values into
two table whose structure is same.

i have one condition depending on which i am inserting values into
either of this table

e.g insert into table1 values()...
instead of table1 i want to user variable name.

how can i use variable in insert query instead of exact table name.

can someone help me.

thanks in advance.

You can't use variables instead of the table name.
One way would be to use "dynamic sql" (build a sql statement in a
string, and execute that).
But if you have just two tables, why not write it out:

if condition
insert into table1 ...
else
insert into table2

Easier to read and sp can be compiled (=faster).

Hans Kesting

[shiv_koirala]

if @x=yourcondition
begin
-- asnother insert
end
else
begin
-- one insert
end
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book

http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/