Stored proc. parameter tablename

[Ghislain Tanguay]

Hi.
I try to delete all fields from a table.
I create a SP but i always receive the same error

if exists (select * from sysobjects where id = object_id('dbo.sp_DeleteDnsIp')
and sysstat & 0xf = 4)
drop procedure dbo.sp_DeleteDnsIp

GO
CREATE PROCEDURE sp_DeleteDnsIp (
@NomTable varchar(75)
)
AS
Delete From @NomTable

The error:Line 13: Incorrect syntax near '@NomTable'.

Please help me

[Jason Rein]

SQL is trying to delete the data in a table named '@NomTable' instead of the
table name contained in the variable @NomTable. You must first build a string
that contains the delete statement and then use the EXEC() function. Replace
the delete statement in your stored procedure with the following:

DECLARE @SQL varchar(255)

SELECT @SQL = 'DELETE FROM ' + @NomTable

EXEC(@SQL)

I hope this helps.

- Jason

"Ghislain Tanguay" <ghislaintanguay3@hotmail.com> wrote:
>
>Hi.
>I try to delete all fields from a table.
>I create a SP but i always receive the same error
>
>if exists (select * from sysobjects where id = object_id('dbo.sp_DeleteDnsIp')
>and sysstat & 0xf = 4)
> drop procedure dbo.sp_DeleteDnsIp
>
>GO
>CREATE PROCEDURE sp_DeleteDnsIp (
> @NomTable varchar(75)
> )
> AS
> Delete From @NomTable
>
>The error:Line 13: Incorrect syntax near '@NomTable'.
>
>Please help me
>
>

[Ghislain]

Tks Jason.
It just work fine.

Have a nice easter week-end

And god bless all