Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do you migrate data from mssql server to azure?
When to use Inner join & when to use subquery?
What number aggregate functions are accessible there in sql?
How do I find the transaction log size in sql server?
What is clustered vs nonclustered index?
Explain indexed views?
Explain the disadvantages/limitation of the cursor?
Explain the different types of backups available in sql server? : sql server database administration
How to replace the Query Result 'Null Value' with a text ?
What is an indexing strategy?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Explain unique key in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Explain datetimeoffset data type in sal server 2008?
Can you pass expressions to stored procedure parameters?
