Interested to Buy Any Domain ? << Click Here >> for more details...
Write the Syntax for Cursors.
- 2 Answers
- 6439 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 to generate XML out of QUERY?
How do you know which index a table is using?
What is user defined datatypes and when you should go for them?
What is shared lock?
From where can you change the default port?
Explain what is row_number function?
What is difference between inner join and join?
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
Can we call future method from trigger?
What do you understand by coalesce in sql server?
Explain the microsoft sql server delete command?
How to insert multiple rows with one insert statement in ms 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)
