Answer Posted / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

556

---

What are the purposes of floor and sign functions?

543

---

Why use view instead of a table?

522

---

Explain different types of self contained sub query?

546

---

What is the difference RDBMS and Graph Database?

631

---

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1056

---

What are relationships and mention different types of relationships in the dbms

558

---

What is a partition function in sql server?

537

---

How many partitions a clustered index has by default in sql server 2012?

662

---

How can you insert values in multiple rows using one Insert statement?

620

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

564

---

difference between Clustered index and non clustered index ?

581

---

In what version of sql server were synonyms released?

506

---

What is ms sql server triggers?

538

---

What is the default sql server instance name?

560

---