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

Explain about the command-line tool SQLCMD?

545

---

How many replicas are maintained for each sql azure db?

104

---

Explain an automatic checkpoint

556

---

What is sql server replication? : sql server replication

530

---

What command do we use to rename a db, a table and a column?

497

---

---

Would you store your query in a ssrs report or a database server? State the reason why?

108

---

In which format does an image save in SQL Server database ?

584

---

Explain table valued parameters in sql server? Why tvp used?

553

---

What is the difference RDBMS and Graph Database?

625

---

What is row-level compre?

540

---

What are the types of table?

542

---

How global temporary tables are represented and its scope?

547

---

Explain different forms of normalization?

522

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

528

---

How do you set a trace flag in sql server?

546

---