Skip to content

C# SqlReader issue

I’am posting on this forum for the first time . and I really hope I can find some help . What I’am doing is load about … 1000 Value (example) from SQL and I’am doing it just fine . the query for example is : Select Value from DatabaseA.dbo.Values that “Value” ==> decimal…

How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit after them. What I’m trying is this SELECT trecord FROM `tbl` WHERE (trecord LIKE ‘ALA[d]%’) …

GROUP_CONCAT in SQLite

I am having data like this by using this query Now, I want to show data like this and so on..I also know it can achieve by GROUP_CONCAT function. So, I tried with this But, It shows me error. So, what I am doing wrong here. What are the right procedure to achieve that? Answer You need to add GROUP

SQL Query Comparing Date

I have a table of items with a ‘date_added’ column. What I want to do is select all the items added during the last two weeks. How can I do that? Answer If you are using MS SQL Server try this code: For MySQL try:

“Alter user sys identified by” not working

First of all, I use: Windows 7 x64 Oracle Enterprise 11g R2 x32 I have some basic experience with SQL Server and MySQL (more with MySQL). Today I started working with Oracle, and I’ve been bumping a lot on the way. The problem I’m having now is that, for some reason, I can’t connect to any s…

SQLzoo, SELECT within SELECT tutorial

sql

I am currently doing this tutorial (http://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial) and I can’t answer question 8 : Some countries have populations more than three times that of any of their …