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 |
|
pug2694328
Posting Yak Master
166 Posts |
 Posted - 2011-04-08 : 15:17:40
|
| Using the English language properly can have an (effect? affect?) on how you are perceived as a professional.I recently had a colleague tell me that I was not using the correct homonym when I wrote that "...records were effected by the query", that the correct English is "...records were affected by the query".At first it just made me mad... Who cares? What a jerk!Then it made me feel stupid/ignorant...At first it seemed straightforward, affect is a verb, effect a noun (so I WAS wrong).Then I found this article (http://www.yourdictionary.com/grammar-rules/affect-effect-grammar.html) which says that effect can be used as a verb as well. All very confusing.Now I care!What is the correct word to use? It seems that it is written both ways all over the place. Even in these hallowed forums!I'm assuming there is only one correct way to say this and want to use the correct word going forward. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-08 : 15:20:32
|
| Affected.It's a common language mistake, the words mean a similar thing, but they are not interchangable. Correct usage (afaik):The query affected 10 rows.The effect that the query had was to update the column.--Gail ShawSQL Server MVP |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pug2694328
Posting Yak Master
166 Posts |
Posted - 2011-04-08 : 15:35:03
|
| Thanks for moving this appropriately, I couldn't find the right place. Seems like affected is the way to go... sometimes!Thanks Gila |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-04-09 : 11:11:50
|
every time you run a query with NOCOUNT OFF, sql server will tell you which verb is appropriate. :)
elsasoft.org |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-04-11 : 05:56:54
|
quote:
Originally posted by pug2694328
...Then I found this article (http://www.yourdictionary.com/grammar-rules/affect-effect-grammar.html) which says that effect can be used as a verb as well. All very confusing....
Don't believe everything you read.  Corey I Has Returned!! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-13 : 12:03:24
|
| http://www.wsu.edu/~brians/errors/affect.html |
|
|
|
|
|
|
is it number of rows 'affected' or 'effected'?