TSQL: To find number of words in a given string
Download the codehttps://gallery.technet.microsoft.com/T-SQL-How-to-Find-Number-533b6b39
DECLARE @DemoTable Table
(Col varchar(500));
INSERT INTO @DemoTable (Col)VALUES ('JOHN...
2014-12-30 (first published: 2014-12-26)
8,348 reads
For more Information refer Technet Article
Introduction
sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount...
2014-12-26
1,044 reads
Problem statement:-
A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code...
2014-12-23
1,567 reads
SP_SPACEUSED
sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by...
2014-12-01 (first published: 2014-11-24)
6,818 reads
There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...
2014-11-07
1,031 reads
This post explains how to monitor a multiple services on a list of servers and send alert when the given...
2014-11-06
744 reads
This post is one of the request from OP.
Download SQL Backup SP in the same database
The probelm statement 1:-
Create a...
2014-10-14
887 reads
The following query lists all the Primary keys of all the table.
OP has requested to list all PK and composite...
2014-09-16 (first published: 2014-09-10)
7,102 reads
USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS
One of op requested to list all the user defined databases...
2014-08-15
1,312 reads
This post explains how to monitor a multiple services on a group of servers with alternate credentials.
This script will allow...
2014-07-03
1,069 reads
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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;
GO See possible answers