Answer / govardhana r

DECLARE @var1 varchar(20), @var2 varchar(20)

declare cursor_name cursor for
select val1,val2 from table_name

open cursor_name

fetch next from cursor_name
into @var1, @var2

while @@FETCH_STATUS = 0
begin
-----
-----
-----
fetch next from cursor_name
into @var1, @var2
end

close cursor_name
deallocate cursor_name

Answer / ranjith kumar

declare cursor_name cursor for
select * from table_name
open cursor_name
fetch next from cursor_name

What do you understand by sql server agent?

0 Answers  

---

What is the difference function and stored procedure?

0 Answers  

---

How to create new table with "create table" statements?

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---

What is the difference between left and right outer join?

0 Answers  

---

What is master database? : SQL Server Architecture

0 Answers  

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What is a database table?

0 Answers  

---

How can you control the amount of free space in your index pages?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,

---