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 |
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-14 : 14:49:31
|
| I still use Query Analyser (from SQL2000 tools) for all Sproc development etc.Its partly familiarity, of course, but also I think that many of the choices about how Insert-Commenting, Next-word-arrow-key-move, and so on work, and their shortcut-keys, are less productive than how Query Analyser did it.But I'm sure if I had come from Visual Studio background then SSMS would have felt more familiar. |
 |
|
|
Gunjaipallihari
Starting Member
1 Post |
Posted - 2010-04-17 : 12:03:49
|
| Hello All, I am facing some problem in writing sql query using and condition on single column for example,suppose there is a table (Sample_Table) and with column as slno, name, age, sexSl.No Name Age Sex--------------------1 John 21 M2 Kate 18 F3 John 22 M 4 Peter 23 M5 Kate 25 F6 Steve 25 Mhere is the question i would like to get the list of name(s) with john and Kate and I wrote query like below> Select * from [Sample_Table] where name ='John' and name='Kate' but query will not run, can any one help in finding the same and i have used joins also but i could not, Hari Krishna.G |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SQL Server Client Tools for 2k8