Stored Procedures

Permissions for writing stored procedures in MySQL

Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure,...

Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it...

stored procedure component

what is the difference between the way of using storedprocedure component in delphi5 and delphi7?

Is there a way to retrieve datatypes from stored procedures?

I have used the following simple query to retrieve datatypes from sql 2000 tables. select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Is there a...

ALTER INDEX statement

'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code ,...

Inserting rows and multiple rows in SQL Server 2005 Express

Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

IF ELSE in SQL Server stored procedure

i am using this code which is giving error. if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into...

PLS-00103: Encountered the symbol "E_PROD_REQ_ID_NOT_FOUND" when expecting one of the following:

how can i resolve that error? when i compile the store proc....it compiled without any errors....but in a package its throwing error

SSRS Performance

I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure.When Executing from SP it is taking just 3 Seconds but when executing from SSRS report It is taking more than one Minuits.How i can solve this problem?

Setting a range constraint without a stored procedure in a SQL Server table

I have a table in SQL Server named CustInfo that is as follows: table CustInfo ( startdate datetime enddate datetime CustomerCode int address nvarchar(200) ) I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For...

Date formats in SQL Server Stored Procedures

This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on Sql Server...

SSIS package

I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA's suggested me to go with SSIS Package. Can any one quide me in doing this.

Strange Stored Procedure Behavior (Dev vs Prod)

I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in the first...

Spooling Oracle Output via SQL DTS

I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

Triggering a stored procedure from C#

how to tigering a sp from c#???

Creating a stored procedure in SQL

I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

SharePoint profile import error

When performing a full or incremental profile import, I always get these three errors in the event viewer: A runtime exception was detected. Details follow. Message: Could not find stored procedure 'proc_ar_BumpCacheInvalidationCounter'. Techinal Details: ...

How can i connect DB and input values in stored procedures using VBA

hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me....

Creating stored procedures to execute tables at runtime on a SQL Server

I’d like to execute different tables at runtime on my SQL Server by creating stored procedures. This is the syntax I am attempting to use: "create procedure sp1(colname varchar(400), tab_name IN varchar2) AS BEGIN select * from '@TABLENAME' where CompanyName='@COLUMNNAME' end" Is this syntax...

Setting aside code for 12 databases in separate database on SQL Server

I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all...