sql server 2008 - SQL : if value is between 1 and 10000 then inserted otherwise kept as null -

sql server 2008 - SQL : if value is between 1 and 10000 then inserted otherwise kept as null -

i want insert record in sql table. status if value between 1 10000 inserted otherwise kept null (not "").

what can while creating table if want these 2 conditions apply?

this behavior can obtained through utilize of sql trigger , database stored procedure. see http://msdn.microsoft.com/en-us/library/ms191300.aspx

sql-server-2008