Answer Posted / trived.r

this used to changes the permissions on database
this DCL(DATA CONTROL LANGUGE)STATEMENT

*)GRANT---THIS IS ACCESS GARANTED ON PARTICLUR DB OR
USER
*)DENY----THIS IS PARTICLUR USER WAITING FOR ACCESS WHILE
TME WHEN COMMETED THE DATA THEN PERMISSION ON DB

*)REVOKE--- THIS STATEMENT USE THE USER HAVE NO PERMISIONS

How can I check if a view exists in a sql server database?

982

---

What is the difference between primary key and unique constraints?

902

---

What are the 2 types of classifications of constraints in the sql server?

1044

---

How do I view a stored procedure in sql server?

944

---

How are the exceptions handled in sql server programming?

997

---

What authentication modes does sql server support?

1018

---

How to drop an existing table?

958

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

---

What is the Difference Between Primary and Foreign Key?

957

---

What is fill factor and pad index?

953

---

Tell me about normalization in DBMS.

947

---

How can we improve performance by using SQL Server profiler?

984

---

what do you understand by change data capture?

935

---

What is collation sensitivity? Explain different types.

963

---

What is the difference between rank and dense_rank?

990

---