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>;

What is thr feature of change data capture?

0 Answers  

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

What is ACID Property of Transaction?

10 Answers  

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

---

What is the difference between for auto and for nested?

0 Answers  

---

---

How to test subquery results with the exists operator?

0 Answers  

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---

What is 5nf in normalization form?

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

What is the difference between a function and a trigger?

0 Answers  

---