這段Select Command 為什麼有不同?

[TaTMiNG@HK]

šÏ¥ÎSQL 2005 Express ,Š³šâ¬qSelect Command:

UserName ¬OString
²Ä€@±ø:
"SELECT * FROM [user] WHERE ColumuX='" & UserName & "' "
²Ä€G±ø:
"SELECT * FROM [user] WHERE ColumuX=" & UserName

šâªÌŠb°»¿ù®É³£¥i¥H¬Ý±o¥X¬O€@ŒËªº.
Šý²Ä€@±ø¬O¥¿œT,²Ä€G±ø¬O¿ù,¬°€°»ò??
°²ŠpUserName¬OJohn ªºžÜ,€À§OŽN¬O 'John' ©MJohn
ŽN¬OŠh€F³ošâ­ÓÂI²Åž¹ " ' "
Šý°O±oŠp€£¬O€@šÇ©MT-SQL¬ÛšRªºŠr(ŠpID,Public...µ¥)³£¥i¥H€£¥Î¥[ªº.




--

[Microsoft MVP Vivid Hsu]

T-SQL ŠrŠêÀ³žÓ­n¥Î³æ€Þž¹§a
¬°€FÁקK¥X¿ù,ÁÙ¬O§â¥Š¥[€W¥h§a
--
·L³n³ÌŠ³»ù­È±M®a
Microsoft MVP
Vivid Hsu

Post by ***@HK
UserName ¬OString
"SELECT * FROM [user] WHERE ColumuX='" & UserName & "' "
"SELECT * FROM [user] WHERE ColumuX=" & UserName
°²ŠpUserName¬OJohn ªºžÜ,€À§OŽN¬O 'John' ©MJohn
ŽN¬OŠh€F³ošâ­ÓÂI²Åž¹ " ' "
--

[璉璉]

ŠrŠê³£­n¥[ ' ¬AŠí
ÃöÁäŠr­n¥[ [] ¬AŠí

Šb ' žÌ­±¥i¥H¥X²{ÃöÁäŠr

šC­Óžê®Æ®w³£¬O³oŒË¡Ažò SQL Server 2005 Express šSÃö«Y...

Ž_¿³¥x¥_Ÿ÷³õ¶Q»««Ç

©ó news:OfS%24UnhlGHA.4100%40TK2MSFTNGP05.phx.gbl µoªí
UserName ¬OString
"SELECT * FROM [user] WHERE ColumuX='" & UserName & "' "
"SELECT * FROM [user] WHERE ColumuX=" & UserName
°²ŠpUserName¬OJohn ªºžÜ,€À§OŽN¬O 'John' ©MJohn
ŽN¬OŠh€F³ošâ­ÓÂI²Åž¹ " ' "

--
­·¬ê¬ì§ÞÅçÃÒŠ³­­€œ¥q ASP.NET Web News Reader 0.2.2 UTF-8 Beta
ºô¯žŠa¹Ï http://tlcheng.no-ip.com/wwwmap.htm
¬y°ìšŸ¬x/°Ï°ì€ôžê·œ/®}ª@ºô/ªŽºÀ¹Ï/»y­µ³q°T €å³¹»Pµ{Š¡
Basic/Fortran/Windows API/.Net/»²§U»¡©úÀÉ ­ì©lœX¡B€å³¹»P°Qœ×
Ž_¿³¥x¥_Ÿ÷³õ¶Q»««Ç
--
ASPNET News http://tlcheng.no-ip.com/News/ | http://tlcheng.twbbs.org/News/
RSS 2.0 http://tlcheng.no-ip.com/News/rss2.aspx?Action=List&Newsgroup=microsoft.public.tw.dotnet.framework.aspnet