SQL Server
SQL Server - Personnel Learning notes (Start from basic)
Pages
Home
SQL Learning Resource
SQL AlwaysOn References
SQL Troubleshooting Resource
Script
SQL Article - reference
Topic read/view
Wednesday, November 26, 2008
Default Value
Add default value in table schema
alter table [table_name]
add CONSTRAINT [DF_tableName_columnname] DEFAULT (0) for columnname
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment