|
Hi, I am attemting to create a storedproc that reads like:
Select ep.EmployeeID, GetEmployeeFirstName(ep.EmployeeID), GetEmployeeLastName(ep.EmployeeID), ed.EmployeeDateOfBirth, ed.EmployeeAddress, ed.EmployeeAddress2, ed.City, ed.State, ed.ZipCode From...
Started by Csharp on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I don't understand what these stored solution than a stored procedure....
(BTW statement list I would convert it to a database Function .
You can use EXEC or sp_executesql to execute a stored procedure from another stored procedure.
|
|
I am working on a stored proc (parent) that calls another stored proc (child). The child proc returns a record set with 1 row every time.
What I need to do is pull the data from the child proc and use it in the parent proc. Using methodology from MSSQL...
Started by Tempname on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at stackoverflow):
If you're trying to return a value, why not use a function instead of a procedure?
DROP TABLE IF EXISTS Filename; CREATE TABLE Filename( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, PRIMARY KEY (id) ); INSERT INTO Filename... .
|
|
I have a Stored Procedure that rolls-back a series of operations. I want to call this from within another SP.
The problem is that the inner SP returns a record set with a single value that indicates the degree of success.
This approach worked well and...
Started by CJM on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The other option is to convert the stored procedure that returns a recordset into a function.
A stored procedure returns a record set like any other, so you can actually do this:
INSERT.
|
Ask your Facebook Friends
|
My program has code that saves attachments, I want these attachments to be transferred to the database, and I am going to use a stored procedure to accomplish this.
I need to know what is the @param type to accept an array of binary files?
finally once...
Started by JL on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It may also technically work if you pass binary ... .
You can perform select from XML with SQL just as easily as from a table .
If you were needing only to pass an array of values, I would suggest to format them as XML and pass them as the SQL xml datatype .
|
|
Got a strange problem created a little stored proc which need to execute a couple of other stored procs to get some values before executing the main select statement see below,
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_get...
Started by Jon on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
EXEC:
declare @applicationId int; declare @tableApplicationId table://www.sommarskog.se/share_data.html....
A stored procedure returns a number indicating the execution status of the stored procedure of a stored procedure is INSERT ...
|
|
I have a stored proc called via LINQ to SQL the stored proc calls another stored proc within it and has a SELECT to output the result. the SELECT result doesnt' get returned to my LINQ to SQL, I can only get the int result value. How can I get the select...
Started by monkeylee on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This way the designerThe LINQ designer is not....
Then, change the stored proc back to the original.
Remap it in the designer.
One work around is to temporarily change your stored proc to a simple select of the proper schema.
|
|
Hi:
We have the ability to execute stored procs from the middle-tier. Basically, in a database table called "SQLJobStep" we have -- among other things -- a varchar(300) column called "StoredProcedure" which holds something like this:
usp_SendReminderEmails...
Started by Yoav on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What I....
This auditing proc inserts a record into an audit table and then returns Job proc).
I described originally:
In the usp_SendReminderEmails proc, we call another proc in order to audit each e-mail record that is sent.
|
|
Is it possible to check is there any stored proc currently running in SQL Server???
Started by WeeShian on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
stored-procedures-are-running-currently.
|
|
I am finding that calling a stored proc in Excel is not as easy as it should be, but calling a view, or a direct table is very easy. So, how can I create a view that will call a stored proc with no params?
I know I won't be able to pass any values into...
Started by Russ on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This is definitely a hack, and you would want to really lock down permissions on the table and proc.
You should be able to put a trigger on a dummy table, and call the proc inside the trigger.
|
|
Why opensource database like Postgresql and Mysql don't have encrypted stored proc?
Is it because of their innate open source philosophy?
What are the compelling reasons to encrypt the stored procs?
Started by Hao on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Business programming should not be centered around and stored, encrypted....
InterBase stored a copy of the trigger/proc source in a BLOB field, and a compiled version encrypted stored procedures are a distinctly bad idea.
The code.
|
