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,833 reads
bernabe.diaz@yahoo.com
2023-07-18 (first published: 2010-03-18)
2,071 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,438 reads
2023-07-18 (first published: 2009-03-13)
2,093 reads
2023-07-18 (first published: 2012-12-04)
1,635 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)
793 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,891 reads
2023-07-18 (first published: 2009-04-28)
3,721 reads
2023-07-18 (first published: 2009-11-11)
832 reads
Blogs
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Searching a Form (using "Find") after an Access to SQL Migration
I have completed a successful migration of an access database to SQL Express. Most...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers