Answer Posted / veeresh kethari
set rowcount 100
select * from tablename
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is the difference between Stored Procedures and triggers?
Can we use custom code in ssrs?
What is sub query and its properties?
What is a scheduled job or what is a scheduled task?
Tell me the phases a transaction has to undergo?
Can we insert data into view sql server?
How to delete duplicate records based on single column from a table?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
your distribution database is full what will u do
What type of locking occurs during the snapshot generation? : sql server replication
what type of index will get created after executing the above statement? : Sql server database administration
What is the difference between createstatement and preparedstatement?
How do I find my localdb version?
Explain boyce and codd normal form(bcnf)?
Write a code to select distinct records without using the DISTINCT keyword.