When we cannot use Next Value For Function of Sequence object?

 Posted by Rajnilari2015 on 2/17/2016 | Category: Sql Server Interview questions | Views: 2674 | Points: 40
Answer:

It can never be use in conjunction with

Check constraints

Default objects
Computed columns
Views
User-defined functions
User-defined aggregates
Sub-queries
Common table expressions
Derived tables
Top
Over
Output
On
Where
Group By
Having
Order By
Compute
Compute By


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response