Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sivaram2006
Starting Member
1 Post |
 Posted - 2009-02-23 : 07:30:18
|
| Hi all,Till now I was using Orcle 9i as backend for my web application. Now I need to migrate that to MS SQL SERVER 2005. I have few doubts in this.1. In orcle, I use Ref Cursor to fetch a set of rows to the Front End (asp.net 2.0) and display it in the web application. In Sql Server 2005, how will i be able to do that. Are ref cursors available in Sql Server 2005?2. In some situation I use more than one refcursor and return more than one table data to the front end and display in various data grids. How can this be done in Sql Server 2005 ?Any help is appreciated.Thanks a lot in advance. |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-02-23 : 07:35:12
|
| in SQL server you can get the dataset just by givingSelect * from table1 in a procedure.Karthik |
 |
|
|
|
|
|
Migrating from oracle to sql server - Cursor Info