How do you send email on SQL Server?
No Answer is Posted For this Question
Be the First to Post Answer
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?
How do you troubleshoot errors in a SQL Server Agent Job?
How to rebuild the master database?
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
Does union all remove duplicates?
How can we improve performance by using SQL Server profiler?
what protocol both networks use? : Sql server database administration
What is the difference between createstatement and preparedstatement?
Can you leave a union at any time?
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation
What is a trigger?
What is BCP? When do we use it?
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)