How to create a store procedure with encryption?

0 Answers  

---

When would you use sql joins?

0 Answers  

---

How is table type constraint applied to a table?

0 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

Explain the benefits of user-defined functions?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---