how to update user input data into sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

how to update user input data into sql server

Author

Topic

jaimin
Starting Member

21 Posts

Posted - 2007-05-28 : 09:02:26

hi ,
i am new to this.
how should i update the user input values into sql server database?
i am using asp.net and c#
FIELDS are-
userId,
name,
description,
startTime,
endTime,
audiencePassword,
presenterPassword

i know it must be simple...but i haven't worked on this before.

Jaimin

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-28 : 09:06:00

You should read about UPDATE statement in SQL Server help.

UPDATE <table-name>
SET <field1-name> = <value-1>, 
    <field2-name> = <value-2>, ...
WHERE <some-optional-condition>

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

jaimin
Starting Member

21 Posts

Posted - 2007-05-28 : 09:12:08

do i have to use END at the bottom??

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-28 : 09:16:49

Depends on whether this statement is a part of bigger procedure or script. If it is a singleton statement, there is no need for END at the end.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources