Scripting user permissions
This Stored Procedure will display object level permissionsfor stated User or Role.Procedure output is ready to execute batch.Usage: Exec ScriptPermissions 'public'
2002-02-27
1,379 reads
Date/Time formatting function
T-SQL analog for Visual Basic FORMAT function. Created for MSSQL 2000. Works regardless of language settins on server or client side! fn_format('YYYY/DD/MM HH:MI','2002-03-13 12:00') = '2002/13/03 12:00' fn_format('DD.MM.YY','2002-03-13 12:00:00') = '13.03.02' fn_format('HH:MI:SS','2002-03-13 12:00:00') = '12:00:00'
2002-02-05
948 reads
Splitting string of values to table
This function can convert string with separated values to table. Exclusive feature: items inside quotes will not be splitted! Now you can easily perform joins on CSV strings! For expample: fn_split('1, 2, ''3, 4'', 5',',')= 1 2 3, 4 5 First parameter - string with values, second - delimiter character.
2002-02-05
1,158 reads
Blogs
Weekly reading #26
By damianwidera
Good morning! It was a tough weekend as we supposed to be in Goteborg...
Delete an Azure DevOps Project
By Steve Jones
Not something you’ll do too often, but you might find yourself doing this if...
Ways to access data in ADLS Gen2
By James-Serra
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
“Included columns” for non-clustered indexes explained
Comments posted to this topic are about the item “Included columns” for non-clustered indexes...
Reindexing a database
Comments posted to this topic are about the item Reindexing a database
Ask SSC