IT SOLUTIONS
Your full service technology partner! 
Harinatha Reddy Gorla [Unspecified] -Collapse +Expand
-Collapse +Expand
ghreddy
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (1)

Search ghreddy:

Advanced
Personal Account . . .
Harinatha Reddy Gorl
 (Inactive)
Hyderabad , India



Real Name:  Harinatha Reddy Gorla [Unspecified]
Primary Role:  Coder
Joined: Oct 2001 (20 years ago)
Visits: 4
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

1 posts.
More...

Thread 2 of 2
Thread Starter or a Reply (but not last)  Group

Pablo Abbate
Retrieve Default Value
Does anoyone know how can I retrieve a value from a field default value?, Thanks in advance.
Posted to MB Topic: MS SQL « DBA Board
20 years ago

ghreddy
HI , you can use Syscomments and Syscolumns tables to get default value of specific column., Use following Query, , Select B.Name , A.Text From sysComments A INNER JOIN sysColumns B On A.ID = B.cDefault , Where B.ID = OBJECT_ID(''), , Regards, Harinatha Reddy G
20 years ago
Nothing New Since Your Last Visit
2551
Hits

DBA, Databases, & Data

Thread 1 of 2
Thread Starter or a Reply (but not last)  Group

Harinatha Reddy Gorl
Re: Retrieve Default Value
HI , you can use Syscomments and Syscolumns tables to get default value of specific column., Use following Query, , Select B.Name , A.Text From sysComments A INNER JOIN sysColumns B On A.ID = B.cDefault , Where B.ID = OBJECT_ID(''), , Regards, Harinatha Reddy G
Posted to MB Topic: MS SQL « DBA Board
20 years ago
Nothing New Since Your Last Visit
2
Hits

DBA, Databases, & Data
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]