ilona
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...