Answer Posted / cow
scope identity will give you the last generated value for
the current session/scope. Note that @@identity is across
sessions.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the features of Embedded SQL
What is reference section?
What is the downside of using udf?
What is the difference between the application object and session object?
How to create a view using data from another view?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Explain identity in sql server?
Can we store videos inside the sql server table?
What the class forname () does?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is the recommended total size of your memory optimized tables?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to download and install microsoft sql server management studio express?