SQL Questions and Answers - O'Reilly Answers

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback

Topics: SQL

SQL Feed SQL Open Questions Feed SQL Email Open Questions via Email

How to Recover Corrupt SQL Server Database?

By Dimeshwilliam : 04 March 2013 - 09:52 AM
For a Relational Database Management System within organization, users are facilitated with SQL Server by the computing giant-Microsoft. What makes this Server based application different from others ...
Tags:
0Votes

0Comments
Where is MySQL v6 for windows

Asked by rmy01 : 03 March 2012 - 10:06 AM

Answered by Alejandro Ramirez : Apr 10 2012 12:49 PM
I found links to the MySQL Connector for Windows version 6.1 under the development releases: http://dev.mysql.com...r.php?id=403037 On this page: http://dev.mysql.com.../mysql/6.0.html I doubt ther... full answer >
Tags:
1Answer

0Comments
Microsoft Office and SQL Azure

By kbnotes : 18 June 2011 - 03:22 AM
At the recent Microsoft Tech Days / United Kingdom 2011, Andrew Couch, MVP, and author of the forthcoming Microsoft Access 2010 VBA Programming Inside Out, presented a session titled, "Microsoft ...
Tags:
0Votes

0Comments
Sample data - SQL Pocket Guide 2nd edition

Asked by Major Gripe : 30 January 2011 - 02:58 AM

Answered by Major Gripe : Jan 30 2011 10:20 AM
Have figured it out now, please ignore this Q. full answer >
Tags:
- Data
- SQL
2Answers

0Comments
What's wrong with this PL/SQL statement?

Asked by ravindra chary : 21 October 2010 - 11:10 AM

Answered by jm50 : Nov 18 2010 11:01 PM
this appears to be a script you run with sqlplus with a pl/sql block inside. Unlike sql commands sqlplus does not execute a pl/sql block its self, it sends it to the PL/SQL engine. All sqlplus is doin... full answer >
Tags:
- pl/sql
- sql
1Answer

0Comments
What's new in SQLite 3.7

By jak : 07 September 2010 - 06:55 PM
SQLite 3.7 and Write-Ahead Logging SQLite is a full-featured relational database that is designed to be embedded directly into an application or utility. It has a relatively small runtime footprint...
Tags:
2Votes

0Comments
utility of pl word in use of pl/sql

Asked by gabrielsimon : 31 August 2010 - 07:57 AM

Answered by jm50 : Nov 18 2010 11:10 PM
This is just a procedure or synonym declared some where in your database. It may well be a wrapper for DBMS_OUTPUT.PUT_LINE but you need to check in the database. The proc may be in another schema wit... full answer >
Tags:
1Answer

0Comments
When to Use SQLite instead of Core Data on the iPhone

By chco : 22 August 2010 - 08:05 PM
This excerpt from Using SQLite explains the differences between Core Data and SQLite and will help you decide which to use when developing on the iPhone.When the iPhone and iPod touch were first relea...
Tags:
0Votes

0Comments
How to use Full-Text Search in SQLite

By chco : 21 August 2010 - 11:56 AM
The following is an excerpt from Using SQLite. Below the author gives the best ways to utilize the Full-Text Search Module with SQLite.SQLite includes a Full-Text Search (FTS) engine. The current vers...
Tags:
0Votes

0Comments
A Primer on How to Get Started With SQLite3

By chco : 19 August 2010 - 02:52 PM
The following excerpt from Using SQLite offers an initial approach to working with sqlite3 on a new install.Once you have some form of SQLite installed, the first step is normally to run sqlite3 and p...
Tags:
1Vote

0Comments