You administer a Microsoft SQL Server 2008 database named AdventureWork that contains a table named Production.Product. The table has the following definition: You want to add a new product named…

You administer a Microsoft SQL Server 2008 database named AdventureWork that contains a table named Production.Product. The table has the following definition:

You want to add a new product named Widget and a list price of 10.50U.S. dollars to the product table. You need to add a record for the product information. You also need to set the DateCreated field to the current date and the UserCreated field to your Windows login identification name. Which Transact-SQL statement should you use?