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 recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

explain different types of joins? : Sql server database administration

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

---

What is ms sql server reporting services?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

What is a transactions?

0 Answers  

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---