SQL INSERT INTO SELECT Statement -Update

SQL INSERT INTO SELECT Statement



INSERT INTO table2   SELECT * FROM table1; 


Check if table exists in SQL Server


IF EXISTS (SELECT 1
           FROM INFORMATION_SCHEMA.TABLES
           WHERE TABLE_TYPE='BASE TABLE'
           AND TABLE_NAME='mytablename')
   SELECT 1 AS res ELSE SELECT 0 AS res;


TRUNCATE TABLE (Transact-SQL)


IF EXISTS (SELECT 1
           FROM INFORMATION_SCHEMA.TABLES
           WHERE TABLE_TYPE='BASE TABLE'
           AND TABLE_NAME='FamilyTree')
  Truncate Table FamilyTree

select * into #TEMPALL
from
(
select * from #TEMPdata1
UNION
select * from #TEMPdata2
)#TEMdata12

Part2 - Create Tables, Add Data

------------------------------------------------------

The SQL UPDATE Statement

UPDATE table_name

SET column1=value1,column2=value2,...

WHERE some_column=some_value;

------------------------------------------------------

SQL Server 2008 Update Query with Join and Where clause in joined table

UPDATE 

    ust

SET  

    ust.isUnsubscribedFromSystemEmails = 1

FROM         

    UserSetting AS ust 

INNER JOIN

    [User] ON ust.userID = [User].userID 

AND 

    [User].emailAddress IN (SELECT emailAddress FROM BadEmailAddresses)