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

    Joetig35 pointsBadges:
  • 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?

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

    DJandLO130 pointsBadges:
  • 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 in the file...

    ItsHer20 pointsBadges:
  • 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 a bunch...

    Oscarius5 pointsBadges:
  • optimization of stored procedures in sqlserver

    is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh

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

    Rusty25 pointsBadges:
  • 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

    Implicitcherry5 pointsBadges:
  • SQL Server project in VB 2005

    A form contain two text field (Name,Address) three buttons (Save,Modify,Delete). A test.mdf file in sql server. I want total source code of that sample project Pl help me about that. Thank you prit

    PRITH5 pointsBadges:
  • Stored Procedures in SQL Server 2005

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

    Rajanarina110 pointsBadges:
  • 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 CHAR(35), IN...

    Dfe07225 pointsBadges:
  • 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

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

    TeachMeIT975 pointsBadges:
  • How can I take a backup of a SQL Server stored procedure only?

    How can I take a backup of a SQL Server stored procedure only?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 if the sub...

    Palloquin95 pointsBadges:
  • 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?

    Karl Gechlik9,860 pointsBadges:
  • xp_fileexist workd in Query window but doesnt in stored procedure

    Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...

    Kendo5 pointsBadges:
  • Call Stored Procedure Multiple times

    I want to use a SQL script that takes values from one table and then calls a stored procedure multiple times for each of those values. Each time, I am passing in those values as a parameter for each stored procedure call. How can I do that?

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

    MapleLeafDeveloper5 pointsBadges:

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