This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database. This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP. It will then generate, and execute, all […]
2004-01-22
280 reads
2004-01-22
404 reads
This script will help you locate columns that you provide in a comma delimited format. You pass it as few or as many columns as you want in the following format: ',,....' and this will generate you a report that states which database, and table each column you passed is in.
2004-08-13 (first published: 2004-01-22)
129 reads
Definitely not a beginner article, this one describes how to asynchronous execution using delegates in C# (C Sharp). Async is usually harder to implement - conceptually at least - but offers benefits in that the user/application isn't blocked while you wait on results.
2004-01-22
7,229 reads
-- The goal is to avoid the use of sp_start_job in an application. So we have the application use RAISERROR to activate the job.-- 1) because you can only start jobs you own-- 2) we don't want to open the cmdshell to everyone-- 3) we want control regarding jobs that run on our server.-- 4) […]
2007-05-31 (first published: 2004-01-21)
2,170 reads
Useful for testing if file is available for manipulation prior to trying to "process" it.From forum thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=19344Thought I may as well add it to the Scripts Library.
2004-01-16
306 reads
I bet most of us count and sum fairly often, but how often do you use the rest of the 'in the box' statistical functions? Learn these now and be ready when you need them.
2004-01-12
27,643 reads
This script will generate a stored procedure named procCreateXSD. Run this script to create the SP.The purpose of this SP is to generate the XSD from selected tables we passed to the script. It accepts the Dataset name, URI, and the list of the tables to be included.For example:exec proccreateXSD 'NorthwindDataset', 'http://www.tempuri.org/', 'Customers,Orders,Products'Be aware that […]
2004-01-08
378 reads
David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.
2004-01-06
6,422 reads
New Author! This is an introductory level look at MDX geared toward intermediate or higher SQL users. The rate of OLAP usage is lower than it should be - maybe this will be what gets you started using it. Or thinking about it at least!
2004-01-02
22,796 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
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