IT SOLUTIONS
Your full service technology partner! 
Pablo Abbate -Collapse +Expand
-Collapse +Expand
pabbate
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (1)

Search pabbate:

Advanced
Personal Account . . .
Pablo Abbate
 (Inactive)
-- USA



Real Name:  Pablo Abbate
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 1 of 1
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
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


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