How can i INSERT a @@rowcount in a table camp

Question

Hi, I have a @@rowcount value catch from a Delete sentence, i need to INSERT that value in a table varchar column.

 

I WROTE this Query:

 

declare @delete int

delete from TableName1

select @delete = @@rowcount

 

insert into TableName2 (nom_tab, Reg_deleted)

values ('TableName1','@@rowcount');

 

BUT:

 

it only insert the WORD  "@@rowcount" and NOT THE VALUE

 

Answer 1

Try this is working fine without error 

 

if OBJECT_ID('tempdb..#Employee') is not null
Begin
Drop Table #Employee
End



if OBJECT_ID('tempdb..#Employee1') is not null
Begin
Drop Table #Employee1
End


CREATE TABLE #Employee
(
EmpId int,
EmpName varchar(100)
)
Insert Into #Employee values(1,'Rupesh')
Insert Into #Employee values(2,'Ashish')
Insert Into #Employee values(3,'Amol')
Insert Into #Employee values(4,'Vinayak')
Insert Into #Employee values(5,'Shital')
GO

declare @delete int
delete from #Employee where EmpId=5
select @delete = @@rowcount
--Select @delete

CREATE TABLE #Employee1
(
EmpName varchar(100)
)

Insert Into #Employee1 values(@delete)
Insert Into #Employee1 values(@@rowcount)

Select * from  #Employee1

 

Answer 2

Just removed the single quote from @@rowcount when inserting the values to the table

values ('TableName1',@@rowcount);"