It's less than a month until DevConnections in Las Vegas. With tracks that cover SQL Server, Windows, Exchange, SharePoint, Dev and more, this is a great place to learn about a variety of technologies. Register today
2013-09-10
2,058 reads
September 14, 2013 Pittsburgh will be hosting a SQL Saturday. Join them for a free day of SQL Server training and networking. There will also be a paid pre-con session the day before on Performance Tuning in SQL Server 2012 presented by John Sterrett and Konstantin Melamud.
2013-09-09
2,140 reads
PASS Professional Development Virtual Chapter will be hosting a session on what managers need to know about SQL Licensing, presented by Joseph D'Antonio on September 11, 2013.
2013-09-06
3,719 reads
SQL Saturday is coming to Johannesburg, South Africa on Saturday, September 14 2013. Join us for a free day of SQL Server training and networking.
2013-09-06
1,579 reads
Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.
2013-09-04
3,709 reads
SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners.
2013-09-02
1,511 reads
This is a PASS VC Webinar, taking place on August 28, 1PM EDT. Get interviewing tips from both sides of the desk. Based on Thomas LaRock's 10 Things blog posts, this presentation by both Thomas LaRock and Karen Lopez will give you valuable insight into the interviewing process and how to improve your chances of landing that next job.
2013-08-26
2,736 reads
Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!
2013-08-26 (first published: 2013-08-19)
4,472 reads
SQL Saturday visits Salt Lake City on September 7 for a free day of SQL Server training and networking. SQL Saturday has partnered with with the Utah Hadoop User Group and Utah Geeks Events to create the Big Mountain Data Conference.
2013-08-22
309 reads
A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.
2013-08-20
2,554 reads
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Comments posted to this topic are about the item Fun with JSON II
Comments posted to this topic are about the item Changing Data Types
Comments posted to this topic are about the item Answering Questions On Dropped Columns
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers