SQL Query to limit number of records in select query

SQL Query to select N number of records from database using select query.
set rowcount 10
Select * from EMP_TABLE

SQL Query to Find Column in database table.

Using This Query you will get a list of Tables in database which have the specified column.
select * from sysobjects where id in (select id from syscolumns where name like 'USER_ID')