SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Altering Data Length of a Primary Key Column

This is not an article or a script. I am posting this just to share my experience and I feel it can save a lot of time in a specific situation. Problem – We have a table let’s say Customer and this table has an alpha numeric primary key CustomerID varchar(10). Due to unexpected growth in volume of data we figure out varchar(10) was not sufficient and we decided to make it varchar(50). When

Help on SQL Server

Devendra Kumar Thakur has a Master's Degree in Computer Applications from Jabalpur Engineering College, and has worked as a Lead Consultant with companies such as Siemens, Accenture, and his current employer, ITC. The majority of his experience is with SQL Server, SSRS, and Crystal report as a developer, however he is now trying to learn SSAS.

Comments

Leave a comment on the original post [helponsqlserver.blogspot.com, opens in a new window]

Loading comments...