Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Here are the steps you need to go through to do the project: Given the business rules above, create a logical-level Crows Foot ERD using Visio. Show all original entities and any associative entities...

Q:

java language Concept Application & Algorithmic Part Question 1: (20 points) 1. Concept Application: A COVID 19 vaccination clinic allows the patients to receive the vaccine if they are 15 years old...

Q:

This is for my class called "Management Information Systems" : I'm very lost and don't know how to do pretty much any of this - thanks in advance for your help! In this part of the lab assignment,...

Q:

Note : The only favor I want from you to write the answers for the following questions including the SQL Queries? I am using the MS SQL Server. This is what I have. Read the below problem and upon...

Q:

PLEASE MAKE screenshot to prove that the program is working THE CODE MUST BE IN JAVA The Problem Suppose you decided to create a very basic Database Management System for KAU (KAUdbms). Your...

Q:

PLEASE WRITE THE PROJECT FULL CODE IN JAVA asked the same question before but did not get answer MUST MAKE A SCREENSHOT TO SHOW THAT PROJECT IS WORKING The Problem Suppose you decided to create a...

Q:

You will need to first create and populate a corresponding Oracle database by running the SQL commands provided in the accompanying Fact_Ora.txt posted on iCollege. Write a query that displays the...

Q:

Note : I've created the database and made the script to create the table and insert the records into the tables but I am unable to add it here. The only favor I want from you to write the SQL query...

Q:

Create an ER model for this business situation. Your model should include only entities and relationships, no attributes. You may use either Crow's Foot notation or UML notation. Whichever notation...

Q:

I would greatly appreciate any help on this, this is an assignment in MySQL. Thank you in advance! 1) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id,...

Q:

Why are GAAP and GAAS important to the IT auditor?

Q:

In what ways can coordinating the supply chain improve forecasting?

Q:

How do you decide if you should use a p chart or a c chart?

Q:

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Q:

d. What differences (if any) were there in the roles that members of the various groups played? Did one group play more sophisticated or more glamorous roles than others?

Q:

2. Explain the nominalist, relativist, and qualified relativist positions on language and perception.

Q:

e. In how many cases were people depicted in stereotypical rolesfor example, African Americans as athletes, or women as homemakers?