Answer Posted / nikita

i donot abt the SQLserver2000and MSaccess.But in ORACLE we
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;

Explain the disadvantages/limitation of the cursor?

949

---

what stored procedure can you use to display the current processes? : Sql server administration

1002

---

How to enable/disable indexes?

1051

---

Why are views required in the sql server or in any other database?

948

---

What is Dependency Injection and provide example?

1109

---

Which table keeps information about stored procedures?

929

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1032

---

Can a rule be bound to any column of any data type?

951

---

What happens if null values are involved in datetime operations?

963

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1217

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1059

---

Does partitioning ssd reduce performance?

886

---

what are user defined datatypes? : Sql server database administration

956

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

948

---

What are date and time data types in ms sql server?

1080

---