What is the purpose of update statistics and scope_identity() function?
No Answer is Posted For this Question
Be the First to Post Answer
What is row_number function?
How many non clustered indexes there can be on table ?
What are different backups available in sql server?
What do you understand by intent locks?
How To delete duplicate record from a particular table?
Can we add an identity column to decimal datatype?
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
Can some one please help with a query which will take only max value of a column in a join.
Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60
What are the different types of normalization?
What is better - 2nd Normal form or 3rd normal form? Why?
How to create a login account in ms sql server to access the database engine using "create login" statements?
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)