O'Reilly Answers

Topics: sql

sql Feed    sql Open Questions Feed    sql Email    Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.

• Tips for Protecting Against SQL Injection in SQL Server 2008

  

  By adfm : 21 April 2010 - 03:14 PM

  SQL injection attacks are one of the most prevalent security concerns today. In this excerpt from Itzik Ben-Gan, et al.'s Inside Microsoft SQL Server 2008: T-SQL Programming you'll learn a few tips ...

  Tags:

  • SQL Server
  • SQL
  • SQL injection
  • security

  0Votes

  0Comments

  ---

• How to Write Accurate SQL Code: A video sample of Chris Date's new course

  

  By filmbilly : 12 April 2010 - 05:36 PM

  I was honored to work with Chris Date to bring his legendary relational theory class to video and the web. During the making of this video Date shared a number of stories about his collaborations wit...

  Tags:

  • tuples
  • relvars
  • database design
  • relational model
  • oracle
  • mysql
  • sql
  • base tables
  • nulls

  3Votes

  0Comments

  ---

• Ten Tips for Android Application Development

  

  By zigurd : 09 December 2009 - 02:53 PM

  Beginner tips Learn SQL and put your data models in a database Android has an excellent persistence system; use it to make your applications more robust in case of failure or shutdown, and to make s...

  Tags:

  • android
  • internationalization
  • ui
  • eclipse
  • xml
  • sql

  4Votes

  1Comment

  ---

• jdbc sql question?

  

  By xiaofanku : 06 December 2009 - 04:54 PM

  i has sql statement:SELECT COUNT(*) FROM angle_dispatchemployee d INNER JOIN angle_comtract c ON d.deid=c.dispatchemployee_deid WHERE c.rstate=? AND d.state=? AND c.company_acid IN(?) c.rstate=0(or 1)...

  Tags:

  • java
  • jdbc
  • sql

  0Votes

  1Comment

  ---

• How to Use HTML 5 Storage in Palm webOS

  

  By steve@oreilly.com : 19 November 2009 - 04:21 PM

  Palm webOS supports the HTML 5 Database object. The following excerpt from Palm webOS shows you how to create and query an SQL database using the HTML 5 Database object. By default, Palm webOS st...

  Tags:

  • webOS
  • Palm
  • database
  • SQL

  1Vote

  0Comments

  ---

• Is there an easy way to get the results of a SQL query into a new table?

  Asked by MikeH : 19 November 2009 - 09:04 AM

  

  Answered by KBenson : Nov 19 2009 01:04 PM
  In MySQL you can use the result of a select for the values of an insert. mysql> create table t1 ( one int, two int, three char(10)); Query OK, 0 rows affected (0.09 sec) mysql> create table t... full answer >

  Tags:

  • sql
  • data
  • tables
  • help

  2Answers

  0Comments

  ---

• HTML 5 Storage for Palm webOS

  

  By steve@oreilly.com : 02 November 2009 - 04:29 PM

  Palm webOS includes support for the HTML 5 Database object to create, update, and query an SQL database. The HTML 5 database interfaces are asynchronous, requiring you to use callbacks for much of you...

  Tags:

  • html 5
  • palm pre
  • storage
  • database
  • mobile
  • web
  • webos
  • sql

  0Votes

  0Comments

  ---

• How to Use SQL to Search for Keywords Without the LIKE Operator

  

  By andr3w : 27 October 2009 - 10:06 PM

  You can do a simple keyword search using the LIKE operator. Unfortunately, this can be slow. Fortunately, an efficient keyword search is available in many systems.Often you must store ...

  Tags:

  • sql server
  • postgresql
  • mysql
  • LIKE
  • sql
  • oracle
  • databases
  • data

  1Vote

  0Comments

  ---

• How to compute distances based on zip codes

  

  By mike-loukides : 26 October 2009 - 12:20 PM

  If you're writing a web application, and you want to find places (restaurants, theaters) within a certain distance from your user, you'll probably need to work with zip codes. Here's a go...

  Tags:

  • ruby
  • rails
  • jruby
  • enterprise
  • zip code
  • latitude
  • longitude
  • geocoding
  • map
  • database
  • sql

  2Votes

  0Comments

  ---

• How to Convert Subqueries to JOINs

  

  By drgrussell : 24 October 2009 - 09:19 PM

  Sometimes you want to query one table, use that result to query another table, and then use that result to query yet another table. It’s tempting to do this as three separate queries, ...

  Tags:

  • sql
  • join
  • convert
  • subqueries

  1Vote

  0Comments

  ---