Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-
Create table emp_plan (empid nvarchar(200),planid...
2015-08-03
4 reads
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of...
2015-07-11
1,475 reads
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of distinctively decent competitors they have within the space of...
2015-07-11
4 reads
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
813 reads
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
6 reads
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
790 reads
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
6 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,150 reads
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
5 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will...
2015-01-26
4 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Fun with JSON I
Comments posted to this topic are about the item A Quick Restore
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers