The script finds occurrences of string(s) in stored procedures, triggers and views. You can use typical boolean logic as described in the script comments. Very useful. It was found on the companion cd to [Gurus Guide to Transact-SQL] by Henderson. I left in the original credits. Excellent procedure. Some may scoff but I place it […]
2004-07-15 (first published: 2004-07-02)
700 reads
This stored precedure can be used within a scheduled job to UPDATE STATISTICS on a data during off hours.I have commented out a parameter used to limit the size of tables to UPDATE STATISTICS. Script uses the Northwind database.Have a GREAT day!!
2004-07-14 (first published: 2004-07-02)
485 reads
SQL Server returns numeric values always in a internal format. The conversion of numeric values into a language specific format is usually part of the client. With this User Defined Function, you can do thison your backend. The function expects 3 parameters: The numeric value, the requested language and the number of decimals (will be […]
2004-07-13 (first published: 2004-07-02)
389 reads
Do you ever need to look for a given user's permissions for security reasons or move the permissions for that user from test environment to production? This is a script, which will generate print statements, which can be use to view/grant, the permissions of all dbo objects, which the given user has, which is not […]
2004-07-08 (first published: 2004-01-16)
903 reads
My first stab at a script, I have a dev server will 60 + db'sI wanted to db size + log size in a more centralised location.
2004-07-07 (first published: 2004-01-09)
734 reads
This script will generate and populate a table variable with a stipulated number of unique 8 randomly generated character alphanumeric values. This can be useful in situations where one has to allocate passwords or unique id to users. It accepts one input parameter "@HowMany int" representing the number of these alphanumeric values to generate; default=500.Usage: […]
2004-07-06 (first published: 2004-01-09)
3,554 reads
Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]
2004-06-25
947 reads
This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run. This is sometimes helpful during upgrades, etc. There is no error checking in this script. You can modify it to add, if needed.Run this by simply […]
2004-06-21
235 reads
This script will help in removing the duplicate values from a table.
2004-06-15
339 reads
This SP gets all the table names with the column names and data types, datalength. All the existing constrains on the table and column levels along with the Primary and foreign keys and table references
2004-06-01
279 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers