Question: I NEED THEM IN SQL CODES IN MSSQL MANAGEMENT STUDIO Create a function that inserts 100 rows in the employee table. The values of the

I NEED THEM IN SQL CODES IN MSSQL MANAGEMENT STUDIO Create a function that inserts 100 rows in the employee table. The values of the emp_no column should be unique and between 1 and 100 . All values of the columns emp_Iname, emp_fname, and dept_no should be set to 'John', 'Smith', and ' d1', respectively. Modify the function from exercise 2 so that the values of the emp_no column should be generated randomly using the RAND function

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!

dept_no di emp_no 25348 10102 location Dallas emp_fname Matthew Ann dept_no d3 emp_lname Smith Jones d3 dl dept_name Research Accounting Marketing 18316 29346 Seattle d2 d2 d3 Dallas 2581 John James...

For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Project 2 50 points Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. Step 1: Design and...

S10_Chap7_RQ_WPC-Database Lab This assignment is from the Kroenke book Chap 7 Review Questions (RQ). Create a new folder, WPC-Database, in the Projects folder, found in the SQL Server Management...

This uses microsoft SQL management Studio I. OBJECTIVES At the end of this activity, the students will be able to: 1. Create, Alter, and Drop SQL VIEWs. 2. Understand the use of WITH SCHEMABINDING....

Please explain each step im having a hard time understanding where I am going wrong. \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\...

This case study assignment is based on (but not same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 7 and 8. Since there are important differences between the...

Assume that The Queen Anne Curiosity Shop designs a database with the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, Email) EMPLOYEE (EmployeeID,...

A 375-gallon tank is filled with water containing 167 g of bromine in the form of Br- ions. How many liters of Cl2 gas at 1.00 atm and 20C will be required to oxidize all the bromide to molecular...

Identify the effects both the direction and the dollar amount of these assumed transactions on the total stockholders equity of Athol Corporation. Each transaction is independent. a. Declaration of...

*34. Where are gains and losses related to cash flow hedges involving anticipated transactions reported?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Words and phrases can have connotative meanings not only in business communication but also in classroom communication. For each item in the following list, identify what a teacher might mean when he...

Global. Select a culture other than your own. Gather information on that cultures values, attitudes, biases, and viewpoints. As your instructor directs, interview a student or faculty member from...

Prepare a one- to two-minute oral presentation in which you explain the senders and receivers roles in the communication process. As your instructor directs, deliver your presentation to another...