Help with basic stored proc, two part name giving me grief.

SQLServerCentral » Latest topics

Help with basic stored proc, two part name giving me grief.

Hello,
I have the following basic sp to truncate a table...

Create Procedure sp_Truncate_Address
@DBName varchar(30) = [AdventureWorks2014],
@TableName varchar(30) = [Person].[Address_Staging_A

more info...