Devam Ediyor

Name generator

There is a requirement to randomly generate 25,000 first and last name combinations and use them to change the names in an existing SQL Server database table. This will allow me to move a production database table into a QA database table while replacing the real names with fictitious names.

This is the description of the database table:

CREATE TABLE [dbo].[utPerson](

[personId] [int] IDENTITY(1,1) NOT NULL,

[nmFirst] [varchar](32) NULL,

[nmLast] [varchar](32) NULL,

[dob] [datetime] NULL,

[age] [tinyint] NULL,

[race] [int] NULL,

[sex] [int] NULL,

[insertDttm] [smalldatetime] NULL,

[insertorId] [int] NULL,

CONSTRAINT [PK_utPerson] PRIMARY KEY CLUSTERED

(

[personId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[utPerson] ADD DEFAULT (getdate()) FOR [insertDttm]

GO

ALTER TABLE [dbo].[utPerson] ADD DEFAULT ((0)) FOR [insertorId]

GO

You will need to provide a query that will update the 20,000+ rows in the table utPerson with randomly generated first and last names. The only columns your query should change are nmFirst and nmLast.

What are your questions?

Beceriler: SQL

Daha fazlasını görün: production name, sql create table generator, create primary key sql, generator database, generator sql server, sql server table generator, last name, name generator, production database, update query sql server, sql server create table, combinations generator, sql generate update, generate sql update, qa database, sql datetime null, sql server null default, domain name generator bid, random file name generator, paintball team name generator, null int sql, bbq team name generator, guild name banner generator, add generator, race database

İşveren Hakkında:
( 76 değerlendirme ) Peachtree City, United States

Proje NO: #4410799

Seçilen:

luki555

Hi. Check your PM please.

3 gün içinde 35$ USD
(0 Değerlendirme)
0.0

12 freelancer bu iş için ortalamada 62$ teklif veriyor

serkanarslan

I will update table with using exsisting table data. I will generate names and lastnames from existing data

1 gün içinde 50$ USD
(52 Değerlendirme)
5.7
cheapexcell

What names ? US English names ? Any names ?

in 2 gün içinde75$ USD
(10 Değerlendirme)
3.3
IntellectMatters

Hello AppsDoneRight - I would like to bid for this.

1 gün içinde 35$ USD
(3 Değerlendirme)
2.6
srdas2012

Hi we are Expert in SQL and other Data Base ,Please see PMB

in 2 gün içinde47$ USD
(1 Değerlendirme)
1.7
danielbarragan13

I've got the skills needed to complete your project ASAP. PM for details and sample

in 0 gün içinde40$ USD
(1 Değerlendirme)
1.1
pasupathiganesan

I Know this Concept...very easy concept..I can easily finish within one days..can i help u

1 gün içinde 140$ USD
(0 Değerlendirme)
0.0
dinupkp

I have a very good experience SQL server...

1 gün içinde 55$ USD
(0 Değerlendirme)
0.0
tbandeiras

I've done some works like these, to protect the privacity of clients properly, including random data to related tables when needed.

in 3 gün içinde160$ USD
(0 Değerlendirme)
0.0
tsalmark

I will happily provide a text file with SQL commands to update the table, or with access to the QA database to the update myself. To update the table I

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
majid43

i am interested in your project, may i help you for this ?

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
TERA2TECH

HI, i can do this. Let me get the chance.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0