FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with MS SQL SERVER commands in order to do the following : The ID is the first 2 letter of first name followed

Need help with MS SQL SERVER commands in order to do the following :

The ID is the first 2 letter of first name followed by number. Eg. If the name is Ron Gates, then his ID can be RO3283.

I've messed around with SUBSTRING, CONCAT, AUTOINCREMENT, AND IDENTITY

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

In many situations, a woman perceives herself as an object that can be viewed by other people. True or False

Answered: 1 week ago

Question

★★★★★
Missoula Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by...

Answered: 1 week ago

Question

★★★★★
question 18 5-8 5. Paid $6,000 for utilities and $4.000 for advertising. NOTE: Debit entries need to be listed first. Please do not indent credit entries. Dollar values need to be entered with no...

Answered: 1 week ago

Question

★★★★★
Find an example of a governmental price controleither current or historic is fine. This could be a price ceiling or floor, quotas, anti-gouging laws, or other such policies. Summarize the policy....

Answered: 1 week ago

Question

★★★★★
1) An organisation has the following contribution function: Contribution = 5X + 10Y where X = the number of units of product X produced, and Y = the number of units of product Y produced. A graph has...

Answered: 1 week ago

Question

★★★★★
Case Study: If Only I Had Known A few months ago, Maria Turks, manager of client care at Willowpark Retirement Centre, was asked to review a job description for caregiver as 25 people in this job...

Answered: 1 week ago

Question

★★★★★
(LO3, 4, 6) Exercises 4-24 Indirect cost rates and the death spiral Famous Flange Company manufactures a variety of special flanges for numerous customers. Annual capacity-related (manufacturing...

Answered: 1 week ago

Question

★★★★★
Page No. Date (6) On 30 september 2014, Razor's closing inventory was counted and valved at its cast of Tas I million inventory which had cost demaged Some item T2s 210,000 Gad been in a flood Con is...

Answered: 1 week ago

Question

★★★★★
12 SC 301 student is comparing between two stocks to invest in: Stock A and Stock B. owing are the stock returns (in dollars) in the last 10 months (sample). Monthly Returns Stock A Stock B 585 960...

Answered: 1 week ago

Previous Question Next Question