Review: SQL Server 2000 Database Design
Is this a book you should read? Spend a few minutes reading the review to find out!
Is this a book you should read? Spend a few minutes reading the review to find out!
Our first contest will begin July 23rd! We’ll be giving away a free Wrox book titled: SQL Server 2000 Database Design
to the individual who refers the most users to SQLServerCentral.com throughout the duration of the contest. The contest will last from July 23rd until July 29th.
To insure that each referral counts, make sure that each person you refer has your SQLServerCentral.com registered email address. Good luck!
This article presents a method of outputting the results of a query as a tab delimited text file using COM.
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.
Ever had to calculate the number of business days between two dates? This article presents a way to solve this problem in T-SQL.
Steve Jones's review of a great guide for tuning the Windows 2000 OS.
WebCast! June 27, 2001 from 9:00am to 10:30am Pacific Time. Registration closes 24 hours prior to the event start time.
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
Comments posted to this topic are about the item Concatenating Multiple Row Values into...
Hi there, I've tried CROSS APPLY, PATINDEX and many other functions, but can't nail...
What is the best way to continually loop a SQL Server Agent Job? I...
I have some simple sales data in a SQL Server 2022 database that looks like this:
TransactionDate SalesAmount 2023-01-15 1200.00 2023-02-22 1500.50 2023-03-10 900.75If I run this query, what are the sales growth amounts returned?
SELECT ms.TransactionDate , ms.SalesAmount , ms.SalesAmount - LAG (ms.SalesAmount, 1) OVER (ORDER BY ms.TransactionDate) AS SalesGrowth FROM dbo.MonthlySales AS ms;See possible answers