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 |
|
migi0027
Starting Member
2 Posts |
 Posted - 2012-01-14 : 04:41:12
|
Hi,I want to select name from the table Userprofile, but there is many rows, and i only want one with the value 8 in Id.How do i do that? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-14 : 04:54:51
|
WHERE is used for specifying the conditionselect name from Userprofile where Id=8 ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
migi0027
Starting Member
2 Posts |
Posted - 2012-01-14 : 05:16:16
|
| Ok, i think you code is perfect but when i use it(note im using WebMatrix from microsoft) it jst returns this:WebMatrix.Data.DynamicRecord |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-14 : 05:20:34
|
| i dont know what WebMatrix is so you might have to post it in relevant forums to get help on it. What I've given is T-sql code which works in SQL Server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Select Name from Userprofile, and more.