Explain sql server service broker?
No Answer is Posted For this Question
Be the First to Post Answer
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What is indexed view? How to create it?
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
define and explain the differences between clustered and non-clustered indexes.
Whether the updations made to the views reflect the original records in the table
1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?
What is relationship? What number of sorts of relationship are there?
What is blocking and how would you troubleshoot it? : sql server database administration
What is tablesample?
How to update muliple row in single query?
How to provide column names in insert statements in ms sql server?
How to know whether our backup is succesfully taken?
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)