I am looking for an example of how to navigate N records at a time using Server side cursors in SQL Server and ASP. I immagine I have to declare cursors, fetch rows, etc. but I would like to see a specific example. Does anybody know where I can find this information or maybe provide me with an example? Thanks for the help, I am a bit lost with this.
View 2 RepliesI have one standby server that I use for multiple production DB SQL Server 2000 servers. We are upgrading one of the production SQL Servers to 2005. I will install 2005 on my standby and run 2000 and 2005 side by side.
Is this okay? Are there any caveats specific to running 2000 and 2005 on the same standby server?
Thanks!
JL
I am planning on installing SQL Server 2005 first and then install SQL Server 2000 as a separate instance on the same server. Has anyone had any experience with this setup? When I ran the SQL 2000 set up it didn't force me to create a new instance but I still did. I also installed the files on different directories c:program files just in case. If you have any experience of ideas about this configuration, please let us know. Thanks.
View 8 Replies View RelatedHi!
It is possibile to install SQL Server Compact Edition side-by-side on the same machine where SQL Server 2005 is already installed?
Thanks, Marco.
Background information:
I have been researching BOL, this forum, and the SQL Server help: Working with Multiple versions installation documents since yesterday. We have an AMD x64 multi-processor IBM server running SQL Server 2000 under MS Windows 2003 Enterprise SP1. SQL Server is installed in the "c:program files (x86)" folder. I wanted to verify that we were indeed running the 32-bit version of SQL Server 2000 so I also ran the @@version command from isql and it returns:
Microsoft SQL Server 2000 - 8.00.2162 (Intel X86)
Goal:
We need to install SQL Server 2005 Enterprise Edition 64-bit in a side by side installation. We will be migrating the SQL 2000 x32 stuff over to SQL 2005 x64 at a later date. My research shows I should be able to do this without any issues.
Have I missed anything or does it look like I am ready to move forward?
I have a Windows 2003 Server running IIS 6.0 and SQL Server 2005. I have just (Today) deployed the first ASP.NET application (developed in Visual Studio 2003 and, as such, dependent on .NET Framework 1.1) on this server and am getting HTTP Error 403 (You are not authorized to view this page). This ASP.NET application runs fine on another server that is configured with the OS=Windows Server 2003, IIS=6.0 but without SQL Server 2005 and without the .NET Framework version 2.0. I found in the IIS Application configuration (on the troublesome site) that my app (in the Default Web Site folder) was pointing to the version 2.0 aspnet_isapi.dll. All efforts to use aspnet_regiis to "re-align" my app with version 1.1 have been fruitless to eliminate the HTTP Error 403. I granted the NETWORK SERVICE account privledges to the wwwroot folder. At this point, I don't know if I have a Framework error or a privileges problem.
Please help.
Thanks,
Rob
I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing.
So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running both SQL Server CE 2.0 and SQL Server 2005 CE to sync with either back-end server.
Can someone provide me with guidance as what is possible to set up here? I know that SQL Server 2000 and 2005 can be installed side-by-side on the same server. It also appears that you can set up SQL Server 2000 so that EITHER SQL Server CE 2.0 OR SQL Server 2005 CE can sync with SQL Server 2000 (see www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx), but I don't know if it's possible for BOTH SQL Server CE 2.0 AND SQL Server 2005 CE to sync to the same SQL Server 2000. As for SQL Server 2005 ... it appears to be possible to set up SQL Server 2005 so that BOTH SQL Server CE 2.0 devices AND SQL Server 2005 CE devices can sync to the same SQL Server 2005 (see web page cited above). However, I don't know if it's possible to set up a SQL Server 2005 server installation in this manner while at the same time having a side-by-side SQL Server 2000 installation supporting any level of mobile merge replication.
HELP!!!!
Hello friends....
my question is as follows:
How do I send the data from the server side to the client side specifically in what format and what kind of connection do I use?
waiting for answers.....
will this create a separate instance?
Is there anything I need to be aware of?
Thank you.
Greg
Is there anywhere I can compare side by side between 2005 SQL Server and 2005 SQL Server express Edition?
I just found out that the express version does not have the database Copy feature (When you right clink on the database object -> Tasks ) !
I don't know about the evel version since I have not install yet. Any idea ?
Hi,
In Analysis Services there is an option to enforce a role either on the client side or the server side.
Can someone kindly guide what's the recommended approach and what's really the difference between the two options.
Thanks.
Hello!
I was wondering if I can install/run SQL 2008 and 2005 side by side with SQL 2005 being default instance. Any issues with that?
Thanks,
Igor
having installed 2005 first and installed 2000 with both types of reports going to one 2005 home. i would like to have separate homes
with reports going their respective homes. Do i have to first unstall
2005 and do a new installation with a different report and server than
2000. I would like to avoid this and just fine tune 2000 with the rsconfig.exe. Help me out please.
Hai
My system is already installed with SQL server 2000 . Is it possible for me to install SQL server 2005 BETA CTP in the same machine and run both side by side.
Regards
I have SQL Express installed on my desktop and want to install SQL Server Evaluation.
View 5 Replies View RelatedHi all,
Is it possible to run SQL Server 2005 Dev Ed. and the Express edition side by side on my development platform?
Thanks,
Andy
I plan to upgrade my server to SQL 2005. It is a rather old machine, but still ok with the recommended hardware requirements.
It runs Windows 2000 (SBS) server, which is also a PDC, DHCP, DNS, Exchange server (I stop here but the list is long), with SQL Server 2000 Standard Edition (one single named instance). Everything localized (Italian).
I upgraded the database in a development machine and it works perfectly.
I installed SQL 2005 Standard Edition (English locale) on the server (default instance, MSSQLSERVER), and I have run in a lot of troubles.
The problem seems to reside in the TCPIP network protocols. If I enable TCPIP in the 2005 Server Configuration Manager, the new instance (MSSQLSERVER) does not start (this prevented me from upgrading to SP1 until I realized the cause, disabled TCPIP protocol and was finally able to update).
If I understand correctly, the problem is that both instances, the old 2000 one and the new one, try to listen to 1433 port. I changed manually the port to 1434 in the Server Configuration Manager. The result is that both SQL servers work, but none is working ok. I have several applications accessing the server. The asp application works. The .NET aspx one doesn't.
A tipical error I get is:
Codice evento: 3005
Messaggio evento: Eccezione non gestita. (Unhandled exception)
Ora evento: 04/05/2006 13.42.26
Ora evento (UTC): 04/05/2006 11.42.26
ID evento: 7c2749235b7d4c578591871217f74046
Sequenza evento: 175
Occorrenza evento: 24
Codice dettagli evento: 0
Informazioni applicazione:
Dominio applicazione: /LM/W3SVC/1/Root/intranet-1-127912101551093750
Livello di attendibilità : Full
Percorso virtuale applicazione: /intranet
Percorso applicazione: F:Inetpubwwwrootintranet
Nome computer: IQ
Informazioni processo:
ID processo: 684
Nome processo: aspnet_wp.exe
Nome account: mycompanyIWAM_IQ
Informazioni eccezione:
Tipo di eccezione: SqlException
Messaggio eccezione: Login failed for user 'mycompanystefania'.
Informazioni richiesta:
URL richiesta: http://intranet/intranet/articoli/venditeProd.aspx?Codice=SOL T1
Percorso richiesta: /intranet/articoli/venditeProd.aspx
Indirizzo host utente: 10.0.0.127
Utente: mycompanystefania
Autenticazione: True
Tipo di autenticazione: NTLM
Nome account thread: mycompanyIWAM_IQ
Informazioni thread:
ID thread: 1
Nome account thread: mycompanyIWAM_IQ
Rappresentazione: True
Analisi dello stack: in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
in System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
in System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
in System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
in System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
in System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
in System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
in System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
in System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
in System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
in System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
in System.Data.SqlClient.SqlConnection.Open()
in intranet.Global.Session_Start(Object sender, EventArgs e)
in System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e)
in System.Web.SessionState.SessionStateModule.CompleteAcquireState()
in System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData)
in System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
in System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
I also tried to use named pipes on the 2005, but I was unable to access the SQL 2005 server instance from a network computer running the Management Studio. I need to have the new SQL server working besides the old one, for a short period, to evaluate in the production environment if the legacy hardware is actually ok to support it. Any ideas?
I'm rather new at working with SQL Server. I've installed 2005 onto my PC and I have 7.0 already. What I want to know is how do I import my packages from 7.0 into 2005?
Any help would be appreciated.
Thanks
I have SQL Express 2005 with Advanced Services on a development box that I also want to have installed side-by-side with SQL Server 2005 Standard Edition so I can develop apps using either edition based on the features I need (or don't need). From what I understand from sifting through other posts is that side-by-side installs of these two editions is supported and I should setup a named instance for each edition (SQLEXPRESS for the express edition and MSSQLSERVER for the standard edition). Is this setup accurate or is there another/better way?
Also, does anybody know if side-by-side installations of Reporting Services is also supported? If I install SQL Server 2005 Standard Edition with Reporting Services, will there be two different report servers running in IIS? Since there are different features in Reporting Services between the two editions, I'm not sure how side-by-side installations will effect one another.
Thanks in advance for any help,
Tony
Hiii all
SQL Server 2000 or 2005 dose not support the LIMIT statement like mySQL. So plz can anyone tell me tht how to do paging in SQL Server?? Without using CLR Integration...
Since Row_Number() is not available to SQL Server 2005 CE, are there any other alternatives for paging when querying the database?
Thanks.
I have created a server-side procedure which captures evenst for audit purposes and save to a file onto the SQL Server. This procedure has been defined as an autoload so that when the server is restarted, this procedure automatically loads.
However, there is a fundemental flaw with this routine. When the procedure attempts to execute, it will abort due to the fact that the trace file already exists.
I have two choices:-
1. When the procedure restarts, append to existing file or
2. Make a folder which comprise of today's day ie 20080128 and move trace file/s to this folder.
Option 2 is preferred.
How can I make this achievable?
Please note I'm using SQL Server 2005.
Ken
Below is a sample of my Code
-- Create a Queue
-- Declare Control Variable
declare @ReturnCode int
declare @Rc int
-- Declare Option Variable
declare @TraceID int
declare @maxfilesize bigint
declare @ColumnId int
declare @LogicalOperator int
declare @ComparisonOperator int
declare @Value int
declare @Option int
declare @on bit
declare @Event int
-- Set Option Variables
set @maxfilesize = 100 -- Maximum file size in megabytes
set @Option = 6 -- TraceFileRollOver and ShutdownOnError
set @on = 1 -- True
set @ReturnCode = 0 -- No Error
exec @Rc = sp_trace_create @TraceID output, @Option, N'\Server_named$SQLTraceActivity', @maxfilesize, NULL
select @ReturnCode=@@Error
if @ReturnCode <> 0
Begin
if @ReturnCode = 1
Print 'Error 1 - Unknown error.'
if @ReturnCode = 10
Print 'Error 10 - Invalid options. Returned when options specified are incompatible.'
if @ReturnCode = 12
Print 'Error 12 - Cannot create tracefile - check if file already exists, or this trace already running'
if @ReturnCode = 13
Print 'Error 13 - Out of memory. Returned when there is not enough memory to perform the specified action.'
if @ReturnCode = 14
Print 'Error 14 - Invalid stop time. Returned when the stop time specified has already happened.'
if @ReturnCode = 15
Print 'Error 15 - Invalid parameters. Returned when the user supplied incompatible parameters.'
else
Print 'Unexpected and Unknown error In creating trace - Please review'
Goto ErrorHandler
End
-- Set Events
-- Trace NTDomainName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 7, @on
-- Trace HostName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 8, @on
-- Trace IndexID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 24, @on
-- Trace RequestID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 56, @on
-- Trace SessionLoginName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 64, @on
-- Trace ClientProccessID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 9, @on
-- Trace IntegerData for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 25, @on
-- Trace LogionSid for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 41, @on
-- Trace RequestID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 49, @on
-- Trace NTUserName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 6, @on
-- Trace ApplicationName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 10, @on
-- Trace StartTime for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 14, @on
-- Trace ObjectID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 22, @on
-- Trace ServerName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 26, @on
-- Trace ObjectName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 34, @on
-- Trace XactSequence for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 50, @on
-- Trace DatabaseID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 3, @on
-- Trace LoginName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 11, @on
-- Trace NTDomainName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 35, @on
-- Trace EventSequence for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 51, @on
-- Trace TransactionID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 4, @on
-- Trace SPID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 12, @on
-- Trace ObjectType for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 28, @on
-- Trace IsSystem for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 60, @on
-- Trace EventSubClass for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 21, @on
I have created a server-side procedure which captures evenst for audit purposes and save to a file onto the SQL Server. This procedure has been defined as an autoload so that when the server is restarted, this procedure automatically loads.
However, there is a fundemental flaw with this routine. When the procedure attempts to execute, it will abort due to the fact that the trace file already exists.
I have two choices:-
1. When the procedure restarts, append to existing file or
2. Make a folder which comprise of today's day ie 20080128 and move trace file/s to this folder.
Option 2 is preferred.
How can I make this achievable?
Please note I'm using SQL Server 2005.
Ken
Below is a sample of my Code
-- Create a Queue
-- Declare Control Variable
declare @ReturnCode int
declare @Rc int
-- Declare Option Variable
declare @TraceID int
declare @maxfilesize bigint
declare @ColumnId int
declare @LogicalOperator int
declare @ComparisonOperator int
declare @Value int
declare @Option int
declare @on bit
declare @Event int
-- Set Option Variables
set @maxfilesize = 100 -- Maximum file size in megabytes
set @Option = 6 -- TraceFileRollOver and ShutdownOnError
set @on = 1 -- True
set @ReturnCode = 0 -- No Error
exec @Rc = sp_trace_create @TraceID output, @Option, N'\Server_named$SQLTraceActivity', @maxfilesize, NULL
select @ReturnCode=@@Error
if @ReturnCode <> 0
Begin
if @ReturnCode = 1
Print 'Error 1 - Unknown error.'
if @ReturnCode = 10
Print 'Error 10 - Invalid options. Returned when options specified are incompatible.'
if @ReturnCode = 12
Print 'Error 12 - Cannot create tracefile - check if file already exists, or this trace already running'
if @ReturnCode = 13
Print 'Error 13 - Out of memory. Returned when there is not enough memory to perform the specified action.'
if @ReturnCode = 14
Print 'Error 14 - Invalid stop time. Returned when the stop time specified has already happened.'
if @ReturnCode = 15
Print 'Error 15 - Invalid parameters. Returned when the user supplied incompatible parameters.'
else
Print 'Unexpected and Unknown error In creating trace - Please review'
Goto ErrorHandler
End
-- Set Events
-- Trace NTDomainName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 7, @on
-- Trace HostName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 8, @on
-- Trace IndexID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 24, @on
-- Trace RequestID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 56, @on
-- Trace SessionLoginName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 64, @on
-- Trace ClientProccessID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 9, @on
-- Trace IntegerData for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 25, @on
-- Trace LogionSid for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 41, @on
-- Trace RequestID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 49, @on
-- Trace NTUserName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 6, @on
-- Trace ApplicationName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 10, @on
-- Trace StartTime for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 14, @on
-- Trace ObjectID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 22, @on
-- Trace ServerName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 26, @on
-- Trace ObjectName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 34, @on
-- Trace XactSequence for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 50, @on
-- Trace DatabaseID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 3, @on
-- Trace LoginName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 11, @on
-- Trace NTDomainName for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 35, @on
-- Trace EventSequence for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 51, @on
-- Trace TransactionID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 4, @on
-- Trace SPID for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 12, @on
-- Trace ObjectType for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 28, @on
-- Trace IsSystem for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 60, @on
-- Trace EventSubClass for Object:Altered event
exec sp_trace_setevent @TraceID, 164, 21, @on
Is it necessary (or perhaps just beneficial, if not necessary) to create a paging file on the drive where SQL Server is installed along with the paging file on the OS drive. For example, Windows NT 4 is installed on the C drive, and SQL Server is installed on the D drive. Should I have a paging file on both drives. Someone mentioned to me that you should have a paging file for both drives, but I had never heard of that before.
Tony
Forgive me if this is a stupid question.
How do you use a Server Side block cursor?
Lets say I have a db of 250,000 items and I want to retrieve the data 100 rows at a time.
How would I do this (using a block cursor, not in general)
thanks,
I was asked if you can do "raise error" from the server side. I can do it from the client side but never had to do it server side. Is it possible at all, I can't find any documents on it. I'm using 6.5, and 7.0....
View 1 Replies View Related Is it necessary to have SSIS installed on the Server (SQL Server) in order to run SSIS programs? Or is SSIS just a client-side, developer tool that can create and test programs against various remote data sources (SQL, Oracle, flat files, etc.)?
What must be installed on the server in order to run SSIS programs?
Hi
I am doing a task for synchronize data between SQL server 2005 and SQL Mobile.
Created a publication in my SQL server 2005
Created a subscription in my device thru coding. The code is below.
SqlCeReplication repl = null;
try
{
repl = new SqlCeReplication();
repl.InternetUrl = @"http://localhost/TestFirst/sqlcesa30.dll";
repl.Publisher = @"zcs6";
repl.PublisherDatabase = @"TestNow72743";
repl.PublisherSecurityMode = SecurityType.DBAuthentication;
repl.PublisherLogin = @"sa";
repl.PublisherPassword = @"Test";
repl.Publication = @"TestFirst";
repl.Subscriber = @"TestNow7274310";
repl.SubscriberConnectionString = @"Data source = 'TestFirst.sdf';";
if (!File.Exists(@"TestFirst.sdf"))
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
repl.Dispose();
}
If I run this code from my device the replication work successfully. Now I am calling synchronize from device.
My question is How can i start synchronization from server side. Is it possible to do that from server side?
I have decided that I needed to modify my trace file name to include date and time in a further attempt to make my file name unique. See below snippet:-
-- Build File Name
select @hr = datepart(hh,getdate())
select @min = datepart(mi,getdate())
select @sec = datepart(ss,getdate())
set @time = convert(char(2),@hr) + convert(char(2),@min) + convert(char(2),@sec)
set @filedate = CONVERT(char(8),getdate(),112)
If @Hr = '12'
set @filename = @path + 'Activity_' + @filedate
Else
set @filename = @path + 'Activity_' + @filedate + '_' + @time
End
This works in part. However, when the time has a zero in it, the program will substitue the zero with a blank.
Can someone suggest a better method
Hi,
I'm migrating an Application from .net / oracle to .net / sql server express
In the Oracle DB, there are several Stored Procedures that return cursors that are thrown into DataSets in the application.
I'm converting the Data Access Layer class right now and I realized in this line of code:cmd.Parameters.Add(New SqlParameter("csr_out", OracleType.Cursor)).Direction = ParameterDirection.Output
that there is no
cmd.Parameters.Add(New SqlParameter("csr_out", SqlDbType.Cursor)).Direction = ParameterDirection.Output ???
What would be the equivalent of retrieving an Oracle cursor into a DataSet using SQL Server ?
Thanks
I have read ample technical papers on Cursors. I like to use cursors because it gives you a row by row control in a stored procedure. But most articles I have read advise against the use of cursors (server side).I typically use read only or Forward Only Cursors. This seems to be the best way to transpose data.My questions is, is there any guildlines to using cursors? Do you look at the performance of the cursor? If the query runs in 30 seconds and the cursor process is 15 seconds, is that acceptable (based on a million transactions, but filtering 1000-2000 records based on indexed fields.)?Or is it better to break cursor based steps into multiple queries with insert / update to generate a transposed output? Even if this involves a base query with multiple joins. Is it better to hammer SQL Server once and then output the results on a row by row, column by column basis, or do multiple queries.The bottom line is I have been able to provide the required output using cursors, but I just don't want to potentially bog down the system.Can anyone list specific cases where a cursor was a better method than multiple queries? And particularily with large volume data mining operations. Thanks DotNetNow
View 5 Replies View RelatedI'm using SQL Server 2008 R2 BIDS to accomplish this.
View 7 Replies View Relatedsuppose from my code behind i will pass my sql query to sql server store procedure and i want that scriptwill be written in such a way that my store procedure will execute my query and populate cursor and then cursor will be return from my store procedure to code behind.so i want to know is it possible in sql server if so pls give me a sample sql server store procedure code.
View 1 Replies View Related