June 7, 2013 at 1:56 am
Hai friends,
my table structure is
create table journey
(
journey_id int identity,
fromplace varchar(44),
toplace varchar(44),
mode nvarchar(20),
seattype nvarchar(20),
status_id int
)
insert into journey '2013-05-10','chennai','Mumbai','Air','Business','2'
how to write fro update for these table depends on journey_id?
i m tried its not reflecting?
June 7, 2013 at 2:34 am
A sample data of 1 rows might not be enough
Please provide a few more rows to replicate the issue properly
Now, the main questions, What do you want to update and How?
It would be better if you explain a bit more with more sample data and expected results.
raghuldrag (6/7/2013)
i m tried its not reflecting?
What have you tried? Can you show us the code, may be that will give some idea as well.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 7, 2013 at 2:43 am
Hai...
insert into journey '2013-05-10','chennai','Mumbai','Air','Business','2'
insert into journey '2013-05-12','Mumbai','chennai','Air','Business','2'
insert into journey '2013-05-14','chennai','Banglore','Air','Business','2'
insert into journey '2013-05-16','Banglore','Chennai','Air','Business','2'
insert into journey '2013-05-18','chennai','Chennai','Local','Local Travel','2'
if suppose wanna update 10th may-13 data's depends on auto increment id how to write update code?
June 7, 2013 at 2:51 am
Your requirement is still not very clear. Which is the column you want to update and How?
raghuldrag (6/7/2013)
if suppose wanna update 10th may-13 data's depends on auto increment id how to write update code?
Can you phrase this in a different manner?
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 7, 2013 at 3:05 am
hai friend,
if suppose choose the first row of the table,
create table journey
(
journey_id int identity,
depdate datetime,
fromplace varchar(20),
toplace varchar(20),
mode nvarchar(20),
seattype nvarchar(20),
)
insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-13', 'chennai','Banglore','air','Business')
insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-14', 'Banglore','Mumbai','air','Business')
insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-15', '','CHENNAI','air','Business')
if suppose wanna update entire data of 13th may depends on journey id
how make code?
June 7, 2013 at 4:24 am
raghuldrag (6/7/2013)
hai friend,if suppose choose the first row of the table,
create table journey
(
journey_id int identity,
depdate datetime,
fromplace varchar(20),
toplace varchar(20),
mode nvarchar(20),
seattype nvarchar(20),
)
insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-13', 'chennai','Banglore','air','Business')
insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-14', 'Banglore','Mumbai','air','Business')
insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-15', '','CHENNAI','air','Business')
if suppose wanna update entire data of 13th may depends on journey id
how make code?
I am still not very clear. But, I think you need on of the below queries.
UPDATEjourney
SETdeapdate = <<Some New Value>>,
fromplace = <<Some New Value>>,
toplace = <<Some New Value>>,
mode = <<Some New Value>>,
seattype = <<Some New Value>>
WHEREjourney_id = <<Value>>
-- OR
UPDATEjourney
SETfromplace = <<Some New Value>>,
toplace = <<Some New Value>>,
mode = <<Some New Value>>,
seattype = <<Some New Value>>
WHEREdeapdate = '2013-05-13 00:00:00.000'
If this is not what you were looking for, explain the issue a bit more or give us the code you have tried( may be that will help up understand )
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy