Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
want to check every record is exist or not in sql
Vasu Gadhiya
May 9 2014 2:12 AM
525
Reply
Hi,
i want to check every record if it exist or not in sql
insert into MYDB.dbo.Table1 select * from MYDB.dbo.Table2
AS tmp WHERE NOT EXISTS (select c1 From MYDB.dbo.Table1 where c1= '1115.15-F/C')
it copy all record.
i want to copy all record of only 1115.15-F/C
How can i do ?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Database sql server
Getting more salary in lakhs then his expireance.