Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

What are the source of constraints?

930

---

What are the differences between local and global temporary tables?

1084

---

What is the standby server?

957

---

Can we return Data from 4(more than 1) tables in stored procedure?

1059

---

What is page-level compression?

964

---

What does it mean to invest in the index?

973

---

What are the advantages of sql stored procedure?

1074

---

How to write a query with a full outer join in ms sql server?

1081

---

What is a scheduled job or what is a scheduled task?

952

---

How to create an identity column?

1222

---

What is sql server agent and what are the two modes of authentication in sql server?

1056

---

What is mssql?

985

---

How do I setup a local sql server database?

1010

---

Name three of the features managed by the surface area configuration tool? : sql server security

992

---

Does the unique constraint create an index?

1059

---