I am looking to create a stored procedure that once executed passes in the name of the table as a parameter which is then apended with the string '_TEXT'. However the below does not work:
create procedure tabcreate @tabname varchar(50)
create table @tabname+'_TEXT' (
Is this possible in SQL Server 2000?
Thanks in advance.