2001-07-13
2,945 reads
2001-07-13
2,945 reads
ne of the issues you face when building Web applications is handling the errors you encounter when interacting with a back-end database. I was recently working with someone to create a new Web site with SQL Server™, ActiveX® Data Objects (ADO), and ASP. Lots of little things came up that I thought were worth sharing with MIND readers, so I'll focus this column on what I learned from this experience and the solutions to many of the problems I faced.
2001-07-13
1,579 reads
2001-07-12
3,330 reads
P2P, the programmer's resource centre from Wrox Press, reached a milestone of 25,000 subscribers this week. To celebrate this fact, Wrox are giving away $1000 worth of books and ASPToday subscriptions in a free prize draw. For more details on how to enter, please visit: http://p2p.wrox.com/25k.asp. The draw will be made on July 16th.
2001-07-12
45 reads
This article by Neil Boyle looks at the enhancements to triggers that SQL Server 2000 brings.
2001-07-11
6,691 reads
This book discusses some of the issues that exist today in software. A good read for anyone developing software.
2001-07-11
2,942 reads
2001-07-10
5,431 reads
2001-07-09
3,585 reads
If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.
2001-07-09
4,417 reads
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
2001-07-06
9,102 reads
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
Given the following table and query, this will return any records(based on message_id) that...
How to merge two tables with unlike fields. I have two table with one...
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers