Answer Posted / ajay kumar barik

select a.id from product a where (1= (select count(b.id)
from product b where b.id>=a.id))


It is for all database

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1706

---

SQL Server Architecture ?

2399

---

what are database files and filegroups? : Sql server database administration

888

---

What is ddl and dml commands?

852

---

What is difference between createstatement and preparedstatement?

1022

---

whats the maximum size of view state??

2148

---

Can you edit the .rdl code associated with a linked report?

149

---

how we use window authentication connection with sql server.?

1087

---

Explain “@@rowcount” and “@@error” in sql server?

1007

---

Explain primary key and foreign key constraints?

966

---

What is in place upgrade in sql server?

990

---

What is shared lock?

834

---

What is the rdl file?

123

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1009

---

What are the database objects? : SQL Server Architecture

987

---