SQL – Page 1631 – SQL Questions Answer

Oracle case inside where clause

This is a simple question, I’ve read some details about using CASE in WHERE clause, but couldn’t able to make a clear idea how to use it. The below is my sample query: 1 SELECT * FROM dual 2 …

choose minimum date from a record out of multiple columns

Hi I have the following table struct: Person Date1 Date2…………Daten —— —– —– —– 1 2001-01-01 2002-01-01 2 2003-01-01 …

SqlCommand INSERT INTO query does not execute

.net c# insert sql sql-server

Hello guys I have got this code: It should insert data from textboxes: kname, ksurname, but it closes the form without showing them in MS SQL table klient Answer Missing the ExecuteNonQuery call A command should be executed to update the database…

Get the nearest longitude and latitude from MSSQL database table?

Ok I have searched SO and Google but haven’t really found a definitive answer so throwing it out there for the SO community. Basically I have a table of longitudes and latitudes for specific points …

Use Aggregate Function in UNION ALL result set

sql sql-server tsql

How can I use aggregate Functions in UNION ALL Resultset FOR EXAMPLE Result Set Would Be When I tried to get MAX(A) it returns 3. I want 6. When I tried to get MAX(B) it returns 4. I want 7. Other than Max(), Can I get another aggregate function which user defined? For example: (SELECT TOP 1 A WHERE B=5)

What does the ( ‘ > ) symbol mean in the command line in MySQL?

command-line database mysql sql

I’m new to sql and for some reason, the arrow symbol ( -> ) that I am used to seeing in teh command line, which mean it is ready for input, is now displayed as ( ‘> ) and it does not accept commands. What does it mean and how do I get back to ( -> ) ? Thanks

Group query results by month and year in postgresql

postgresql sql

I have the following database table on a Postgres server: I would like to create a query that gives the SUM of the Sales column and groups the results by month and year as follows: Is there a simple way to do that? Answer At the request of Radu, I will explain that query: to_char(date,’Mon’) as mo…

update data with connected ado.net layer

.net c# sql sql-server winforms

I’m trying to perform update operation on winform using connected ado.net layer. here’s the code using this query I’m getting exception $exception {“Dynamic SQL ErrorrnSQL error code = -104rnToken unknown – line 1, column 15rn(“} System.Exception {FirebirdSql.Data.FirebirdC…

SQL server Nvarchar parameters

ado.net collections sql sql-server vb.net

I Have created an SP to search against many tables in the db based on string sent form ado the Vb code and the SQL SP is : As you can see I have declared argument in VB as Nvarchr and SQL parameter @SearchKey as Nvarchar also if I send english data in @SearchKey search returns correct data, but if