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.
| Author |
Topic |
|
jmalathirao
Starting Member
9 Posts |
 Posted - 2007-12-27 : 08:54:19
|
| Hi All,I have my table structure as FollowsS.NO INTS.NAME VARCHAR(50)now i want to update values where S.NO=10.How is this possible to writ query.As per my knowledge sql won't allow dot as in column name in where condition.Can any one please advice on this.This is Priority one.Thanks in advance. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-27 : 08:55:22
|
| [code]where [s.no] = 10[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-27 : 09:20:43
|
| Always use underscore in place of dot,hyphen or space for more readability and ease of useMadhivananFailing to plan is Planning to fail |
|
|
|
jmalathirao
Starting Member
9 Posts |
Posted - 2007-12-27 : 09:23:05
|
quote:
Originally posted by harsh_athalye
where [s.no] = 10 Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
thank you.... |
|
|
|
|
|
|
how to update values using where conditions