Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!
A personal article refering to the latest change from NTL broadband stopping port 1433 globally on their network. Users are no longer able to develop Microsoft SQLSever systems using ODBC or Enterprise manager.
Learn about SQL Server and the CLR. Join PASS and speaker Michael Otey, Senior Technical Editor for SQL Server Magazine and Windows & .NET Magazine and President of TECA, Inc., for the upcoming WebCast where you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005. Registration Required.
Office 2003 has a new tool: InfoPath 2003, which can work with SQL Server along with numerous other data stores. It's a great way to begin working with XML, Web Services, and many of the newer technologies that are available today. Join Dinesh Askanka on his journey to learn more about InfoPath2003 in the start of another series.
SQL Server Find, a product from Genius@Work, allows you to search your databases for objects based on a variety of criteria.
Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.
Upscene Productions is happy to announce a new version of
the database developer tool: "Advanced Data Generator" (version 1.1.0)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition
More info, pricing and a 30-day trial version on www.upscene.com
Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.
Andwil, 06-Jun-2004: To celebrate the 1-year anniversary for their SASSI v2.0 professional SQL Development Environment application, Dynamic3 GmbH is offering a limited amount of SASSI license keys for FREE! To register for a free license key, visit the website now! http://www.sqlassi.net
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
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...
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