Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suraj
like this
select *
from dbo.Address
with (nolock)
-- above query doesn't hold lock while retrieving data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
If no size is defined while creating the database, what size will the database have?
What are the dmvs?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain primary key?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Detail about query optimizer?
define and explain the differences between clustered and non-clustered indexes.
What are magic tables in sql server?
What is difference between views and tables?
Is resultset an interface?
What happens when converting big values to integers?
Explain what is the use of custom fields in report?
What do you understand by mirroring and mention the advantages of the mirroring?
How you can find out if an index is useful to the optimizer?
