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

Why use sub query in sql server and list out types of sub queries?

975

---

What is the use of group by clause?

929

---

Explain a differential backup?

994

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1021

---

What is sql server schema compare? How we can compare two database schemas?

1007

---

What should be the fill factor for indexes created on tables? : sql server database administration

1119

---

What are sparse columns?

988

---

What is openxml in sql server?

1153

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2191

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

913

---

Can you import Microsoft Excel data to SSRS?

132

---

What is a trigger and its types?

962

---

How to view existing indexes on an given table using sys.indexes?

1066

---

What is lock escalation? : sql server database administration

1142

---

What is the difference between mysql and sql server?

992

---