When returning a string from a stored procedure as a return parameter, we must set it to a non-null value before the stored proc is called – even if it’s an output-only parameter. So we’ll need to make your parameter have a direction of InputOutput and set a default value: <asp:Parameter Name=”MyReturnParameter” Type=”String” Direction=”InputOutput” DefaultValue=”A […]
Tag: return
How to return only the Date part from SQL Server DateTime datatype
SELECT CONVERT(DATE, GETDATE())
How to return only the Date from a SQL Server DateTime datatype
–You can change GETDATE() with the date you want to use SELECT CONVERT(date, GETDATE())