Another way to get a table list from a string
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2023-07-18 (first published: 2010-05-13)
1,767 reads
Scripts
2023-07-18 (first published: 2010-03-18)
2,018 reads
Get a range of numbers
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2023-07-18 (first published: 2012-04-23)
1,381 reads
2023-07-18 (first published: 2009-03-13)
2,052 reads
2023-07-18 (first published: 2012-12-04)
1,564 reads
Parsing INTERNAL REPRESENTATION OF OVERPUNCH SIGNS
Some times you need to parse over punch values at the while running a query.
Here is an utility function to help with that task.
2023-07-18 (first published: 2018-10-31)
676 reads
Print Text Month Calendar
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2023-07-18 (first published: 2012-10-31)
1,829 reads
2023-07-18 (first published: 2009-04-28)
3,542 reads
2023-07-18 (first published: 2009-11-11)
797 reads
User-Created GENERATE_SERIES() Function for Older SQL Server Versions
In the world of SQL Server, adaptation is key. While the built-in GENERATE_SERIES() function was a valuable addition in SQL Server 2022, its absence in older versions created a functionality gap. Enter the user-written GENERATE_SERIES function. Adapted from Jeff Moden's "dbo.fnTally", it offers an efficient means to generate a series of numbers within a defined range in older SQL Server versions. Its design mirrors the built-in function in SQL Server 2022, making the transition between versions as simple as removing the dbo. prefix. This forward-thinking design reflects the ingenuity of the SQL Server community, ensuring a seamless, efficient database migration experience.
2023-06-26 (first published: 2023-06-16)
1,002 reads
Blogs
New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
Forums
Reporting Services Editions
Comments posted to this topic are about the item Reporting Services Editions
Exporting and Importing Registered Servers in SSMS
Comments posted to this topic are about the item Exporting and Importing Registered Servers...
AWS RDS for SQL Server - Backup to/Restore from s3 - Multiple Account Scenario
Hi All, I need a sanity check, and hoping someone here can provide it.......
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers