If we use where clause in the left outer join then how the
query would behave/act?
Do you know what guidelines should be followed to help minimize deadlocks?
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
How many types of triggers in sql server?
What are 3 ways to get a count of the number of records in a table?
How can you find out how many rows returned in a cursor?
Show Practically Sql Server Views are updatable?
What is the difference between getdate and sysdatetime?
what are the Prerequisites for Replication?
How to find which stored procedure is currently running in sql server?
What are the steps you should follow to start sql server in single-user mode?
What is difference between equi join and inner join?
Explain the properties of subqueries in sql server?
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)