Altering column size in SQL Server

I would like to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5)

how to do it?

ALTER TABLE[Employee]ALTERCOLUMN[Salary] NUMERIC(22,5)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s