Answer / ravindra

Select top 1 <Col-name> from <table> order by RecordTime
desc

Answer / sneha

uisng current .........

Answer / balaji.p

select ident_current(column) from table name

Answer / anil kumar

Select max(<columnname>) from <tablename>;

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

What is store procedure? How do they work? When do you use?

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

What is dirty read?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

What is the stuff?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---