Is it possible to create a procedure with a table value parameter as an optional parameter.
I tried the following code:
CREATE PROCEDURE SP
@Table testteype = null READONLY
AS
....
But I get this error:
Operand type clash: void type is incompatible with test type
ps: I use sql server with C#.Net
See Question&Answers more detail:os