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

Ramon Quintana

8y795

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rupesh Kahane8y ago
Accepted answer
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
+1
Harshad Kathiriya8y ago
Just removed the single quote from @@rowcount when inserting the values to the table

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