O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Q&A

Q1: Where can I learn more about writing SQL queries?
A1: A great book for learning SQL syntax is Sams Teach Yourself SQL in 10 Minutes Second Edition. This book focuses on the queries themselves and avoids delving deep into database theory and database design. If you are interested in database theory as well, Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days might be more appropriate for you.
Q2:If strings are delimited by the ' (single quote) character in SQL, how do you enter the single quote character into a database field programmatically?
A2: This is referred to as “escaping” the special character. Simply enter two single quotes instead of one. For instance, SQL Server will recognize the text “it''s” as “it's”.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required