March 22, 2005 Tuesday Yin:
Try to do two stored procedures, huh, it is very good! When an empty value is inserted, use NULL instead of the missing parameters, it will be completed smoothly.
Create a stored procedure: create procedure procedurename @ parameter1 valueetype1, ... as the sql-body (with @ parameter1 ... Enter parameter value) GO.
Call the stored procedure: ProcedureName Parameter1, ...
How is it, very simple? !
