New Data Field in Stored Procedure
When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?

Answer Question   |  May 3, 2012  3:09 PM
Stored Procedure variables

SP Dynamic SQL with LIKE Operator
Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this: CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR SELECT * FROM TABLE1 WHERE FIELD1 LIKE ‘%@VARIABLE1%’ Then to execute the procedure, EXEC SPFIND ‘VARIABLENAME’ I can’t get this to work using the LIKE [...]

Answer Question   |  June 8, 2010  12:38 PM
Dynamic SQL, SQL Server 2005, SQL stored procedures, Stored Procedure variables

How to pass a store procedure and a variable to a datagrid
I am a newbie when it comes to passing parameters to a control. I am programing in VS 2008 using VB as the language. The grid is in an ASP.Net (3.5) page  I have set up a store proceduer in SQL Server 2005 as follows: CREATE PROCEDURE   usp_selEmpSSN–Transfer all records from tbl_CL with the [...]

Answer Question   |  January 14, 2010  4:25 PM
GridView Control, Stored Procedure variables

stored procedure in delphi with oracle
how to match the datatype of the field that is in database and the datatype of the variable that holds the value of the returned value from database using stored procedure.

Answer Question   |  December 29, 2008  1:50 PM
Delphi, Delphi 5, Oracle, Oracle stored procedures, Stored Procedure variables

SQL Server equivalent of Oracle’s “when no data found” exception
In a stored procedure, I’m storing the result of a select statement in @variable. Is there a way to capture a SQL Code 100, like Oracle’s SQLERRM(100)/ORA-01403 if no records are returned? I’m currently setting @variable = ‘*’ before the select and and IF @variable = ‘*’ afterwards, but there must be a more elegant [...]

Answer Question   |  March 6, 2012  2:41 PM
SELECT statement, Stored Procedure variables, Stored Procedures

Stored Procedure Problem
Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select * [...]

Answer Question   |  March 21, 2008  3:34 PM
SQL, Stored Procedure variables, Stored Procedures