Generating Random Results - SQL School Video
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
2009-01-15
3,178 reads
Random Numbers
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
280 reads
2008-12-12 (first published: 2008-11-19)
837 reads
Create Sample Data Script
in this scripts there are two methods of creating sample data for a gambling application.
i have used both cursors and loops.
2008-10-10
683 reads
Generate a random password
If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.
2013-05-15 (first published: 2008-09-24)
3,324 reads
Random DEFAULT string for a column using CASE and NEWID
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
2012-06-14 (first published: 2008-01-16)
1,102 reads
RE: Upgrade to MDAC 2.8 or not?
If you use W2003, you do not have any choice about using MDAC 2.8 - it is the version shipped with W2003.
2004-09-16
RE: Duplicate Records
Something like this..CREATE TABLE SSNTemp ( SSN char (10) NOT NULL ) CREATE UNIQUE INDEX [IX_SSNTemp] ON SSNTemp ([SSN]) WITH IGNORE_DUP_KEYinsert into SSNTemp select ssn from yourssntable delete from yourssntableinsert into yourssntable select ssn from SSNTemp
2004-08-12
RE: Concatenating Addresses
how do i account for columns that are "null"?There is not always a "streetsuffix", for example.
2004-07-28
RE: OPENDATASOURCE- experience with;any other way of not using linked servers
Just for giggles...What happens if (not this EVER happens) your Network guys MOVE the network segment that your box is on and forget to tell you?I know this from experience. Not only did they MOVE the segment and change the IP of the server they didn't tell any.We used 2 different NICs in the server […]
2004-07-08
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers