Database

CREATE TRIGGER Insert_B_On_Insert_A
ON A
FOR INSERT
AS
INSERT INTO B
SELECT * FROM inserted

<br />
select IsDate('11/15/05')<br />

SELECT Field1, Field2, Field3
FROM Table2
WHERE Field1 NOT IN (SELECT Field1 FROM Table1)

INSERT INTO Table1 (Field1, Field2, Field3)
SELECT Field1, Field2, Field3
FROM Table2
WHERE Field1 NOT IN (SELECT Field1 FROM Table1)

UPDATE Table1
SET Field2 = (SELECT Field2 FROM Table2 WHERE Table1.Field1 = Table2.Field2),
SEt Field3 = (SELECT Field3 FROM Table2 WHERE Table1.Field1 = Table2.Field2)
WHERE Table1.Field1 IN (SELECT Field1 FROM Table2)

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

DECLARE @vTable TABLE (TID Int, TDesc Varchar(255))

INSERT INTO @vTable 
SELECT 
	TerritoryID, 
	TerritoryDescription 
FROM 
	Territories 
WHERE 
	TerritoryDescription = 'Denver'
OR	TerritoryDescription = 'Edison'

INSERT INTO @vTable 
SELECT 
	TerritoryID, 
	TerritoryDescription 
FROM 
	Territories 
WHERE 
	TerritoryDescription <> 'Denver'
OR	TerritoryDescription <> 'Edison'
ORDER BY TerritoryDescription

SELECT * FROM @vTable