adspace


Explain what are the restrictions that views have to follow? : sql server architect

Answer Posted / Ram Narayan Prajapati

"Views in SQL Server have several restrictions, including: 1) They cannot contain multiple SELECT statements or UNION operators. 2) They cannot modify data (INSERT, UPDATE, DELETE), although they can be used in these statements as a source for data manipulation. 3) They cannot be indexed directly, but indexes can be created on underlying tables that the view references. 4) They cannot contain subqueries within SELECT statements, though you can use them in FROM clause of subqueries."n

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1610