Explain error and transaction handling in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
You are doing log shipping due to some reasons it is failing. How you will proceed from there
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
what are three different authentications to connect linked servers?
Explain user defined views?
Can you explain the role of each service?
What is implicit cursors?
What does set rowcount do?
what is difference between NULL and ISNULL in SQL Server 2008?
What is multi-statement table-value user-defined function?
How to configure and test odbc dsn settings?
How to get a list of columns in a view using "sys.columns" in ms sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
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)