Answer Posted / 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

Explain transaction server consistency?

921

---

What is log cache in sql server?

982

---

Explain how to use linked server?

926

---

how we use window authentication connection with sql server.?

1084

---

What is the difference between for xml raw and for xml auto?

974

---

How check triggers in sql server?

914

---

What are number line correlation administrators will use while working with a subquery?

1097

---

How to create an multi-statement table-valued function?

939

---

What is de-normalization in sql database administration? Give examples?

926

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

997

---

Give me a SQL Query to find out the second largest company?

1120

---

What is primary key and example?

896

---

How to optimize stored procedures in sql server?

1122

---

Explain unique key in sql server?

953

---

Explain how would you store your query in an SSRS report or a Database server?

114

---