Login with  Log in with facebook
Hiring Manager? SIGN UP HERE
0

How can add Compute column in create table?

Govind Agarwal
09/22/2011 at 20:23
1 Answer
1
0

You can select a product of both column, but even if you need it while creating table you can try this in sql server:

CREATE TABLE Product(
	quantity integer,
	price integer,
	totalprice AS Cast(quantity*price AS INTEGER)
)

it only increases visibility, we dont need to do so in most cases.
Sudhir Jangir
09/23/2011 at 00:41

If you want to post any answer to this forum then you need to log in.
Schedule a Demo

Schedule a Demo with us

Name *
Email *
Phone *
Company *
Details