Answer / Vijay Kumar Gupta

"To view a stored procedure in SQL Server, you can use the following command:nn`sp_helptext <procedure_name>`nReplace `<procedure_name>` with the name of your stored procedure."

What are character string data types in ms sql server?

1 Answers  

---

what is the sql equivaent of the dataset relation object ?

1 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

Explain the different types of joins?

1 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What's the difference between a primary key and a unique key?

4 Answers  

---

Find nth lowest salary or get nth lowest salary?

1 Answers  

---

How much memory that we are using in Logshipping Concept?

1 Answers  

---

Explain different types of collation sensitivity?

1 Answers  

---

How to delete a database in ms sql server?

1 Answers  

---

What are the different normalization forms?

1 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

1 Answers   Global Logic,

---