![]() ![]() The promotions table has five columns including promotion identification number, name, discount, start date and expired date. ![]() In this statement, we created a new table named promotions in the sales schema. Promotion_id INT PRIMARY KEY IDENTITY ( 1, 1), Let’s create a new table named promotions for the demonstration: CREATE TABLE sales.promotions ( Also, you must enclose the value list in parentheses. Each column in the column list must have a corresponding value in the value list. Third, you provide a list of values to be inserted in the VALUES clause.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |