python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - stored-procedures

How to run series of values through stored procedure

I have a stored procedure that I need to run a list of values through and output into a temp table. This is the SP: EXEC [SP_ReturnHTML] @zoneid, 1 The first value, I assume, will be a variable and th...
test-img

jw11432

sql-server

stored-procedures

while-loop

database-cursor

Votes: 0

Answers: 1

Latest Answer

Something like this: drop table if exists #results drop table if exists #Data go create or alter procedure [SP_ReturnHTML] @value int, @s varchar(20) as begin select concat(' value=',@value, '; s ...
test-img

David Browne - Microsoft

SSIS Execute SQL Task continue execution after completion of Oracle stored procedure

I have an Oracle stored procedure I am trying to execute in SSIS Execute SQL Task. This stored procedure involves refreshing materialized views. For each and every step completion we are logging it in...
test-img

PK1128

sql-server

oracle

stored-procedures

ssis

Votes: 0

Answers: 1

Latest Answer

You can Debug your SSIS Package in Visual Studio to see what's going on. You will need "SQL Server Integration Services Project" software for this. You can install it from VS MarketPlace OR ...
test-img

Gaurav Shah

Stored procedure to create view with dynamic ID based on another table

I have a little problem with creating view based on another table. My first approach was to create variable and assign length of the table to variable, then create view and in loop insert dynamically ...
test-img

Wilk Rafał

sql

sql-server

tsql

stored-procedures

view

Votes: 0

Answers: 1

Latest Answer

Sounds to me like Row_Number() is what you are looking for. Try using this to create your view. CREATE view myView AS SELECT Row_Number() OVER(ORDER BY ID) ID, Name FROM dbo.table_1
test-img

Austin557

Postgres Exception handling in stored procedure to continue the process

Database is postgressql. I want to call five stored procedure in on stored procedure that is master_call_all() and need to handle exception after every call. So if any error occur it raise the excepti...
test-img

Raghav

postgresql

stored-procedures

Votes: 0

Answers: 1

Latest Answer

First off: In general this is an extremely bad plan. It is the anti-thesis of creating a Transaction (begin ... end). Transactions are a fundamental concept of all database systems. The essential poi...
test-img

Belayer

Posts

Questions

Blogs

Jobs