Finding table name based on a specific value
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
439 reads
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
439 reads
In this post, Eli Leiba shares a script that can be used to find the oldest open transaction and the statement that was issued.
2016-12-01
3,461 reads
This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.
2012-09-20 (first published: 2012-08-21)
953 reads
At times, we have situation to parse the character separated string in the table column.
2010-07-14 (first published: 2010-06-17)
2,175 reads
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Potentially dumb question. There is 1 x ldf & 1 x mdf for DB1. ...
Hello, I made mistake during updating cells in table.In column that contains int type,...
Hi, I've come across an odd situation, and was wondering if anyone can explain...