Detail about query optimizer?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by an execution plan? How would you view it?
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
Can binary strings be converted into numeric or float data types?
How will you hide an attribute? : sql server analysis services, ssas
How to verify a login name with sqlcmd tool?
How to return the date part only from a sql server datetime datatype?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
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 does null mean?
What are logical/boolean operations in ms sql server?
what is the difference between Delete and Truncate command in SQL