Loading

SQL

Muralitharan A

14y1.5k

Hi Friends,

Am struggling with one concept give me some idea..

I want to declare multiple column names of same datatypes by specifing the datatype only once in the query..

Eg : create table [tablename]( col1 varchar(100),col2 varchar(100) )

as

create table [tablename]( col1,col2 varchar(100) )

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi Murali,

I do not think you have the option to do this in sql server.

You can create your own data type in sql server.