Parameter in stored procedure

Author	Message
Ian Johnston	Ian Johnston posted 7 Years Ago Topic Details Share Topic
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.
	Reply Like 2
StrataFrame Team	S StrataFrame Team posted 7 Years Ago Post Details Share Post
S 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
	Reply Like 2
Ian Johnston	Ian Johnston posted 7 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 77, Visits: 470	Thank You
	Reply Like 2