Answer / madhu

SQL Server stored procedures can return multiple record
sets. The following is an example:

CREATE PROCEDURE procCustomerGet
@CustomerID VarChar(5)
AS
SELECT * FROM Customers
WHERE CustomerID =
@CustomerID
SELECT * FROM Orders
WHERE CustomerID =
@CustomerID

Answer / sd

Select select_list from my_tabel

Answer / sandeep modapathi

using cursor datatype

declare an output data type
@my_cursor CURSOR VARYING OUTPUT

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

What is cube dimension? : sql server analysis services, ssas

0 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

Which are the olap features?

0 Answers  

---

Is foreign key unique?

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

How to how to convert numeric expression data types using the convert() function??

0 Answers  

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

---