Use following script to generate random Passwords
DECLARE @id int,@list varcharSET @list ='abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ23456789.,-_!$@#%^&*'selectreplace(SUBSTRING(CONVERT(varchar(255),NEWID()),8, 8),'-','')as RANDOM
Example:
Suppose you have a table tblUser with columns[id],[userid],[password].
CREATETABLE [dbo].[tblUser]( ...
2013-02-12
4,878 reads
My first official entry for T-SQL Tuesday (my first was a guest post hosted by Kendal Van Dyke (blog|twitter), so I’m not really counting it) is brought to you...
2013-02-12
8 reads
February is a short month… and if you are following the Monday’s you know that today’s the second Monday of the...
2013-02-11
674 reads
Checkout the third part of my XML support and SQL Server article series here.
In this part, I talked about the...
2013-02-11
692 reads
Today, I received an email from the development team complaining why they have not received any of the SQL Agent...
2013-02-11
4,504 reads
This past weekend was the first SQL Saturday in New Mexico. I had written about our trip down last week,...
2013-02-11
1,073 reads
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.
But Sometimes...
2013-02-11
1,847 reads
Our first free SSIS Webinar is over and the overall satisfaction score we got was 9.2 out of 10 so...
2013-02-11
1,020 reads
I have a new blog post up at HouseOfBrick.com on why you should understand your workload performance characteristics. When you...
2013-02-11
942 reads
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically...
2013-02-11
2,350 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Absolute and Relative References
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I