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 authentication modes does sql server support?
What is bcp? When does it use?
Explain how dts is used to extract, transform and consolidate data?
What happens if null values are involved in arithmetic operations?
What does it mean to invest in the index?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is implicit cursors?
What is replication with database mirroring? : sql server database administration
What is BLOCK statements in SQL?
What is partition index in sql server?
Write a program to fetch first 10 records from a file?
Explain system rowset functions?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
what is the system function to get current user's user id? : Sql server database administration
What are the properties of the transactions?