Write an INSERT statement with an OUTPUT clause to add a new row to the Categories table in MyGuitarShop database. The OUTPUT cl
ause 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.
1 answer:
You might be interested in
Answer:
note:
find the attachment
