1
  • Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN20006,360 pointsBadges:
  • 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?

  • 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...

    CO Bill120 pointsBadges:
  • 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...

    Eabouzeid175 pointsBadges:
  • 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...

    Neilo125 pointsBadges:
  • 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.

    VPL95 pointsBadges:
  • 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 *...

    Anilak singh5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following