jvrck · August 4, 2015 23:18
diff --git a/sql_server_optional_parameters.sql b/sql_server_optional_parameters.sql
 /*
 source: http://stackoverflow.com/questions/11092576/sql-query-with-optional-parameter-and-possible-null-column

 Add optinal parameters to SQL scripts or sps
 */
 select id, customername
 from customertable
 where 
 (referredby = @referredby OR @referredby is null) and 
 (field2 = @f2 OR @f2 is null)
	/*
	source: http://stackoverflow.com/questions/11092576/sql-query-with-optional-parameter-and-possible-null-column

	Add optinal parameters to SQL scripts or sps
	*/
	select id, customername
	from customertable
	where
	(referredby = @referredby OR @referredby is null) and
	(field2 = @f2 OR @f2 is null)
No results found