Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

When should you use an instead of trigger?

0 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

---

What is dknf in normalization form?

0 Answers  

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

What are the instances when triggers are appropriate?

0 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

when you create a database how is it stored? : Sql server database administration

0 Answers  

---