• Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

    I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

    ITKE407,390 pointsBadges:
  • Search text in SQL Server stored procedure

    For SQL Server, I'm trying to search a text from all of my database stored procedures. Here's the code I'm using: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like '%[ABD]%'; But I'm not getting...

    ITKE407,390 pointsBadges:
  • Setup query execution plan for stored procedure in SQL Server

    I'm currently using SQL Server and I need to setup a query execution plan for my stored procedure. How can I go about this? Can I use SSMS? Thanks!

    ITKE407,390 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: 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...

    ITKE407,390 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.

    ITKE407,390 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.

    ITKE407,390 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:
  • 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...

    ITKE407,390 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,205 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?

    ITKE407,390 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:

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