UDF Random Password Generator

UDF Random Password GeneratorYou can not use the RAND function directly from a User Defined Function. So the UDF I wrote "fn_RandomPassword" uses the view "view_RandomPassword8" to get the random charaters.Having the random password generator is useful if you need to insert a large number of users into a table with random passwords assigned.For example […]

5 (2)

2003-08-07

356 reads

Convert Interger to Binary String for Bit Masks

The three functions here can be used to store Bit Masks as Integers.These are functions to convert an integer into a binary string. This can be useful if you store Bit Masks in your database as integers.For example .. '00000000000011111001001001110011' to 1020531Each Bit could represent an ON or OFF value. One integer columncould be equivalent […]

5 (1)

2003-03-21

2,232 reads

Blogs

Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8

By

With the WordPress 5.8 release, we're starting to introduce features that overall improve your...

My Application is Getting SQL Timeout Errors, But What Query is the Problem?

By

This is something that comes up time and time again. A developer or member...

Daily Coping 27 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Get charges percentage per entity\channel

By Bruin

I trying to figure out what percentage of the total charge for a ME...

How to find islands and get max and min range values

By itlk

I am trying to create groups for each Name and save the max and...

FISCAL_WEEK from 1 Jan till First Friday

By birajdarmm@gmail.com

Hi, We have one requirement. Wee need to create a fiscal_week column in SQL_server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers