Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-08 : 12:19:10
|
clint writes "/* Help! I can't get my triggers to execute stored procedures and I can't get stored procedures to execute stored procedures.
I'm running SQL Server 7.0 on a Win2000 machine. Below is an example of my code. A stored procedure trying to execute another:
*/
CREATE PROCEDURE sp_PumpAppIn
@TheBigMamaString text,
@TheAppNumber numeric
AS
BEGIN
if NOT exists(Select * From TheAppsAchive Where The_App_Key = @TheAppNumber)
BEGIN
INSERT INTO TheApps(The_App_Key, The_App_Data)
values(@TheAppNumber, @TheBigMamaString)
INSERT INTO TheAppsAchive(The_App_Key, The_App_Data)
values(@TheAppNumber, @TheBigMamaString)
EXECUTE sp_SendAppToSTAR @FromWhr = N'site', @TheAppNumber = N@TheAppNumber
END
else
return(0)
END" |
|
|
|
|
|
triggers and procedures not able to execute each other