Answer / Ani Ranjan

The new philosophy for database devices in SQL Server 7.0 was the introduction of Service Packs and Hot Fixes to improve system stability, performance, and security.

How to encrypt Strored Procedure in SQL SERVER?

1 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

Explain the different types of joins?

1 Answers  

---

What is the difference between deallocate cursor and close cursor?

1 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Why use cursor in sql server?

1 Answers  

---

What are the different ways you can create databases in sql server?

1 Answers  

---

What is the difference RDBMS and Graph Database?

1 Answers   EXL,

---

What does man by sql wildcard characters in sql server?

1 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1 Answers  

---

What do you understand by the analysis services in sql server?

1 Answers  

---