Function call procdure,error is “Only functions and some extended stored procedures can be executed from...
0
I create a function like this:
CREATE FUNCTION [dbo].[GetAnnouncementID]()
RETURNS INT
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
RETURN @AnnouncementID
END
GO
Then I use select dbo.GetAnnouncementID() to get the return value,but the error message is:
Only functions and some extended stored procedures can be executed from within a function.
How to fix it?
sql-server asked Nov 20 at 1:29
Rhaegal
33614
add a comment |
0
I create a function like this:
CREATE FUNCTION [dbo].[GetAnnouncementID]()
RETURNS INT
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
RETURN @AnnouncementID
END
GO
Then I use select dbo.GetAnnouncementID() to get the return value,but the error message is:
Only functions and some extended stored procedures can be executed from within a function.
How to fix it?
sql-server asked Nov 20 at 1:29
Rhaegal
33614
3
you can't execute a sproc inside the function
– maSTAShuFu
Nov 20 at 1:30
add a comment |
0
0
0
I create a function like this:
CREATE FUNCTION [dbo].[GetAnnouncementID]()
RETURNS INT
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
RETURN @AnnouncementID
END
GO
Then I use select dbo.GetAnnouncementID() to get the return value,but the error message is:
Only functions and some extended stored procedures can be executed from within a function.
How to fix it?
sql-server asked Nov 20 at 1:29
Rhaegal
33614
I create a function like this:
CREATE FUNCTION [dbo].[GetAnnouncementID]()
RETURNS INT
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
RETURN @AnnouncementID
END
GO
Then I use select dbo.GetAnnouncementID() to get the return value,but the error message is:
Only functions and some extended stored procedures can be executed from within a function.
How to fix it?
sql-server sql-server asked Nov 20 at 1:29
Rhaegal
33614
asked Nov 20 at 1:29
Rhaegal
33614
asked Nov 20 at 1:29
Rhaegal
33614
asked Nov 20 at 1:29
Rhaegal
33614
asked Nov 20 at 1:29
Rhaegal
33614
33614
3
you can't execute a sproc inside the function
– maSTAShuFu
Nov 20 at 1:30
add a comment |
3
you can't execute a sproc inside the function
– maSTAShuFu
Nov 20 at 1:30
3
3
you can't execute a sproc inside the function
– maSTAShuFu
Nov 20 at 1:30
you can't execute a sproc inside the function
– maSTAShuFu
Nov 20 at 1:30
add a comment |
1 Answer
1
active
oldest
votes
1
Change it to an SP and modify your code to call an SP as follows:
CREATE procedure [dbo].[GetAnnouncementID]()
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
select @AnnouncementID
END
GO
answered Nov 20 at 1:33
Dale Burrell
2,73512147
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
1
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
2
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
|
show 1 more comment
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384971%2ffunction-call-procdure-error-is-only-functions-and-some-extended-stored-procedu%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Change it to an SP and modify your code to call an SP as follows:
CREATE procedure [dbo].[GetAnnouncementID]()
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
select @AnnouncementID
END
GO
answered Nov 20 at 1:33
Dale Burrell
2,73512147
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
1
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
2
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
|
show 1 more comment
1
Change it to an SP and modify your code to call an SP as follows:
CREATE procedure [dbo].[GetAnnouncementID]()
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
select @AnnouncementID
END
GO
answered Nov 20 at 1:33
Dale Burrell
2,73512147
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
1
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
2
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
|
show 1 more comment
1
1
1
Change it to an SP and modify your code to call an SP as follows:
CREATE procedure [dbo].[GetAnnouncementID]()
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
select @AnnouncementID
END
GO
answered Nov 20 at 1:33
Dale Burrell
2,73512147
Change it to an SP and modify your code to call an SP as follows:
CREATE procedure [dbo].[GetAnnouncementID]()
AS
BEGIN
DECLARE @AnnouncementID int
EXEC @AnnouncementID =DB1.dbo.PROC_GetID
select @AnnouncementID
END
GO
answered Nov 20 at 1:33
Dale Burrell
2,73512147
answered Nov 20 at 1:33
Dale Burrell
2,73512147
answered Nov 20 at 1:33
Dale Burrell
2,73512147
answered Nov 20 at 1:33
Dale Burrell
2,73512147
2,73512147
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
1
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
2
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
|
show 1 more comment
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
1
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
2
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
Hi,where can I find an example?
– Rhaegal
Nov 20 at 1:37
1
1
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
Example of what? I've written the SP for you...
– Dale Burrell
Nov 20 at 1:40
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
@Burrell I must use function,not procedure,bucasue I use the value in merge.
– Rhaegal
Nov 20 at 1:43
2
2
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
You can't call an SP from within a function - there is no way around that other than to change your approach. You can return the results of an SP into a temp table and then merge that?
– Dale Burrell
Nov 20 at 1:45
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
OK,anyway, thank you.
– Rhaegal
Nov 20 at 1:46
|
show 1 more comment
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384971%2ffunction-call-procdure-error-is-only-functions-and-some-extended-stored-procedu%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
you can't execute a sproc inside the function
– maSTAShuFu
Nov 20 at 1:30