SQL Server – Add Column Script

The code below can be used to a column to an existing table.

      
      –Add a column to an existing table

      ALTER TABLE dbo.Employee
      ADD Active varchar(1)
      GO

      –Add default to new column

      ALTER TABLE dbo.Employee
      ADD CONSTRAINT Employee_Active
      DEFAULT (‘N’) FOR Active
      GO

#SQLServer

Some words from the sponsors...

Add a C# Dropdown to a Bootstrap Modal Dialog

This example combines C# and Bootstrap to create a bootstrap modal dialog containing an asp dropdown and an asp button to retrieve...

Use C# to Populate Dropdown Lists With XML

The code below opens an xml file, reads the data from the xml file, dynamically adds a label for the dropdown list, and adds the dropdown list to the asp.net page...

Add Style Properties to ASP.Net Controls to Improve Appearance

The default formatting for ASP.Net controls is very dated. The default formatting is basically the same as the formatting in Visual Basic 1.0 ...

Export To A Text File From A DataGridView Control

Add a button control to Form1.
Add a DataGridView Control to Form1....