Hi everybody,
  I am trying to rename a table dynamically...i tried
various way, i was still not succefully.

Could anyboyd pl. help me out on this...

Thanks
Jenniffer

Hi everybody,
  I am trying to rename a table dynamically...i tried
various way, i was still not succefully.

Could anyboyd pl. help me out on this...

Thanks
Jenniffer

You don't need dynamic SQL because sp_rename allows the use of a variable as
a parameter anyway. There is no TRIM() function in SQL, use LTRIM/RTRIM,
though in this example it's redundant.

--
David Portas
------------
Please reply only to the newsgroup
--

You had a few syntax errors in your code...

There is no trim function in SQL server... only ltrim and rtrim....

Try this:

create table test1
(id int)

insert into test1 values(1)
insert into test1 values(2)

select id_from_test1 = id from test1

select id_from_test2 = id from test2

--drop table test1
drop table test2

--
Dean Savovic
www.teched.hr

Thanks a lot ...

thats works

use of a variable as