What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between locking and multi-versioning?
Tell me what is use of except clause? How it differs from not in clause?
What are truncate options available in sql server? : sql server database administration
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.
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is a function? Give some example?
how to find out the repeated value from table using groupby function?
What is difference between primary key and foreign key?
what is the Enterprise manager(2000) and management studio (2005)?
What are rows and columns?
can we call functions from stored procedure in SQL Server 2005 ? How?
What is the purpose of sql profiler 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)