• Slowdown of the SAN due to overusage of temporary tables

    We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error inserting into table with identity column

    I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the 2...

    Bleeb45 pointsBadges:
  • Stored Procedures in SQL Server 2005

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

    Rajanarina110 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Difference between Sp_msforeachdb and sp_msforeachtable

    In MS SQL Server what is the difference between Sp_msforeachdb and sp_msforeachtable

    Jaideep Khanduja12,670 pointsBadges:
  • How can I pass tablename as a parameter in MySQL stored procedure?

    my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...

    Minal45 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • Calling a stored procedure in a SELECT list on SQL Server 2000

    I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?

    SQL Server Ask the Experts2,585 pointsBadges:
  • how can make this SQL Server query faster

    All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200',...

    Singhal120 pointsBadges:
  • Create a database in SQL Server 2005

    Create a database in sql server 2005 but database name passed as parameter into a stored procedure

    Let5 pointsBadges:
  • conversion of SQL Server 2008 stored procedure to Oracle 10g

    Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g

    Oracle10gSQLserver20085 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:
  • SQL Server 2005 procedure to Create stored procedure

    sir,plz tell me the procedure from strating that how to create stored procedure

    Gkhlhlhjhhghgg15 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 do I modify stored procedures in sql 2005?

    Where can I view in SQL 2005 when a stored procedure was run and what its outcome was? Can I see who ran it? Can I see who modified the job?

    Karl Gechlik9,860 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:
  • Exclude Login from SQL Audit Trace

    I'm working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I'm using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login...

    VelameLaCosa110 pointsBadges:
  • AS/400 SQL Procedure call from CL program

    I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.

    Burmanr10 pointsBadges:
  • Set DataTable name in returned data set

    I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is...

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

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

Following