Parameter in stored procedure


Author
Message
Ian Johnston
Ian Johnston
StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)
Group: StrataFrame Users
Posts: 77, Visits: 470
How do you define a parameter for a stored procedure in DDT, I have put @current DATE in the pre-create section but it gives a syntax error when I try to send it to the server.
StrataFrame Team
S
StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)StrataFrame Developer (3.1K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
The DDT will output "CREATE PROCEDURE " + [the procedure name] + [the procedure body].

So, you'll want to put the procedure body like this:

@startDate DATETIME,
@stopDate DATETIME,
@userPk INT
AS
BEGIN
    -- blah blah blah
END
Ian Johnston
Ian Johnston
StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)StrataFrame Novice (77 reputation)
Group: StrataFrame Users
Posts: 77, Visits: 470
Thank You
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search