Restrict table updation

Satish Patel

10y1k

How to restrict a table updation on weekend(like table can't be update in Saturday and sunday)

in sql server 2008.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shubham Kumar10y ago
Accepted answer
Hi,
yes it is possible with "check" constraints but here is also u have to make the condition like

CREATE TABLE Test_
(
P_Id int IDENTITY (1,1),
DayOfTheWeek varchar(255) NOT NULL CHECK (DayOfTheWeek<>'Sunday' and DayOfTheWeek<>'Saturday'),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

SELECT * FROM Test_

INSERT INTO Test_ VALUES ('sunday','ABC','AAM','BJP')
//if you execute this insert statement it throw a error
The INSERT statement conflicted with the CHECK constraint
The statement has been terminated.

+1
Satish Patel10y ago
Thanks Shubham. You are a saviour :)
0
Satish Patel10y ago
I am just wondering, is it possible to restrict table update on weekends using "Constraints" in SQL Server ?
0
Shubham Kumar10y ago
yes satish you can do it from front end just check the day according to your CultureInfo

See the Demo here
https://dotnetfiddle.net/a2W7bq

or if you want o do it from
select datename(dw,getdate())
+1
Satish Patel10y ago
Hi Shubham,
I can do it in front end coding. But I just want to know how I can achieve this using SQL Server. Actually this an interview question asked me by an interviewer.

Thanks for your help.
0
Chandu Kumawat10y ago
then set Job Scheduling in sql server agent
0
Shubham Kumar10y ago
hi,
So what is problem in that if you are doing from front end just check name of day and and allow or don't allow to update if you are doing from back end so you also have to check name of the day and allowing or disallowing for update, but there is not any option are available to set some property or condition directly on table .
+1