how we can use a database with php.

2 Answers   HCL, IT Solution,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

what are cursors? : Sql server database administration

0 Answers  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

What is Inner Join?

2 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

Can sql server be linked with other servers like oracle?

0 Answers  

---