What is fill factor and pad index?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

How to connect to a sql server using odbc_connect()?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What are the different types of triggers in SQL SERVER?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

List down some advantages of sql stored procedure?

0 Answers  

---

Explain partitioned view?

0 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

How many clustered indexes there can be on table ?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---