Answer / diveyandu

use dense_rank over(partition by stu_exam_date order by
stu_id) as stu_rank show a particular date student exam or
diff activity rank

Answer / naveen

place identity on a column at the time of creating table

Ex:
create table test(studentrank identity(1,1))

Answer / abi

select rank from student;

(because we dont know if the rank field is inserted r not)

Answer / raju

select * from student where rank = a;

What is checkpoint process in the sql server?

0 Answers  

---

When we should use @@error?

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

Differentiate between a having clause and a where clause.

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

How to provide Security for package?

1 Answers   Convergys,

---

Selet all the data from table where last name is n of employee

2 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---