171k views
2 votes
Write an INSERT statement with an OUTPUT clause to add a new row to the Categories table in MyGuitarShop database. The OUTPUT clause must display the new inserted values of both columns of Categories. The CategoryName of this new row is 'Brass'. Your INSERT statement should not insert a value into the CategoryID column because this column is an IDENTITY column, meaning its values are generated automatically by the server.Hint: see lecture video about how to add an OUTPUT clause to meet theabove requirement.

User Kgnkbyl
by
3.3k points

1 Answer

3 votes

Answer:

See attached picture.

Step-by-step explanation:

See attached picture.

Write an INSERT statement with an OUTPUT clause to add a new row to the Categories-example-1
User Sharana
by
4.2k points