ilona

 avatar
user_3592770
plain_text
2 years ago
817 B
9
Indexable
With reference to database AdventureWorks2019 write some queries for following requests:
1.Show all records of table Person.Person;
2.Show records of table Person.Person that have FirstName equals to John;
With reference to database AdventureWorks2019:
1.Create a new table Person.Person_New with the following field:
PersonID as an integer and as a primary key
FirstName as a varchar
LastName as a varchar
EmailAddress as a varchar

2.Alter table Person.Person_New to add a new field TelephonNumber as a varchar
3.Create a new table Person.EmailAddress_New selecting fields BusinessEntityID and EmailAddress from Person.EmailAddress for BusinessEntityID <= 104.
Rename column BusinessEntityID in new table Person.EmailAddress_New to PersonID5.

Add primary key to field PersonID for the table Person.EmailAddress_New
Editor is loading...