SQUID FOR WINDOWS

Website filtering running with Windows environment is a must do as a System Administrator. The

Inserting Data using SQL SERVER 2005 AND SQL SERVER 2008

SQL is one of the few standard languages in the industry that doesn't come and go and has remained constant over the decades. The capabilities of T-SQL expand as features are added to each version of the SQL Server product.

Below are the difference on SQL Server 2005 and SQL Server 2008 in terms of inserting data using TSQL statement.

Inserting Multiple Data on name like (Mike,Anne,Smith) on table customer with customer_id which configured and sets its identity to (1,1).

SQL Server 2005 syntax
Insert customer values ('Mike')
Insert customer values ('Anne')
Insert customer values ('Smith')

SQL Server 2008 syntax
Insert customer values ('Mike'),('Anne'),('Smith')