Which command using Query Analyzer will give you the version
of SQL server and operating system?
Answers were Sorted based on User's Feedback
What are audit control procedures?
0 Answers Ernst Young, Thomson Reuters,
What are the types of database schema? : sql server analysis services, ssas
How many types of Joins in SQL Server 2005?
9 Answers CarrizalSoft Technologies, HCL,
What is row_number () and partition by in sql server?
Questions on identity?
What is the importance of concurrency control?
What is transaction server implicit?
What program is used to store the data source file?
How to insert new line characters into strings?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
What is replication and database mirroring?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?