What will be the result of the query below? Explain your answer?
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
141 reads
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
141 reads
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
235 reads
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
173 reads
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
186 reads
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
167 reads
We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.
sp_MSforeachtable can be used to loop through all...
2016-05-09
11,080 reads
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
159 reads
DECLARE @year INT
SET @year = 2016
;WITH months AS(
SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01') AS monthname
UNION ALL
...
2016-04-11
202 reads
SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...
2016-02-08
187 reads
SQL BasicsAn instruction to a database to combine data from more than one table.A SQL join combines records from two or more...
2016-02-08
880 reads
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse,...
Comments posted to this topic are about the item Why you should avoid Implicit...
Hi everyone I am doing some clean up of my DB. There is one...
please help. Do they know if the use of try and catch for error...
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers