What SQL can not do?

India
July 31, 2012 10:35am CST
Hi, I am looking for operations that SQL can not do. SQL had already emerged from relational algebra operations. But it still some of the operations athat can not be done using SQL. please discuss.
2 responses
bloodmask
@bloodmask (590)
• India
31 Jul 12
Well what we know. It cannot create interface. It does not have any idea what GUI is. Are you going to create one for this.
Just an Ordinary Owl?
@owlwings (43910)
• Cambridge, England
31 Jul 12
It can't make tea or drive me to work, either. If you want a GUI, you can easily build one in an application designed to do so.
bloodmask
@bloodmask (590)
• India
1 Aug 12
Then in that case use embedded SQL system to inform your tea maker to make tea for you and allow your system to automatically boot up for work. If database were not there then how could you set timing for what you want to be assigned to later task. If databases were not there then how would you assign your task to be scheduled to do your work. You may be using txt but HIFI apps would definitely use SQL.
nitish_ausumn
@nitish_ausumn (603)
• India
4 Aug 12
Hi, Thanks for response. As far as GUI is concerned SQL is created to create,manage databases and run queries. So please think linked to databases. Like one thing I found that SQL does not have control structures so one can add these. :)
Just an Ordinary Owl?
@owlwings (43910)
• Cambridge, England
31 Jul 12
According to this article/discussion: http://blogs.forrester.com/boris_evelson/10-06-23-what_sql_cannot_do a better question would be "What is it difficult to do in SQL?". SQL is supposed to be Turing Complete - theoretically, you can do anything with it - but, in practice, there are some queries which become so involved that it would not be sensible or practicable to spend time writing them. There are some good pointers in the article to where some of these problems lie.