CREATE TABLE dbo.tempabc([col1] [varchar] (16),[col2] [int] NULL CONSTRAINT df__tempabc__Col2 DEFAULT ((0))) ON [PRIMARY]GOALTER TABLE dbo.tempabc ALTER COLUMN Col1 VARCHAR(32) NOT NULLALTER TABLE dbo.tempabc ADD CONSTRAINT df__tempabc__Col1 DEFAULT 'abc' FOR Col1
Ads 720 x 90
Home
› Uncategorized
Related Posts
There is no other posts in this category.Total Pageviews
Label List
- Architecture
- Art of SQL Server
- asynchronous mirroring
- csv
- dmv
- find outdated Statistics
- Free SQL Server tools
- index fragmentation
- Installation
- Katmai
- Learn SQL Server 2005
- Maintenance Plan
- outdated Statistics
- Reset Identity column
- Scripts
- SPID
- sql server 2008
- sys.dm_db_index_physical_stats
- sys.dm_exec_connections
- tsql
- update statistics