Explain the rules for designing files and file groups in sql server?
List out the difference between union and union all in sql server?
Why is replication required on the sql server?
Do you have any idea about the tcl commands?
What is the main difference between ‘between’ and ‘in’ condition operators?
Explain transaction server implicit?
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 bit data type?
What is history table in sql server?
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?
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
How do triggers work?
Describe how to use the linked server?