We can insert all the default values in tables without specifying values while insert in table, how? See here we have tables defined all columns by default,
CREATE TABLE defaultval(Did you ever get used to it?
id int default 0,
name varchar(10) default 'test',
cdate datetime default getdate()
);
INSERT defaultval DEFAULT VALUES;
No comments:
Post a Comment
Please Use Good Leanguage