SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 274 Page Views: 

Which conditions are to be kept in mind while using the FOR BROWSE Option in SELECT statement?



Posted By: Avi Date: 1 October 2010 11:29:07 AM
 Answer:

Following are the conditions:- 1. The table should have time-stamped column with timestamp as datatype. 2. The table must posses a unique index. 3. The FOR BROWSE option should be used at the end of the select statement. 4. HOLDLOCK option cannot be used along with FOR BROWSE option. 5. SELECT statements joined by the UNION operator can not have FOR BROWSE otion.


Posted By: avibtech


Date: 1 October 2010 11:29:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image VN6whV
Related Questions
SQL Server : Can you tell the important features of sub-queries?

Can you tell the important features of sub-queries?

Subqueries are very beneficial if used properly.They allow to return the desired result in a single ....
Category: SQL Server Date: 10/1/2010 11:19:07 AM
SQL Server : What are DDL statements? Name some DDL Statements?

What are DDL statements? Name some DDL Statements?

DDL statements mean Data Definition Language statements. This the vocabulary used to define the data....
Category: SQL Server Date: 10/1/2010 11:18:07 AM
SQL Server : Does the order of columns matter while creating a table? i.e which coulms should come first and which last according to constraints and values?
SQL Server : Having the following table:- 
sno          val1
1              7.5
2              8
3              9.5
4              11
.
.
.
N              val
Write the code to update the table where the difference in the column "val1" is computed i.e. (val1[2]-val1[1

Having the following table:- sno val1 1 7.5 2 8 3 9....

Code Required is:- update cal set diff_val = 0 where ID = (select min(sno) from cal) Update cal ....
Category: SQL Server Date: 10/1/2010 11:16:07 AM
SQL Server : Differentiate between Function and Stored Procedure?

Differentiate between Function and Stored Procedure?

1. Function returns a value but it is not necessary that stored procedure return a value. 2. Functio....
Category: SQL Server Date: 10/1/2010 11:15:07 AM