What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
No Answer is Posted For this Question
Be the First to Post Answer
Tell me about builtinadministrator?
Mention the differences between sql server and mysql.
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
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Explain what is the use of custom fields in report?
What is the difference between update lock and exclusive lock?
What are the authentication modes in SQL Server?
What is the difference between executequery () and executeupdate ()?
Are null values the same as that of zero or a blank space?
What is the purpose of optimization?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)