Answer / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Answer / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

Can foreign key be duplicate?

0 Answers  

---

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

What is after dml trigger?

0 Answers  

---

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

Explain about Joins?

0 Answers   Infosys,

---

Explain fundamentals of Data ware housing & OLAP?

2 Answers  

---

How to change the name of a database user?

0 Answers  

---

How to rebuild master databse?

0 Answers  

---