how to update in insert time sql server 2008

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

Posted 5-Jan-15 19:44pm

Member 10413842

Add a Solution

Comments

pradiprenushe 6-Jan-15 1:46am

not clear

King Fisher 6-Jan-15 1:49am

What have you tried?

OriginalGriff 6-Jan-15 1:52am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
INSERT and UPDATE are very specific terms in SQL, and using them both in the same sentence doesn't make a lot of sense.
Try explaining in more detail exactly what you are trying to do, and what you have tried - and an example often helps us to visualise the problem.
Use the "Improve question" widget to edit your question and provide better information.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2015-01-05T19:58:00

Solution 1

Use the time field - http://msdn.microsoft.com/en-IN/library/bb677243.aspx[^] to store time in the database.

Posted 5-Jan-15 19:58pm

Abhinav S

Maddy selva · Answer 2 · 2015-01-06T18:09:00

Question is not Clear!..

I think you need to update table after Insert records in table.

so you need to use Triggers!..

here some Examples try this..

SQL

create table temp (id int primary key identity(1,1),Name varchar (10), test2 varchar(20),date datetime)
insert temp values ('SAM','English','')

SQL

create trigger tri_update on temp
for insert
as
declare @id int;
declare @date datetime;
set @date=GETDATE();

select @id=i.id from  inserted i;

update temp set date=@date where id=@id;

I think it hopes helpful!...
Here the Trriger update a inserted time into date filed

SQL

insert temp values ('JOHN','Maths','')

select * from temp

how to update in insert time sql server 2008

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us