Answer Posted / vipul
When new row insert into table its we can get value of auto
increment column using SCOPE_IDENTITY()
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
When we should use and scope of @@identity?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is the purpose of floor function?
What is indexing a document?
List the data types available in mssql?
Explain what is row_number function?
What is code near application topology?
You want to implement the many-to-many relationship while designing tables. How would you do it?
How to connect a database with sql express.?
What is sql stored procedure?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Do you know what is blocking?
What is normalization? Explain different forms of normalization?
What is the difference between a fill factor of 100 and 0?
Which table keeps information about stored procedures?