Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
    
What SQL server are you using? –  MaQleod Apr 20 '11 at 6:44

5 Answers 5

up vote 33 down vote accepted

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.

share|improve this answer
2  
very nice web app. Its been very useful to me. Well done :). I have bookmarked sqlfiddle.com! –  Homunculus Reticulli Jun 12 '12 at 1:00
    
@HomunculusReticulli glad to hear it! –  Jake Feasel Jun 13 '12 at 18:20
    
+1 great app ,now i dont need to install some application and bog down my system –  Shekhar Sep 23 '12 at 16:39

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).

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer
    
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 Apr 16 '11 at 5:48

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

share|improve this answer

protected by Community Aug 26 '13 at 10:43

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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