• SQL Server: Create table to hold result of stored procedure

    With SQL Server, I usually write a query like this: create table #table_name ( column1 int, column2 varchar(200) ... ) insert into #table_name execute some_stored_procedure; But here's my issue: When creating a table to have the right syntax as the result of the stored procedure is too long of a...

    ITKE380,325 pointsBadges:
  • SQL Server: Query is filling up TEMPDB database

    I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

    ITKE380,325 pointsBadges:
  • SQL Server 2012 – Profile stored procedures

    I'm currently using SQL Server 2012 and I'm trying to figure out if I can profile stored procedures. I need to capture each SQL Statement in my stored procedures (basically how long it takes to run). Thanks so much.

    ITKE380,325 pointsBadges:
  • Copy SQL stored procedure from local to live database

    Hello, I want to copy multiple procedures from a local database to a live database?

    vikasbhatt25 pointsBadges:
  • How to send stored procedure parameter to Trigger?

    I am sending a parameter from ASP.NET web API to a stored procedure. Now how do I send that SP parameter to Trigger?

    AnshuRishiPratapReddy5 pointsBadges:
  • SQL Server: Parameterize IN clause

    Is there a way to parameterize an SQL query that contains an IN clause with a variable number of arguments? Something along the lines of this: select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc I don't want to use a stored procedure/XML so what's the best...

    ITKE380,325 pointsBadges:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1230 pointsBadges:
  • Call a stored procedure on a SQL Server from my RPGLE source using JDBCR4 service program.

    Something is going wrong while setting up the connection environment (ZBCCNNPF). Can someone explain me which parameters have to be set in which way to make this process work? Kind regards, Ton Konings.

    TonKonings196215 pointsBadges:
  • Calling COBOL program from native DB2 stored procedure

    Can we call COBOL program from native DB2 stored procedure? Or can we call external COBOL stored procedure from native DB2 stored procedure?

    Tanmay2115 pointsBadges:
  • SQL Server 2014: Automatic update trigger if the record is duplicate

    I am using SQL 2014 and want to insert and update a lot of records within a Stored Procedure, and then have a trigger to rollback the record if it already existed and then update just after the rollback. Is there a better way of doing this?

    edwinjhoffer3,140 pointsBadges:
  • Link two stored procedures in one Crystal Report

    Hi, In a report called ICD_PrivateHospital, I have designed to show output to two table from two store procedures. 1st store proc: usp_RPT_Private and 2nd store proc: usp_RPT_Private2.I have created both the store procs and it is executing successfully. I also have designed the Crystal Report in...

    durganippy2610 pointsBadges:
  • Backup stored procedures in MySQL

    With MySQL, I've been using mysqldump to back it up daily. But how do I store stored procedures? Is it backed up with everything else?

    ITKE380,325 pointsBadges:
  • DB2 Cobol stored procedure example

    DB2 Cobol stored procedure example FETCH  sql =-504

    eugene575 pointsBadges:
  • Performance Tracking of Stored Procedures

    We have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each...

    Pcrum735 pointsBadges:
  • 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:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • Triggering a stored procedure from C#

    How to trigger a SP from C#?

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

    Keck5 pointsBadges:
  • When submitting a procedure via CL program, I do not get any abnormal end message.

    When submitting a procedure via CL program, I do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,290 pointsBadges:
  • Locating default library in AS/400 with iSeries

    I'm having trouble figuring out how to boot to the default library while connecting to an AS/400 stored procedure layer using the IBM iSeries Access for Windows package. This set-up works through.NET DLL with classes similar to those in the System.Data namespace, and therefore uses its connect...

    ITKE380,325 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