This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!
2001-06-25
2,561 reads
Answers to the SQL quiz that Steve Jones used to give to prospective employees.
2001-06-22
11,604 reads
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
2001-06-22
13,435 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,868 reads
2001-06-20
3,636 reads
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads
2001-06-18
1,973 reads
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000.
2001-06-18
5,395 reads
Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server
2001-06-18
2,859 reads
2001-06-15
7,442 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers