Answer / Yashpal Singh

"SQL Server offers a wide variety of built-in or pre-defined functions. Here are some examples:
1. Aggregate Functions (SUM, AVG, MAX, MIN, COUNT)
2. String Functions (CONCAT, LEFT, RIGHT, SUBSTRING)
3. Date and Time Functions (GETDATE, DATEADD, DATEDIFF)
4. Mathematical Functions (ABS, SQRT, POWER)
5. Logical Functions (AND, OR, NOT)
6. System Functions (DB_NAME, SERVERPROPERTY, @@SPID)

What are the encryption mechanisms in sql server?

1 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

Explain following error properties?

1 Answers  

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1 Answers  

---

What is the difference between a primary key and a unique key? Are they the same?

1 Answers  

---

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

---

What are the types of subquery?

1 Answers  

---

Can we insert data into view sql server?

1 Answers  

---

The Difference between 'Count' and 'Count(*)'

13 Answers  

---

Can we update data in a view?

1 Answers  

---

How to execute a sql statement using mssql_query()?

1 Answers  

---

Explain datetime2 data type in sal server 2008?

1 Answers  

---