Answer Posted / dinesh rathod

1, XML datatype is introduced. XML datatype is used. 2, Can not encrypt the entire database.

What is microsoft sql server?

974

---

What is conditional split?

1070

---

Is the log file is a part of file group?

1038

---

What is the purpose of update statistics and scope_identity() function?

1100

---

What are the system database in sql server 2005?

1044

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120

---

Explain about link server in sql server?

1056

---

How to assign null values to variables or columns?

973

---

How to drop an existing table with "drop table" statements in ms sql server?

1086

---

How to loop through result set objects using odbc_fetch_row()?

976

---

What is the use of RDBMS?

1004

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

974

---

What are ddl (data definition language) statements for tables in ms sql server?

1104

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

985

---