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")
);

How to manipulate data from one table to another table ?

913

---

How to verify a login name with sqlcmd tool?

1142

---

What functions can a view be used to performed?

1002

---

What are dml (data manipulation language) statements in ms sql server?

926

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3822

---

What is key set driven?

895

---

Is truncate a dml command?

893

---

Explain about nested stored procedure?

978

---

How to delete duplicate rows in sql server?

1060

---

How to check parameter value in stored procedure sql server?

917

---

How to defragment table indexes?

932

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

917

---

What are the results of running this script?

865

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

908

---

What are diverse clauses that form a part of sql?

1021

---