That is a good script but with a little problem. It shows 1 less table than in the schema. Its not a script from me so I have not changed the contributor's name.The only change is I have made is moved FETCH NEXT statement at the end of the loop and removed IF @@FETCH_STATUS = […]
2002-02-18
172 reads
If you've ever needed a convenient and quick way to convert/validate what could possibly be a mm/yy or mm/yyyy date to mm/dd/yyyy (date of month is 01) check out this custom function. Eg: select dbo.datemy('04/02') outputs smalldatetime '2002-04-01 00:00:00'. Select dbo.datemy('04/2002') outputs the same smalldatetime '2002-04-01 00:00:00'.
2002-02-15
896 reads
You can effectively rename a user account but as this is messing wit the system tables I would suggest dropping and adding the user back. But for those of you who really want to know how here it is.First off I tested this and it works fine renaming a user. However this is directly modifying […]
2002-02-14
949 reads
Have you ever wanted to have SQL note a failure on a step, yet continue running the job. I found it to be annoying that you have to fail (and end) a job in order to send a message to an operator. I have processes that run at off times, I want to know when […]
2002-02-13
2,337 reads
This proc compares the table definition and the data in a table which is in two of your databases. Typically you may have a development database and a production database on the same server and you just want to know that the table is the same on both. (This proc will express the data differences […]
2002-02-11
309 reads
This script runs from the master database and records all the databases on the server. It then checks each database for users and records their name and the database(s) on which they have access. You can then create a nice cross tab report using any report designer (I used crystal) showing users on the databases […]
2002-02-11
518 reads
This is a simple function I use to get the month/day/year of a datetime value.Usage:Select mydb.dbo.udfmmddyyyy(Getdate()) Note: This is easily modified for British/Australian date format.
2002-02-11
1,187 reads
I occasionally need to return a month and year but would like the month as a 3 letter abbreviation instead of a number. This is useful for reports.Usage:Select mydb.dbo.udfmmm_yyyy(Getdate())
2002-02-11
1,012 reads
Since SQL Server stores time as a full datetime value, I use this script to return just the time part formatted as hh:mm:ss.Usage:Select mydb.dbo.udfHHMMSS(Getdate())
2002-02-11
931 reads
This script provides the DDL required to unconstrain and then reconstrain a table so that in between you can modify the tables contents without being hampered by referential integrity constraints a long the way.Typical call:- utl_UnConstrain 'MyTable'
2002-02-11
260 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers