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;

How to list all user defined functions in the current database?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

Which are ddl commands?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

What stored by the model?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is normalization and its forms?

4 Answers   Challenger Financial,

---

How the data stores in a page?

1 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

What is the difference between a unique key and primary key?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---