This script will list all stored procedures that are calling the specified stored procedure. Also could be used to find procedures that contain any specified expression or words.
2002-05-01
1,035 reads
All what you need to do is to set the values of a couple of variables; NAME OF the TABLE you want to query (or you can write your own select statement here), NAMES OF COLUMNS you want to display, name of COLUMN for SORTING, define NUMBER OF ROWS on one page, NUMBER OF REQUIRED […]
2002-05-01
425 reads
Pads a string (e.g. a number that needs left padding with zeros) with any character for as many as it takes to bring the inputted string to the total desired length.
2002-05-01
581 reads
This script shows how to retrieve combination of different columns that may have nulls.
2002-05-01
792 reads
This select will be useful for developers/ database designers / DBAs to find the rowlength instantly. This select also makes use of system function to get rid of joins. Only for sql7 and up.
2002-04-30
457 reads
In most places, we use some kind of field naming convention. Many times we have one or more fields with similar name in all tables for some kind of tracking. You can use this query to find similar names in all tables.
2002-04-29
273 reads
Need to Transform a table with Summaries to be plugged into EXCEL or place a table of info in one row. This is cool and has been a real time saver!!! Simply save as a Template file in your favorite template folder. In Query Analyzer go to Menu Tools... Options... General... Note the path of […]
2002-04-26
1,842 reads
Script showing how to count the number of Yes /No answers in the string Inspired by tip that didn't work on Microsoft website
2002-04-26
574 reads
This procedure will be useful for developers/ database designers / DBAs to find the rowlength instantly.To find the row length of a user table, just copy this script into Query analyser and pass the table name for which you want to find the rowlength. @TabName is the table name parameter, if we donot provide this […]
2002-04-25
2,941 reads
Set the Autoclose database option to True and perform a cold backup of your data files without even shutting down the SQL Server Services.
2002-04-25
971 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
I am not sure which is the best way to proceed. I have parent...
Comments posted to this topic are about the item Hyperscale Replicas III
Comments posted to this topic are about the item Development Is Fun
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers