Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help creating a table in sql with the data provided to store it. Please help me creating an sql command with the data

I need help creating a table in sql with the data provided to store it. Please help me creating an sql command with the data provided.

[customerCode] [numeric](18, 0) NOT NULL,

[customerName] [nvarchar](50) NULL,

[customerUName] [nvarchar](50) NULL,

[customerAmount] [decimal](18,4) NULL,

[salesDate] [datetime] NULL,

[ETL_Load_TS] [datetime]

**Default the "ETL_Load_TS" field to the current date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions

Question

=+ What competencies will be lost?

Answered: 1 week ago

Question

Provide examples of KPIs in Human Capital Management.

Answered: 1 week ago

Question

What are OLAP Cubes?

Answered: 1 week ago