|
|
-
|
|
Recently i came across this questions, "Is it possible to create a trigger on a table, which is in another database"...
|
|
-
|
|
What are the global table in SQL Server...
|
|
-
|
|
Define Output clause in SQL Server...
|
|
-
|
|
Define Common table expression (CTE) in SQL Server...
|
|
-
|
|
Define Output clause in SQL Server...
|
|
-
|
|
What is the advantage of CLR integration?...
|
|
-
|
|
How do you show the count of joinees of each department for the most recent month having atleast one joinee?
For example, in Department1, In January 10 members and in February 5 members joined, show it as 5 members joined in February
For example, in Department2, In January 4 members and in no one joined in February, show it as 4 members joined in January...
|
|
-
|
|
What is Difference between Left join and Left outer join?...
|
|
-
|
|
Is it possible to replicate data from SQL Server to Oracle?...
|
|
-
|
|
What are the requirements for setting up database mirroring?
Additional question: can you mix versions in mirroring (e.g. 2005 and 2000)?...
|
|