I have created the following SQL Server stored procedure:
CREATE PROCEDURE dbo.cp_proc1
(@birthDate smalldatetime)
AS ....
How do pass the "smalldatetime" parameter when debugging this procedure?
I get this error: "Invalid character for cast specification". It's a syntax error when passing the parameter.
Thanks in advance,
Xavier Castillo