What is @@Identity in sql?
Answer / deepthi
Is a system function that returns the last-inserted
identity value
| Is This Answer Correct ? | 23 Yes | 1 No |
Which are new data types introduced in sql server 2008?
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
What are the different types of cursor?
Mention the differences between having and where clause.
Explain some DBCC commands?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
what r steps to we need to fallow b4 kill the process?
State the difference between local and global temporary tables?
How to change the system date and time from SQL Plus Terminal ?
What are the different authentication modes in sql server? How can it be changed?
What is lock escalation? : sql server database administration
What is the difference between getdate and sysdatetime?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)