SQL Server query (create rule)

Question

Create a rule called Makedata to allow only the following values to the make of the data: txt, excel, word, rar, and powerpoint.

You must attach the rule to column Make in the datatype table

What does this question mean? I don't want a solution just an explanation.

Thank you

I think you should be the one who tells us about the question. Are you using MySQL or SQL Server? — Tim Biegeleisen, Jun 05 '17 at 12:23
***Important*** *This feature will be **removed** in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.* — marc_s, Jun 05 '17 at 13:02
Why don't you ask the person who asked the question? This isn't a programming question; it is a reading comprehension question, and is off-topic for stack overflow. — Tab Alleman, Jun 05 '17 at 13:04

score 1 · Accepted Answer · answered Jun 05 '17 at 12:46

1

You are asked to filter the values that can be stored in that data column. For this you can use enum data type if were using MySQL. To fit your case take a look at: SQL Server equivalent to MySQL enum data type?

Alter your table with:

column_name VARCHAR(255) NOT NULL CHECK (column_name IN('txt', 'excel', 'word', 'rar', 'powerpoint'))

answered Jun 05 '17 at 12:46

BDS

200
10

I need it as rule – Moudi Nasrallah Jun 05 '17 at 12:53
CREATE RULE your_rule AS @list IN ('txt', 'excel', 'word', 'rar', 'powerpoint'); – BDS Jun 05 '17 at 12:56
@list should n't be the same as column name ? – Moudi Nasrallah Jun 05 '17 at 13:28

SQL Server query (create rule)

1 Answers1