Miscellaneous

Script to find text in stored procedures

  • Script

This is a simple script that when used by command-line OSQL/ISQL can help you locate a stored procedure.How many times have you been looking for stored procedure code and could not find it?  This is a simple method to locate lost code.When you manage many database servers this can become a common problem.  The scenario […]

5 (2)

2007-09-14

1,808 reads

Combine multiple rows into single output

  • Script

We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/

5 (3)

2007-09-14

3,605 reads

LSTR() and RSTR(): Enhanced LEFT() and RIGHT()

  • Script

Quite often I need to cut off the first (or last) few characters of a string. To do just that I created two functions LSTR() and RSTR().Syntax: LSTR( @stringtocut, @length )Note: @stringtocut is trimmed in the functionWhen @length is equal or larger than zero, this function performs the same as LEFT( LTRIM(RTRIM(@stringtocut)), @length ).When @length […]

1.67 (3)

2007-09-13

891 reads

finding the blocks in sql server

  • Script

Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]

3.67 (3)

2007-09-09

3,527 reads

Blogs

Daily Coping 29 May 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Custom Quarantine PoSh Prompt

By

Since I’ve been quarantined at home and working in my office, every day is...

TIL: Get-DbaErrorLog

By

Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in...

Read the latest Blogs

Forums

Week Ending Thursday, can some one tweek my code?

By bark01

What I have missed from this code? I'm trying to show the DateTimeRaised field...

The Matchbox Database

By Phil Factor

Comments posted to this topic are about the item The Matchbox Database, which is...

Filtering out based Start Date and End Date

By koti.raavi

Hello, I have query contains both start and end date, i would like to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers