Sql 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 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 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.

Sql Index Page 1

Oracle SQL: How to write a que for filterting Date columns

Oracle SQL date format can be tricky to understand and could make you loose time to figure out why a query is not working. We use TRUNCATE and TO_DATE function to create a query to filter by a date on a timestamp column.