Extracting string after and before a Character/Pattern
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
245,473 reads
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
245,473 reads
Sends an HTML formatted Email with autogrowth Information for the last 24 hours.
2017-01-03 (first published: 2016-12-20)
1,059 reads
This is a small script designed to read the Contents of the SQL Server log based on None or more criteria.
2016-12-30 (first published: 2016-12-13)
882 reads
A T-SQL implementation of FizzBuzz consisting of a single SELECT statement.
2016-12-28 (first published: 2016-12-15)
947 reads
Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
830 reads
A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range.
2016-12-12 (first published: 2016-11-30)
2,260 reads
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.
2016-12-09 (first published: 2015-05-12)
2,335 reads
Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.
2016-12-08 (first published: 2015-01-26)
2,388 reads
select top * from table by highlighting the fully qualified, including database, table, using a keyboard shortcut.
2016-12-07 (first published: 2015-05-07)
2,830 reads
2016-12-06 (first published: 2015-07-27)
2,497 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers