Can I use any column value as default value of another column in a create table statement?

0.00/5 (No votes)

See more:

How can I use any column value as default value of another column in a create table statement??

E.g.

create table test
(roll [int] not null,
srno [int] not null default roll,
name (varchar](50))

Posted 9-Apr-15 11:27am

RTK The Limited Edition

Add a Solution

Comments

Tomas Takac 9-Apr-15 17:52pm

You cannot do this, at least not in SQL Server. The default value must be a constant (literal) or system function call like GetDate(). Why do you need this really?

barneyman 9-Apr-15 21:16pm

as Tomas says, no - you could do what you want in a trigger

Member 11312264 10-Apr-15 3:48am

use trigger when insert a new row..

first insert value in roll.
then using trigger update the value of srno

John C Rayan 10-Apr-15 15:20pm

It is not possible.

Member 11039257 8-May-15 7:22am

It was not possible

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	25
Dave Kreskowiak	10
sahabiswarup	5
El_Codero	5
Richard Deeming	5

Pete O'Hanlon	1,740
OriginalGriff	1,307
Richard Deeming	550
Dave Kreskowiak	415
Richard MacCutchan	355