If primary key column is identity column, then use
SCOPE_IDENTITY()
Or if you know the primary key column name, then
like this,
insert into tableTest(testUserEmail,testUserName)
output inserted.ID
values (@testValue, @testName)
Here ID is my primary key column name