How to convert a table data in XML format in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Explain what is lock escalation?
What is index in an assignment?
What is the purpose of the model database?
When would you prefer to have a minimum number of indexes?
What are the steps you will take to improve the performance of a poor performing query?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
what is macro?
5 Answers Excel, Global Innovation, Wipro,
What will be query used to get the list of triggers in a database?
When you should use a low fill factor?
Do you know what is normalization of database? What are its benefits?
What is partition in sql server?
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)