SQL Stored Procedure Creation

Cem_Karaer

Hello I tried following code

CREATE PROCEDURE dbo.proc_MyStoredProcedure
  @CompanyName
AS
  SELECT * FROM dbo.[@CompnayName$Item]

to return all lines of the item table which belong to the company that I want to specify while calling the stored procedure. To my surprise, SQL created a stored procedure without murmuring . But when I tried to execute the procedure with the following code

EXECUTE dbo.proc_MyStoredProcedure 'My Company Name'

it refused to obey me. What can I do?

SofDaniel

I don't know about SqlServer 2005 but on the previous versions I would rather use something like :

Exec ('SELECT * FROM ' + @tableName)

Exec ('SELECT * FROM ' + @MyCompanyName + '$Item')

where @TableName and @MyCompanyName are parameters or variables

kriki

Check this: http://dynamicsuser.net/blogs/waldo/archive/2008/01/06/using-stored-procedures-in-c-side.aspx.
I hope it helps.