1)SELECT * FROM tablename WHERE primarykeyid= IDENT_CURRENT('tablename')
Eg:
SELECT * FROM tbl_emp WHERE empid= IDENT_CURRENT('tbl_emp ')
2)
set rowcount 1
select * from tbl_emp order by
empid desc
SET ROWCOUNT { number | @number_var }
Causes SQL Server to stop processing the query after the specified number of rows are returned.
No comments:
Post a Comment