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
Prakash Mondal
NA
288
208.9k
How to Update Multiple table records using table alias???
Apr 6 2013 11:40 PM
I create two table..
create table stupersonal (stuid varchar(20) primary key,stuaddress varchar(20),stufname varchar(20));
create table stuclass (stuid varchar(20) primary key,stuclass varchar(20),stusec varchar(20));
also insert some values...............
but, I update some value to both table.
I write...................using table alias in SQL SERVER-2005
update stupersonal sp, stuclass sc set sp.stuaddress='Kolkata',sp.stufname='Smith',sc.stuclass='X', sc.stusec='A' where sp.stuid='amit123' and sc.stuid='amit123';
but. error.......................
can't update this value to those tables.................
Please solve this problem..............
.............................Prakash
Reply
Answers (
1
)
What is the maximum number of Index per table in sql 2012?
SQL Connection Error when run application(Production Server)