Interested to Buy Any Domain ? << Click Here >> for more details...
Write the Syntax for Cursors.
- 2 Answers
- 6423 Views
- CarrizalSoft Technologies, HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ranjith kumar
declare cursor_name cursor for
select * from table_name
open cursor_name
fetch next from cursor_name
| Is This Answer Correct ? | 6 Yes | 2 No |
How can you check the level of fragmentation on a table?
What is the use of @@spid?
What are partitioned views?
What are .mdf files?
How to generate create table script on an existing table in ms sql server?
what's the information that can be stored inside a bit column? : Sql server database administration
What is coalesce and check constraint in sql server?
What is triggers and its types?
What do you understand by check constraint in sql server?
How to remove duplicate rows from table except one?
Explain transaction server consistency?
Mention a few common trace flags used with sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
