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
)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]
ALTER TABLE [dbo].[utPerson] ADD DEFAULT (getdate()) FOR [insertDttm]
ALTER TABLE [dbo].[utPerson] ADD DEFAULT ((0)) FOR [insertorId]
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?
12 freelancer bu iş için ortalamada 62$ teklif veriyor
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