Sql

Search

match in sql server

MERGE Locations T
USING Locations_stage S ON T.LocationID=S.LocationID
WHEN MATCHED AND T.LocationID =3 THEN
DELETE 
WHEN MATCHED AND T.LocationID =1 THEN
UPDATE SET LocationName=S.LocationName;

Comment

PREVIOUS	NEXT

Code Example
Sql :: SELECT everything from a sql table
Sql :: dump multiple tables mysql
Sql :: microsoft sql server python connection
Sql :: control files oracle
Sql :: multiple row primary key
Sql :: sql server select rows by distinct column
Sql :: postgres full text search example
Sql :: select only distinct values from another table and excluding from current table
Sql :: pl sql auto increment
Sql :: postgres stored procedure
Sql :: insert or update sql query
Sql :: mysql query where in select
Sql :: sql server find all referencing objects to user-defined table type
Sql :: Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
Sql :: mysql select database
Sql :: check ksql db health
Sql :: how to delete python anywhere mysql database
Sql :: mysqli_free_result
Sql :: sql server size of every table in a db
Sql :: mysql get table column names and data types
Sql :: SQL Greater than ()
Sql :: sql primary key
Sql :: DIFFERENCE BETWEEN 2 COLN IN SQL
Sql :: mysql dump structure only
Sql :: mysql calcular idade
Sql :: sql constraint to check date less than current date
Sql :: create a database mysql
Sql :: Ms Sql set us timezone
Sql :: end mysql command
Sql :: mysql large import

Search

SQL

match in sql server

ADD CONTENT