Topic profile page for Stored procedures.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Stored procedures.
Topic "Stored procedures" was discussed 4,460 times on 344 sites in last 3 months
Started 1 day, 8 hours ago (2009-11-15 10:08:00)
by SivaT
Hello, I have seen a post in msdn forums on sql server ce posted in year 2005.it has been replied like next versions will support stored procedures,so now any version of sql server ce supports stored procedures.if so which is that version as i am developing a windows mobile application and is there any possibility to give printing option in windows mobile application. Regards
Started 2 days, 18 hours ago (2009-11-13 23:46:00)
by MS Forum Newgroup User
Hi all, I'm trying to create a procedure that contains a temp variable that I can use further in the procedure, so that I can use the result from the first query in the second query: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[GetDetails] @ID int, @IDName varchar(100), @tempvar varchar(100) as begin Select @IDName AS tempvar from tbl_main where tbl_main.id = @ID SET @...
Started 2 days, 22 hours ago (2009-11-13 20:10:02)
by ppalubinski
That is the question! I have a general understanding of stored procs and when you should use them, but I was wondering if there were any hard and fast rules and if anyone swears by them and uses them all the time (and if so, why?). Any thoughts, suggestions, ideas would be greatly appreciated.
Started 3 days, 2 hours ago (2009-11-13 16:21:00)
by MS Forum Newgroup User
Hi all, I'm trying to create a procedure that contains a temp variable that I can use further in the procedure, so that I can use the result from the first query in the second query: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[GetDetails] @ID int, @IDName varchar(100), ...
Started 3 days, 11 hours ago (2009-11-13 07:02:00)
by Antnee
Hi guys, I've got to create a data import routine for a MySQL database. We're getting the data in using the CSV engine (tested and working great) but when the file is imported, I need to be able to then transfer that data in to a MyISAM table. I figure that we'd do something like: Get the first line from the CSV table Check whether this already exists in the MyISAM table If not, import ...
Started 4 days, 1 hour ago (2009-11-12 17:08:00)
by solvetek
I am running db2 v9.5 on XP. When I try to catalog the sample stored procedures I get the following errors SQL20204N The user defined function or procedure "U000591.TWO_RESULT_SETS" was unable to map to a single Java method. LINE NUMBER=10. SQLSTATE=46008 CREATE PROCEDURE TWO_RESULT_SETS (IN salary DOUBLE) SPECIFIC JDBC_TWO_RES_SETS DYNAMIC RESULT SETS 2 NOT ...
Started 4 days, 1 hour ago (2009-11-12 17:04:00)
by solvetek
I am running db2 v9.5 on XP. When I try to catalog the sample stroed procedures I get the following errors SQL20204N The user defined function or procedure "U000591.TWO_RESULT_SETS" was unable to map to a single Java method. LINE NUMBER=10. SQLSTATE=46008 CREATE PROCEDURE TWO_RESULT_SETS (IN salary DOUBLE) SPECIFIC JDBC_TWO_RES_SETS DYNAMIC RESULT SETS 2 NOT ...
Started 4 days, 6 hours ago (2009-11-12 12:09:00)
by Sanchez33333
> Hi there, I have an interesting problem which has stretched my SQL Server knowledge to the limit! Basically, I am setting up an automated system which generates reports based on info taken from two systems (i.e. which customer info on one system is not yet on another, by product, age etc) - It may sound complicated but I've already managed to write the actual ...
Started 4 days, 22 hours ago (2009-11-11 20:17:00)
by mtougeron
I'm having some trouble using a stored procedure when using sql_query_range. When I use a stored procedure it will properly call the procedure with the first set of values in the $start & $end macros. But it only calls the procedure once, it does not continue the loop until it reaches the MAX(TopicID). I'm using mysql 5.0.44. The examples below are greatly simplified but they accurately ...
Started 5 days, 4 hours ago (2009-11-11 14:09:00)
by snorlaks
Hi, My problem contains two issues which I would like to resolve. First can anyone help me with writing stored procedure that will create table with name and columns passed as arguments. There may be as much columns as user wants to and I would like to be able to pass arg. column name column type, ... Is it possible ?? Second issue is that I would like to call that stored procedure...
Started 1 week ago (2009-11-09 13:36:00)
by user8663768
HI all I am trying to call a package before running a report so that the report has to fetch the data from the table after the procedure runs. 1. Created a new physical table. 2.Changed the table type to stored procedure. 3.Entered the following: declare PRAGMA AUTONOMOUS_TRANSACTION; BEGIN hr_org_headcount_pkg.GET_EMP_HEAD_...
Started 6 days, 11 hours ago (2009-11-10 06:47:00)
by sookie
Hi All, Pardon my ignorance but in BI Publisher's latest documentation, I couldn't find anywhere how to use stored procedures in BI Publisher? Is it possible to use them or only SQL queries can work through that "Query Builder" provided in GUI? Thanks Sookie
Started 3 days, 1 hour ago (2009-11-13 17:16:00)
by Antnee
OK, I've got it working as I want it to, but it's a bit messy and could really do with cleaning up: MySQL Code: BEGIN DECLARE c BIGINT ( 10 ) ; DECLARE x BIGINT ( 10 ) ; DECLARE passed BIGINT ( 10 ) ; DECLARE failed BIGINT ( 10 ) ; SET x = 0 ; SET passed = 0 ; SET failed = 0 ; SELECT count ( * ) INTO c...
Started 2 days, 17 hours ago (2009-11-14 01:01:02)
by RickNZ
I guess I should say that SPs are considered a best practice -- but that doesn't mean they're right for every application. There are cases, such as RAD, where fast-and-loose dynamic SQL might be better. I would say that in my experience projects tend to fail when there's an impedance mismatch between business requirements and engineering. A project might be under-engineered so that it can be ...
Started 3 days, 6 hours ago (2009-11-13 11:57:00)
by solvetek
I fixed the nmake problem but I still get the following message: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20204N The user defined function or procedure "U000591.TWO_RESULT_SETS" was unable to map to a single Java method. LINE NUMBER=10. SQLSTATE=46008
Rick, right now, no SQL Server components are installed on my Windows XP Pro laptop. I went to your link to download Management Studio. However, after I saved the file and ran the .exe, it seems that it wants to install the full version of SQL Server 2008 Express - is that correct? And it will automatically install Management Studio during the install? Thanks, Toni > If you installed one...
Started 5 days, 15 hours ago (2009-11-11 03:21:00)
by Linchi Shea
One way is to try to estimate the plan for each proc: set showplan_text on go EXECUTE p_yourProc go set showplan_text off go You'll get an error if the proc is no longer valid. Linchi > Is there a script or functionality in SQL Server 2000 that can check the > syntax on all stored procedures in a database? [quoted text clipped - 11 lines] > > Thanks.
Started 4 days, 6 hours ago (2009-11-12 12:31:00)
by X002548
> can you post the table ddl, sample data and what the expected results should be? If the data is x, then do y ???? Brett 8-) Hint: Want your questions answered fast? Follow the direction in this link http://weblogs.sqlteam.com/brettk/archive/2005/05/ 25/5276.aspx Add yourself! http://www.frappr.com/sqlteam
