Stored procedures
What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.

Answer Question   |  February 12, 2013  6:33 AM
SQL statement, Stored Procedures

SQL server
i want to copy  the store peocedure from one database to another . iam using sql2005

Answer Question   |  June 14, 2012  11:11 AM
Stored Procedures

SQL Server Help
Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]

Answer Question   |  March 31, 2012  8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures

Stored Procedure and crystal reports resources
Can anyone please tell me where to buy store procedure and crystal reports book in one.  Thanks.

Answer Question   |  March 31, 2012  5:41 PM
Crystal Reports, Crystal Reports Stored Procedures, IT Books, Stored Procedures

Validating Active Directory login from within a stored-procedure
I have an application that needs to use active directory to ensure user login is valid. The issue is that the machine is in a different domain than our AD server. I am looking at creating a clr procedure on the SQL server that is in the same domain. Then from the application execute a procedure [...]

Answer Question   |  July 5, 2011  3:14 PM
Active Directory, Active Directory security, CLR Active Directory, Stored Procedures

Modifying a Stored Procedure
The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don’t want it showing up on the [...]

Answer Question   |  June 9, 2011  2:31 PM
Crystal Reports, SELECT statement, SQL, SQL Database, SQL stored procedures, Stored Procedures

Related to SQL server 2005
When we write store procedure it is encrypt by –with encrypt tag means it will locked it doesn’t show sp so how it will be DECRYPT?

Answer Question   |  June 10, 2011  4:39 AM
Decryption, SQL Server 2005, SQL stored procedures, Stored Procedures

Can’t close or clear file in iSeries V5R3
Generally we create a file in QTemp when returning data for a stored procedure. The cursor is left open so the data can be accessed. I neglected to copy the file to qtemp and now on our test system, I can’t close the file, I can’t clear the file. I’ve deleted each of the records [...]

Answer Question   |  March 10, 2011  7:09 PM
iSeries, Stored Procedures, V5R3

Thousands and thousands of simultaneous users hitting a sproc — what do you do?
folks, i am not a db guy altogether, but I am a developer, and someone had asked me that question, and i got interested in the resolution. Lets say you have 50K users that hit the same stored procedure at the same time. The stored procedure is computation intensive and goes out to lunch for [...]

Answer Question   |  February 16, 2011  12:14 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures

How to populate datagrid using store procedure
m trying to populate a datagridview using a store procedure called from  a module but it is givign me some problem as in my module i use the Function as a bindingsource can someone help me here im totally lost

Answer Question   |  February 1, 2011  10:20 PM
DataGridView, Stored Procedures, Visual Basic, Visual Basic developers

Cross-database name change in SQL Server 2008 stored procedures
Hi: The easy part is the databases will be on the same server.  However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST.  When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE.  However the queries in SOMEDATABASE_TEST stored procedures read: [...]

Answer Question   |  February 2, 2011  5:03 PM
SQL 2008, SQL Server 2008 R2, SQL Server stored procedures, Stored Procedures

Stored Procedures in SQL Server 2005
Will you please explain me about Stored Procedures in Sql server 2005

Answer Question   |  January 13, 2011  4:53 AM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures

Example of Cobol call to an SQL stored procedure
I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName [...]

Answer Question   |  December 3, 2010  6:05 PM
COBOL, iSeries, iSeries Cobol programming, SQL stored procedures, Stored Procedures

How to find particular database in SQL stored procedures other than manually?
Hi all, i have a Stored Procedure, i need to find the database in which the particular SP is available, i dont want to go through all the SP’s……….. Is there any way to find the database using server name, i need the query for this.. Please help me

Answer Question   |  November 11, 2010  6:28 AM
SQL Database, SQL Server, SQL Server stored procedures, Stored Procedures

Documenting stored procedure jobs in SQL 2005 enterprise
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

Answer Question   |  November 1, 2010  2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008

Row by Row Stored Procedure in SQL Server 2008 R2
Hi All, hopefully someone will be able to help me here – i am nearly there but can’t get it right, i am trying to create a stored procedure that when runs will do a query and then send send an email out for each of the rows that it returns. e.g. if i have [...]

Answer Question   |  October 4, 2010  1:36 PM
SQL, SQL Server 2008, SQL Server 2008 R2, SQL stored procedures, Stored Procedures

Log of stored procedures run on my SQL 2005 box.
How can I tell who ran which stored procedure on our SQL 2005 server and at what time? Can we see if one stored procedure called other stored procedures there as well? Can we enable verbose logging somehow as well for more data?

Answer Question   |  September 15, 2010  5:22 PM
SQL, SQL 2005, SQL Log Files, SQL Server 2005, SQL Server stored procedures, Stored Procedures

ADO not receiving errors raised in sub procedure
Hi, I’v known for a while that ado has it’s limits when it comes to dealing with errors… but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that [...]

Answer Question   |  September 16, 2010  11:42 AM
ActiveX, ActiveX Data Objects, ADO, ASP, SQL Server 2008, Stored Procedures, VBScript

Receiving result sets in RPG (prior to release 7.1) from an SQL SP
I have read through the IBM manual “Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries” for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this as it cannot access the result set [...]

Answer Question   |  August 26, 2010  5:45 PM
i5, RPG, SQL, SQL stored procedures, Stored Procedures

Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?
Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

Answer Question   |  August 16, 2010  2:48 PM
Database design, Print screen, Stored Procedures