Create Dynamic External Table in Azure synapse Analytics
This script creates an external table in Synapse.
2023-08-21 (first published: 2023-07-26)
1,231 reads
Scripts
Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs
Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily used for data manipulation in databases and not for complex data validation. However, depending on the database system you are using, there might be some limited string manipulation functions available that can help you perform basic validation checks.
2023-07-28
410 reads
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,883 reads
2023-07-18 (first published: 2010-03-18)
2,129 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,493 reads
2023-07-18 (first published: 2009-03-13)
2,160 reads
2023-07-18 (first published: 2012-12-04)
1,716 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)
889 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,952 reads
2023-07-18 (first published: 2009-04-28)
3,830 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU MENARA BIDAKARA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1, RT.1/RW.1, Menteng Dalam,...
BCA KCU PLUIT No.Telpon 087781685647
Whatsapp 087781685647 Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North...
BCA KCU KALIMALANG No.Telpon 087781685647
Whatsapp 087781685647 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers