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

347 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

1,540 reads

Blogs

Daily Coping 8 Jul 2020

By

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

Don’t be afraid of No

By

How many times have you been afraid to hear “No”? We have all been...

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Read the latest Blogs

Forums

In where condition use column value which contains column name

By rohit.kumar.barik

Hi Team, Greetings! I have below table. let table name =Emp I need to...

Indexing in a Merge Replication environment

By pssudarshan

Hello SQL Gurus I am new to Database design.  We are building an application...

compare row data

By abhas

Hi , I am having table in below format. I want to calculate difference...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers