Explain “@@rowcount” and “@@error” in sql server?
System requirements for sql server 2005 express edition?
What is wide table?
What is measure group, measure? : sql server analysis services, ssas
How is sql used in sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Is trigger fired implicitely?
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?
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
What is referential integrity? What are the advantages of it?
4 Answers Descon, Digital Domain,
How can we remove orphan records from a table?
What it means to be triggered?
Does group by or order by come first?