Answer Posted / vikram k mahapatra

It return Int datatype

Can binary strings be converted into numeric or float data types?

1033

---

List all types of constraints in sql server?

1032

---

What are the advantages of paper records?

966

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1110

---

What command must you use to include the not null constraint after a table has already been created?

1144

---

What is table value parameters (tvp)?

1101

---

How is sql used in sql server?

1006

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1215

---

What is the library index called?

1057

---

What is the sql profiler?

939

---

What do you mean by data integrity?

1067

---

What are the extra roles available in msdb? : sql server security

1131

---

Can we call stored procedure in view in sql server?

898

---

Explain the disadvantages/limitation of the cursor?

963

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1005

---