Alter Table

Posted on By David Kittell

With this statement you would need to make sure that the column you wish to change does not currently have NULL values before running it otherwise you will likely have errors.

ALTER TABLE <TableName> ALTER COLUMN <ColumnName> int NOT NULL;
GO

With this statement you need to make sure that the column you wish to change only has unique values

ALTER TABLE <TableName> ADD PRIMARY KEY (name_id);
GO
Originally Posted on June 25, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

PowerShell – Get-TinyURL API Call

Posted on

clear Function Get-TinyURL { #PowerShell – Get-TinyURL API Call param ( [Parameter(Mandatory=$true,ValueFromPipeline=$true)] [String] $sHTTPLink ) if ($sHTTPLink.StartsWith("http://") -eq $true -or $sHTTPLink.StartsWith("https://") -eq $true) { if ($WebClient -eq $null) {$Global:WebClient=new-object System.Net.WebClient } $webClient.DownloadString("http://tinyurl.com/api-create.php?url=" + [System.Web.HttpUtility]::UrlEncode($sHTTPLink)) } else { Write-Output "Bad Link, please include http:// or https://" } } Get-TinyURL "http://google.com" GitHub:…

Read More

Excel – Find Comma Replace With LineBreak

Posted on

Selected the range of cells you need to replace. Go to Home > Find & Select > Replace or Ctrl + H Find what: , Replace with: CTRL + SHIFT + J Click Replace All Somehow CTRL + SHIFT + J is registered as a linebreak. Reference: http://stackoverflow.com/questions/14856501/substitute-a-comma-with-a-break-link-in-a-cell Originally Posted…

Read More

Chocolatey

Posted on

What is Chocolatey Chocolatey NuGet is a Machine Package Manager, somewhat like apt-get (UNIX), but built with Windows in mind. How to Install Open PowerShell ISE as admin (typical 64-bit path %windir%\sysWOW64\WindowsPowerShell\v1.0\PowerShell_ISE.exe) Set Execution Policy Permissions Run the installation script from https://chocolatey.org/install.ps1 get-packageprovider -name chocolatey Stop-Process -processName: powershell* -force #…

Read More