StrataFrame Forum

Parameter in stored procedure

http://forum.strataframe.net/Topic33485.aspx

By Ian Johnston - 3/27/2017

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.
By StrataFrame Team - 3/27/2017

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
By Ian Johnston - 3/27/2017

Thank You