I have to truncate the table but getting error
Must declare the scalar variable "@Table".
Code:
DECLARE @Table VARCHAR(20) = 'ABC'
AS
BEGIN
EXEC ('TRUNCATE TABLE abcDB.dbo.'+@Table) AT [Server]
END
3 Answers
Declare the varaible After AS keyword.
BEGIN
DECLARE @Table VARCHAR(20) = 'ABC'
EXEC ('TRUNCATE TABLE abcDB.dbo.'+@Table) AT [Server]
END
6 Comments
Martin Smith
variables aren't block scoped in TSQL.
M.K.S
@ahmed abdelqader I voted it up but it's saying 15+ reputation can vote and I am new member. Sorry for that
Anonymous Duck
the issue would be the variable name is added in a newline
ahmed abdelqader
@MartinSmith, you are correct , the issue is not related to begin and End, it is related with AS keyword, so my Answer is valid, and I edited it
M.K.S
@ahmed abdelqader vote me to increase my reputation so that I would eligible for voting..........
|
Check if u have any constraints(Foreign key). If exists drop it
DECLARE @Table VARCHAR(20) = 'ABC'
BEGIN
EXEC ('TRUNCATE TABLE abcDB.dbo.'+@Table)
END
4 Comments
M.K.S
Thanks for your time
Tharunkumar Reddy
@M.K.S Welcome. And please accept any one answer if it helps you, that will help people to grow in this community.
M.K.S
I am new member my reputation does not allow me to accept any question....I have tried it but failed to accept the questions. vote me to increase my reputation
M.K.S
Thanks a lot, now I am eligibled to accept any question
Use sp_executesql:
DECLARE @Table VARCHAR(20) = 'ABC'
SET @sql='TRUNCATE TABLE abcDB.dbo.' + @Table
EXEC sp_executesql @sql
Comments
ASdoing there?