Surf 11 » Alter Table Add Column on SQL Server
Finding the best waves on the web.
March 24, 2009
If you try running this command to add a new column on Microsoft SQLServer:
ALTER TABLE ADD COLUMN column_name int
You will get an error message:
Incorrect syntax near the keyword 'COLUMN'.
That's because SQL Server Doesn't like ADD COLUMN it prefers you just say ADD instead:
ALTER TABLE ADD column_name int
Related Entries
- Change size of a varchar column with mysql
- MySQL - SQL To Add a Column to a Table
- Fixing SQL Server Users after Backup Restore
- Saving Table Times out in SQL Server 2005
- Cannot shrink log file because all logical log files are in use
- Connect to SQL Server on Non Standard Port
- How to Determine if IIS is running in 32 or 64 bit mode
- SELECT NULL Rows with MySQL
Comments
On at alexc345 wrote:
1
Very nice site! is it yours too http://opxyiea.com/yoyrxko/4.html
On at alexe90 wrote:
2
Very nice site!
On at Pharmd493 wrote:
3
Very nice site! cheap cialis http://yieopxa.com/yxyrxkx/4.html
On at Pharme994 wrote:
4
Very nice site!
On at Pharme383 wrote:
5
Very nice site! cheap cialis http://apxoiey.com/qoxxat/4.html
On at Pharmc422 wrote:
6
Very nice site!
- Solved: Could not perform unpadding invalid pad byte
- Getting Started - Making AJAX Applications Crawlable - Google Code
- Our Collectors : Jon Masamitsu's Weblog
- Ponemon Cost of a Data Breach
- jsPerf: JavaScript performance playground
- Updating OpenSSH over SSH with yum CentOS
- betali.st
- How to Version HTML5 Database openDatabase()
Subscribe to our RSS Feed: 
XML
XML