home
Knowing the differences of array_key_exists() and isset() in PHP, I see a lot of advocates on the...
[SOLVED] how to remove the NULL value only in the field provider_order only, in my case the table...
7 days ago

ISNULL MIN together

Good morning folks. I have had a good search but cant quite find an answer (or one I can...
current table (TARGET) field1 field2 field3 field4 apple1 apple2 apple3 apple4 The...
$variable = array("apple" , "orange" , null, "apple2"); DB::statement("UPDATE table1 ...
Sql query UPDATE MyTable SET Field1 = IsNull(@Field1, Field1), Field2 =...
Well, I know in fact that "!" means NOT, and I quite understand the "IsNullOrWhiteSpace" function...
1 month ago

VBA isnull function

In VBA , is there any function that work in the way similar to isnull in SQL? E.G. A1 is blank...
I have a problem, I have an EditText element (input type is numbers only), and I am trying to check...
I am currently trying to make a view in order to show the name of the clients that have purchased a...
I'm trying to pull records from one table (workers) that matches 2 of 5 status options (Active or...
My requirement is to pass input parameter with some Integers into DB to fetch the data. But in the...
I've added a new property uuid into the GORM mapping of the formerly existing domain class...
I build a query within a variable of type varchar I want to make test with isnull()...
2 months ago

2 ISNULLS IN A SELECT

Is there a better way to do this or is this code ok? DECLARE @Test DECIMAL(18,2) = NULL ,...
I imported a csv file via sqlalchemy to my postgres database using the create table with columns...
Why does this happen? In the following example, when i ISNULL to compare a blank int and a blank...
I have a "users" table as below User_Id User_Name Case_Id Create_Date ...
I'm trying to use MIN() aggregate function and fetch the minimum date from two columns and I was...
I have two data files as below: course.txt id,course 1,Hadoop 2,Spark 3,HBase 5,Impala Fee.txt...
I am working on sql server I have two tables and I need to return records from the left table...
I have to change an update query in TSQL to include the following code: (uh.FirstName !=...
I'm trying to find all entries in table a, where there is no matching entry in table b for one...
I am using SQL Server 2014 on a Windows 10 PC. I am sending SQL queries directly into...
I have a field in UI interface that passes to a stored procedure a null value (when field is...
Trying to understand the reason for the below behavior in SQL Server. The below expression returns...
4 months ago

Concat case statement

I'm very new to coding but I am trying to work out how I can (or if I can) concat the code below...
This question already has an answer here: How to replace (null) values...
I have the following compiled Linq query: public static readonly Func<DBContext, Models.User,...
guys I have a database for a movie rental store.I have a tabel for clients('clienti'), a table for...