I want to thank James Travis for his original and excellent work and to Razvan Socol for alerting about a similar problem that led me to improve James' code. The problem is that when searching for a word that is split between two 8kb blocks, James' code would ignore it. The solution is to look […]
2004-02-21
151 reads
Joseph gathered together some various bits of code and came up with a solution that lets you do RC4 encryption via the sp_oa~ procedures.
2004-01-09
8,991 reads
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
2003-12-29
5,815 reads
2003-01-14
78 reads
This UDF returns the Service Pack versionprint dbo.ServicePackversion()
2003-01-14
95 reads
This UDF will return the checksum for a SP or UDF to help tracking changes to the code.Example:print dbo.OBchecksum('hello')
2003-01-07
145 reads
This free extended stored procedure can read and write to a stored text file. Perfect for writing error logs!
2002-12-24
122 reads
This UDF will validate a credit card number using Luhn's formula.For example 49927398716 will return 1:print dbo.luhn('49927398716')print dbo.luhn(49927398716)11based on:Credit cards, validation and the Luhn formulabyEduardo Chaveshttp://www.webdevelopersjournal.com/articles/validation.htmlAlgorithm converted to TSQL by Joseph Gama
2002-12-12
517 reads
ASCII table and UNICODE tableYou can easily change the font of "SQL Query Analyzer":TOOLS/OPTIONS/FONTS
2002-12-11
491 reads
This SP will create an Access database from TSQL using ADOX.Instead of Access, the Provider can be changed so that it will create *any* kind of database from DBase 3, Oracle, Excel, etc...
2002-12-11
336 reads
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Comments posted to this topic are about the item The Cloud Security Problem
Comments posted to this topic are about the item Virtualizing AWS data by using...
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
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