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,376 reads

Discuss

Date/Time formatting function

by Serge-Shakhov

SQLServerCentral

Miscellaneous

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

947 reads

Discuss

Splitting string of values to table

by Serge-Shakhov

SQLServerCentral

Miscellaneous

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.