29

I need an online SQL statement checker, where I can create temporary tables, insert temporary data and test them using SQL statements.

Is there any site like that?

Improve this question
1
  • What SQL server are you using?
    – MaQleod
    Commented Apr 20, 2011 at 6:44

5 Answers 5

Reset to default
46

I built a web app that does pretty much exactly what you're asking for:

http://sqlfiddle.com

My intent was to make it easier for people to setup environments that demonstrate the SQL problem they are attempting to solve, then post the link to StackOverflow (or something similar) and have people go there and attempt to solve it, much the same as jsfiddle.net is used to solve JavaScript questions.

Improve this answer
5
  • 3
    very nice web app. Its been very useful to me. Well done :). I have bookmarked sqlfiddle.com!
    – Homunculus Reticulli
    Commented Jun 12, 2012 at 1:00
  • @HomunculusReticulli glad to hear it!
    – Jake Feasel
    Commented Jun 13, 2012 at 18:20
  • +1 great app ,now i dont need to install some application and bog down my system
    – Shekhar
    Commented Sep 23, 2012 at 16:39
  • 4
    Is there a way to validate SQL code without providing a schema? Basically, I want to just ensure it can even parse my code at all.
    – Patrick Szalapski
    Commented Aug 12, 2015 at 20:27
  • nice app! i guess oracle does not provide the character position for parsing errors?
    – WestCoastProjects
    Commented Nov 30, 2015 at 5:00
3

I'm not sure which SQL server that you're using, but I think you may try Mimer SQL Validator. However, it will not save any data for display query result.

Improve this answer
2

You can use myLittleAdmin (for SQL Server and MSDE) to test your queries on SQL Server 2000. This is actually a live demo app for myLittleAdmin, a web-based SQL Server and MSDE Database administration tool

Alternatively you could get yourself a free Windows Azure Platform 30 Day Pass & try your queries on SQL Azure (for a limited time).

Improve this answer
1

I don't know of any online databases you can use, however if the issue is that you need a simple database to check SQL statements as you don't have access to your production one. You could always install the Oracle Express (XE) Edition which is free and small.

Improve this answer
1
  • Yeah, i have that. But sometimes you are not on your own PC. But you have to do some work done. In that scenario, this sort sites come to help
    – user
    Commented Apr 16, 2011 at 5:48
0

Have you tried RED SQL? It’s an online tool that doesn’t require installation and supports multiple databases.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.