TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vignesh Kumar
NA
1k
416.5k
Help in delete & update query
Nov 1 2013 1:25 AM
I am joining two tables and fetching columns from two tables (App_Main & App_Test) and binding that to a grid. How can I write delete & update query having EAI Code as primary.
select Main.[EAI_Code], Main.[Active_Ind], Main.[App_Class],Main.[App_Long_Name],
Main.[App_Short_Name], Main.[App_Status], Main.[Critical_Ind], Main.[LOB],
Main.[Master_App_Id], Main.[Master_App_Name],Test.[App Name], Test.[Critical App],
Test.[L2 Group], Test.[L2 Subb Group], Test.[OBM Comments], Test.[OBM Status],
Test.[OBM Target Date], Test.[PM L2 Lead], Test.[Platform], Test.[Tricare]
from App_Main as Main inner join App_Test as Test on Main.[EAI_Code]= Test.[EAI code]
Reply
Answers (
3
)
What is SSIS, SSAS,SSRS
COMPARE TWO TABLES AND REPLACE TABLE B COLOUM DATA TO .....