Define inner join in sql server joins?
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
How to create an inline table-valued function?
What does asynchronous call backs means?
Describe in brief authentication modes in sql server.
What is the difference between a view and a stored procedure?
Tell me what is sql profiler?
How do we get month name in SQL Server 2000, Oracle, MS Access?
What is an execution plan? How would you view the execution plan?
Is oracle faster than sql server?
In which year relase the 7.0& 2000 & 2005?
List out the difference between union and union all in sql server?
What are user defined functions in ms sql server?