|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Multiple Escape Characters | |
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? | |
Think you know the answer? Click here, and find out if you are right. | |
| Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
The Last Binary Value of the Year What does this code return? SELECT cast(0x2025 AS NVARCHAR(20)) Image 1: Image 2: Image 3: Image 4: Answer: Image 2 Explanation: It's image 2. No special significance, just this is the last day of 2025 and this was the character returned from a US English SSMS with default collations. Happy New Year! |
| Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2019 - Administration |
| Database file shrink issue. - Hi experts, I have a 3+ TB database on a 2019 sql server which has more than 50% free space. I know database or data file shrink is not a good practice so please not go there, I tried with 100 mb in a loop which is taking much longer time so it's not feasible. […] |
| SQL Server 2019 - Agent job PowerShell step issue - I have a couple of SQL Agent job steps which run PowerShell commands of the form: Invoke-Command -ComputerName REMOTE -ScriptBlock {& "E:\Scripts\PowerShellScript.ps1" -ServerName "REMOTE\INSTANCE"} In each case, these steps have started failing with errors of the form: The job script encountered the following errors. These errors did not stop the script: Unhandled Exception: System.FormatException: Index […] |
| Analysis Services |
| Database backup job steps - I have a SQL Agent job for backing up a set of Analysis Services databases with each database covered by a different "SQL Server Analysis Services Command" job step of the form: { "backup": { "database": "CUBE NAME", "file": "CUBE NAME.abf", "allowOverwrite": false, "applyCompression": true } } However, if a database is added, deleted or […] |
| Editorials |
| The North Star for the Year - Comments posted to this topic are about the item The North Star for the Year |
| Finding Motivation - Comments posted to this topic are about the item Finding Motivation |
| The Side Job - Comments posted to this topic are about the item The Side Job |
| Happy Holidays, Let's Do Nerdy Stuff - Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy Stuff |
| Article Discussions by Author |
| Multiple Escape Characters - Comments posted to this topic are about the item Multiple Escape Characters |
| The Last Binary Value of the Year - Comments posted to this topic are about the item The Last Binary Value of the Year |
| SQL Art, Part 2: New Year Fireworks in SSMS - Comments posted to this topic are about the item SQL Art, Part 2: New Year Fireworks in SSMS, which is is not currently available on the site. |
| Database security permissions save script - Comments posted to this topic are about the item Database security permissions save script |
| SQL Server 2025 Backup Compression Algorithm - Comments posted to this topic are about the item SQL Server 2025 Backup Compression Algorithm |
| The Large Encoded Value - Comments posted to this topic are about the item The Large Encoded Value |
| UNISTR Escape - Comments posted to this topic are about the item UNISTR Escape |
| SQL Server 2022 - Development |
| reaching ftp thru winscp but erroring in ssis ftp task connection - Hi, below i show various results trying to reach our ftp site (a globalscape product) from both winscp and ssis's ftp task as a certain user on a certain port. as far as i know, in winscp i choose FTP as the protocol even though its more appropriately FTPS (not sftp). in ssis i tried […] |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |