Hello everyone, how to set the time period for running a business. For example, only 12:00 noon to 24:00 can run business, other times can not buy goods。 My English is not very good. :)
Not necessary at all.Quote:
You can easily manage with a filter
DECLARE @CurrHour TINYINT; SELECT @CurrHour = DATEPART(HOUR, GETDATE()); IF (@CurrHour IS NOT NULL AND @CurrHour BETWEEN 12 AND 23) BEGIN //system do work END