Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

0 Answers   MCN Solutions,

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

Selet all the data from table where last name is n of employee

2 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

How many triggers you can have on a table?

0 Answers  

---

How to change the password of a login name in ms sql server?

0 Answers  

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

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,

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

How adventureworkslt tables are related?

0 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---