Answer Posted / ranjani
Scope_Identity() returns last identity value inserted into
an identity column in the same scope.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How to write a query with an inner join in ms sql server?
How to return the date part only from a sql server datetime datatype?
List out some of the requirements to set up a sql server failover cluster?
What are a database and a data warehouse?
Difference between LEN() and DATALENGTH() in sql server ?
how to avoid cursors? : Sql server database administration
What is the difference between ddl,dml and dcl commands?
What is user-defined multi-statement table-valued function?
What is report snapshot?
What is the Control Flow in SSIS
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the difference between mysql and sql server?
What is Extended user-defined?
What is the use of sign function?
How to view existing indexes on an given table using sys.indexes?