English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I set one field in my SQL table to accept Null Values as i inserted data with Null Values. can i reset it not to accept Null Values from users. what happens to the data already in the table

2007-03-13 05:10:13 · 3 answers · asked by Sempeho 2 in Computers & Internet Programming & Design

3 answers

if you want to not accept null values, you might want to consider setting a default value.

it may be something like

alter table alter column MyColumnname not null default MyDefaultValue.

That might be able to do it all in one step

2007-03-13 05:37:53 · answer #1 · answered by Jay 3 · 0 1

depends on the version of sql you are using but it will be something like
alter table modify column_name type (int) not null;

2007-03-13 05:16:29 · answer #2 · answered by Vegan 7 · 0 0

x + 6 < 7 x < a million x + 6 > - 7 x > - 13 answer (a million): - 13 < x < a million ---------- = $one hundred forty four/($sixteen/2) = $one hundred forty four/$8 or 18 answer (2): 18 widgets ---------- 5x - 2y + 2y = 8 + 2(5/2x + 3) 5x = 8 + 5x + 6 0 = 14 is fake answer (3): gadget is inconsistent—there is no answer to this problem.

2016-11-25 00:32:30 · answer #3 · answered by hildy 4 · 0 0

fedest.com, questions and answers