Answer Posted / murugavel

yes
CREATE TABLE "accessmenu" (
"UID" int(11) NOT NULL DEFAULT '0',
"MID" int(11) NOT NULL DEFAULT '0',
"AlterPermission" tinyint(4) DEFAULT '0',
PRIMARY KEY ("UID","MID")
);

What are click through reports?

118

---

What is function of ROLLUP ?

801

---

Which are the important points to note when multilanguage data is stored in a table?

682

---

Give the query of getting last two records from the table in SQL SERVER?

714

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

671

---

---

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

805

---

What are the different types of stored procedures?

795

---

Explain few examples of RDBMS?

767

---

can a table be moved to different filegroup? : Sql server administration

715

---

What do you understand by the analysis services in sql server?

704

---

How do I find the transaction log size in sql server?

684

---

Explain the various types of concurrency problem?

923

---

what is package and it uses and how can u call a package

1774

---

What are locks in sql?

707

---

what is bit datatype? : Sql server database administration

651

---