人生是一场不能存盘的RPG,我只能尽量多搞几个Screenshot

May 19, 2006

写SQL语句容易出错的地方

Filed under: SQL&DB Accessing

1.要注意from, where 附近的空格!

stirng sql = "SELECT COLUMN_NAME AS Name, " +
             "DATA_TYPE AS Type, " +
             "CHARACTER_MAXIMUM_LENGTH as Length " +
             "From INFORMATION_SCHEMA.COLUMNS " +
             "WHERE TABLE_NAME = ‘{0}’";

Comments »

The URI to TrackBack this entry is: http://recordsome.blogsome.com/2006/05/19/p46/trackback/

No comments yet.

RSS feed for comments on this post.

Leave a comment

Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>



Anti-spam measure: please retype the above text into the box provided.






















Get free blog up and running in minutes with Blogsome
Theme designed by Hadley Wickham