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

MB Posts (1)

Search pabbate:

Personal Account . . .
Pablo Abbate
-- 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.

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

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

DBA, Databases, & Data
Sales Website: Or visit our legacy sales site:

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