How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

How many types of triggers are there?

0 Answers  

---

What is the most common type of join?

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 difference between primary keys and foreign keys?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What are the features of Embedded SQL

0 Answers   HCL,

---

How to disable triggers using "disable trigger"?

0 Answers  

---