Define cursor locking
What are the Pre Requisites when you apply Srvice Packs?
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 about sql server login?
What is CTE in SQL
How to configure and test odbc dsn settings?
Explain transaction server consistency?
what is spatial nonclustered index
Why use update_statistics command in sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
is there more the two primary key in a single table?
26 Answers Eforce, Systematix,
diffrence between function and procedure
Can you roll back the ddl statement in a trigger?