Defalut value of a bit field

Microsoft SQL Server

User Name:

Password:

Remember me

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

January 20th, 2003, 03:20 PM

cdcom81

Junior Member

Join Date: Jan 2003

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

Defalut value of a bit field

I was wondering if it is possible to change the default value of a bit field from 0 to 1. I can save the record with a 1, but I'd like the 1 to be there automatically. IDEAS?

January 20th, 2003, 05:01 PM

numbernine

Up To His Eyes In Ads

Join Date: Oct 2002

Location: Chicago

Posts: 160

Time spent in forums: 1 m 25 sec
Reputation Power: 6

In SQL Server Enterprise Manager, right click on the table and choose "Design Table," click into your bit field. In the little index card-type thing in the lower half of the screen, one of the choices is default value.

Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Defalut value of a bit field

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump