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

How to drop an existing table?

1053

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1123

---

How to delete duplicate records based on single column from a table?

1105

---

Explain syntax for disabling triggers?

1097

---

When columns are added to existing tables, what do they initially contain?

1097

---

Define right outer join?

1016

---

How to defragment table indexes?

1039

---

What is encryption key?

137

---

Differentiate between mongodb vs. Sql server?

1142

---

Determine when to use stored procedure to complete sql server tasks?

1108

---

Do you know what guidelines should be followed to help minimize deadlocks?

1014

---

What is the default schema of your login session in ms sql server?

1093

---

What is bookmark link in ssrs?

251

---

Explain the different types of joins?

1046

---

Why I am getting this error when dropping a database in ms sql server?

1120

---