Sql-server Index Page 1

How to add a column to an existing table in SQL Server (ALTER TABLE Statement)

In this solution we are going to review how to add a column to an existing table on SQL Server with default values. In this small solution you will learn how to add a columns in table. You can use the ALTER TABLE statement in SQL Server. We will show an example using the NOT NULL constraint.

Sql-server Index Page 1

How to write IF...THEN in an SQL query? (sql server)

In this tutorial we are going to explain how to wirte an IF...THEN statement with SQL Server. We use the sql standard CASE and also explain the IIF statement.

Sql-server Index Page 1

How to UPDATE from SELECT using SQL Server

In this tutorial we explain how to update one table using another one with select clause.