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 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…