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

What is the difference between varchar and varchar(max) datatypes?

1078

---

What do you understand by a stored procedure?

1090

---

can we have a nested transaction? : Sql server database administration

1103

---

What is the use of =,==,=== operators?

1013

---

What do you mean by data integrity?

1082

---

What is update_statistics command?

1070

---

what is the information that can be stored inside a bit column? : Sql server database administration

969

---

Explain the steps needed to create a scheduled job?

937

---

How do you migrate data from mssql server to azure?

165

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

908

---

Tell me the difference between clustered and non-clustered index?

937

---

What is difference between inner join and join?

1047

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1047

---

How do I find information about the install locations for the various instances running on a computer?

1085

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

912

---