Based on moffan76's script to GRANT EXEC to all sprocs and UDFs (that EXEC) and GRANT SELECT to views and UDFs (that SELECT). This script uses that same general technique of selecting the object names from sysobjects, but does it in one step w/o using a cursor. It is also not wrapped in a sproc […]
2003-12-30
229 reads
Monthly SQL Server Agent Jobs report Script Monthly SQL Server Agent Jobs report. It will give a summarized picture of SQL Agent jobs run during a calendar month. You can use it to file up reports for system audit. It does not handle jobs that are run more than […]
2003-12-30
1,444 reads
This Script takes a user name and set execute permissions on SPs and UDFs.
2003-12-28
317 reads
This version uses the Sieve of Eratosthenes algorithm, which is very fast for moderate upper bounds, but which may be slower than the other versions when the upper bound is very large (because of the overhead of the initial table population)
2006-03-14 (first published: 2003-12-17)
146 reads
T-SQL String Function: Returns passed date formatted using passed criteria. Format criteria similar to Visual Basic. Sorry, prior script had a reference to one of my internal UDFs :(.
2003-12-17
248 reads
This article presents two best practices. One is about how to construct good table aliases, the other is about using ANSI join syntax. Good stuff!
2003-12-17
10,897 reads
This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it.
2003-12-16
7,998 reads
Full text indexing is interesting, but not always easy for the user to apply well. Chris has some ideas about to make that
2003-12-11
12,276 reads
T-SQL String Function: Returns passed date formatted using passed criteria. Format criteria similar to Visual Basic. Saw that I could correct it, so corrected 3/8/04
2003-12-09
204 reads
Andy started writing about worst practices a long time ago and returns this week with one that is short and sweet - why defining rows that exceed 8060 characters is a very bad idea and how you can avoid it.
2003-12-08
8,835 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