The stored proc FindObjByColumn_sp, while simple, is extremely useful when making database changes or for any reason that you need to find any tables and stored procedures that contain a particular column. It searches the system tables of a database to find the object containing the column. In addition, the procedure automatically adds a wildcard […]
2002-10-31
443 reads
The script will do the following:- build a ten digit phone number regardless of input column size.- Ignores extensions- Ignores leading 1, as in 1(800)...- Ignores most special characters or spaces- converts literals to digitsIt can be easily convert to a UDFEnjoy.C. Z. Ovits
2002-10-28
578 reads
Using the sp_help to get a table structure is very cumbersome. First, in order to print it you have to use"Results in Text" not "Results in Grid". Second, the results are very wide screen-wise and very hard to read or print. Third, you do not get the size or number rows with the same request.This […]
2002-10-28
194 reads
Here is another Number of Days in the Month function for SQL Server without the use of Case or if statements. It uses the DATEPART and DATEADD built-in functions.
2002-10-28
429 reads
Recently I saw here a script that returns the number of days of the month however I made my own script and I think that it's better elaborated. It's true that this is my opinion, but here it's. Evaluate it yourself.print dbo.f_days_in_month('2000-02-21')
2002-10-26
485 reads
This stored procedure extract the error code and description form the DTS package log tables in the msdb database.You just pass it the package name, step name and the time that the step started ( because you could end up with many entries in the log ) and it will return the Error Code and […]
2002-10-25
2,692 reads
We frequently have to work out a date based on a number of working days before or after a specified date, excluding Saturdays and Sundays.Attached is the script to create the function. I call another function called fn_Midnight which was designed to help whe programmers get a date with no time portion without having to […]
2002-10-22
489 reads
Do you run jobs that call BAT files where you wish you could include a formatted date stamp in the output name of an OSQL file? Well, you can using the DOS 'FOR' command. I named a variable FILEDATE and use it as: path\Filename_%FILEDATE%.txt (Note: A BAT file requires double %% in the 'FOR' command […]
2002-10-21
1,109 reads
Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code!
2002-10-15
8,663 reads
A user defined function to return a table af tokens from a delimited string.Uses text variable so string can be of unlimited length, performs better than a list of xml elements. Now supports returning of tokens by position
2002-10-12
809 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers