Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of update statistics and scope_identity() function?
- 1 Answers
- 1186 Views
- I also Faced
- E-Mail Answers
Answer Posted / Kaushal Kumar Singh
1. Update Statistics: This SQL Server command updates the statistics for a specific table, which helps the Query Optimizer to make more informed choices when executing queries.n2. Scope_Identity(): Returns the identity column value for the last inserted row within a scope (either the current session or a specified transaction).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we solve concurrency problems?
What is acid mean in sql server?
What are the kinds of subquery?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is sql or structured query language?
Can sql servers link to other servers like oracle?
How do I start sql server 2017?
What are the different subsets of sql?
what is spatial nonclustered index
How do I find the sql server version?
When should you use an instead of trigger?
How to enter binary string literals in ms sql server?
How can I check that whether automatic statistic update is enabled or not?
What is normalization and what are the advantages of it?
How to provide default values to function parameters?
