Answer / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Answer / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

---

---

What is proper subset of candidate key?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

How to link up the text file to a Database table?

2 Answers   Allianz,

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

Explain about the command-line tool SQLCMD?

0 Answers  

---

What are commonly used mssql functions in php?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---