how to update or delete with Join TSQL

Update [table] set [column] = [value] from [table] t1 inner join [table] t2 on t1.col1 = t2.col
Delete t1 from [table] t1 inner join [table] t2 on t1.col1 = t2.col1
Advertisements
About

hi there, I am software engineer, working in e-commerce company and passionate about all thing digital. On this blog, I share my experiments with different technology.

Posted in SQL Server
2 comments on “how to update or delete with Join TSQL
  1. msuworld says:

    thanks , just what i was looking for 🙂

  2. jignesh2882 says:

    thanks to be first person to comment on blog.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What people say about post?
seo hizmeti on Awesome wordpress ecommerce…

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 38 other followers

%d bloggers like this: