Answer Posted / praveen singh

A cursor is a set of rows together with a pointer that
identifies a current row.

In other word, Cursor is a database object used by
applications to manipulate data in a set on a row-by-row
basis, its like recordset in the ASP and visual basic.


DECLARE @fName varchar(50), @lName varchar(50)

DECLARE cursorName CURSOR -- Declare cursor

LOCAL SCROLL STATIC

FOR

Select firstName, lastName FROM myTable

OPEN cursorName -- open the cursor

FETCH NEXT FROM cursorName

INTO @fName, @lName

PRINT @fName + ' ' + @lName -- print the name

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM cursorName

INTO @fName, @lName

PRINT @fName + ' ' + @lName -- print the name

END



CLOSE cursorName -- close the cursor

DEALLOCATE cursorName -- Deallocate the cursor

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1122

---

What are the authentication modes in sql server? How can it be changed?

1193

---

What is right outer join in sql server joins?

1220

---

Explain having clause?

1029

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1062

---

Will count(column) include columns with null values in its count?

1149

---

What is row_number () and partition by in sql server?

1136

---

Define union, union all, minus, intersect?

1034

---

What are the different normalization forms?

1164

---

Why do you want to join software field as you have done your BE in Electronics?

2196

---

What is raid and what are different types of raid levels?

1194

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1197

---

What is an identity?

1077

---

Why use sub query in sql server and list out types of sub queries?

1056

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2085

---