sql - Modify table: How to change 'Allow Nulls' attribute from not null to allow null -

-

how change 1 attribute in table using t-sql allow nulls (not null --> null)? alter table maybe?

-- replace nvarchar(42) actual type of column alter table your_table alter column your_column nvarchar(42) null

Comments

Post a Comment

Popular posts from this blog

php - How can I merge Nodes & Webform Submissions into instances of one general Content Type in Drupal 6? -

-
i built site using drupal 6 allows users submit information site owner in 3 different ways. are: webform a : quick contact - collects name, email, phone , message. webform b : free pdf book email webform - collects info similar above, , sends user email pdf attachment book written site owner. node create : case evaluation - form node creation page using multi-step module, cck , lot of conditional fields. anonymous users can fill out form , node data emailed site owner based on rule created. all 3 of these forms work in terms of doing supposed site. webform submissions accessed webform node owner, , set table view manage node submissions. even though forms gathering different data, @ end of day, important data personal contact information (each 1 collects name, email and/or phone), , each form submission (from of forms) considered lead owner , followed on. i centralize these various form submissions (2 webforms + 1 node) 1 content type (leads) managed 1 page, rather t...
Read more

c++ - Compiling static TagLib 1.6.3 libraries for Windows -

-
i having super hard time compiling , using taglib 1.6.3 in qt project. i've tried can think of. taglib claims supported through cmake i'm not having luck. furthermore, i'm confused kinds of files need qt libs! i've built *.a files, *.lib, , *.dll. understand far... believe since i'm working in windows *.lib want. no matter do, end "undefined references" taglib functions try use when try compile qt project. have tried mingw32, msys, visual studio 2008, , cross-compiling windows on linux. turning nothing. what makes less sense me if compile same taglib source qt on mac (g++ think?) works fine! somewhere in windows compilation procedures have going wrong. have been smacking face on desk 30 (on , off) hours trying figure out. since qt uses mingw must compile taglib same compiler? if compile *.lib's visual studio not compatible? are *.a libraries usable in windows? (assuming mingw) i'm still trying handle on c++ stuff, after reading coun...
Read more

geospatial - MongoDB Bound Queries: How do I convert mile to radian? -

-
i have collection of stores geospacial index on location propery. what trying given user's latitude, latitude , search radius (mi), want return list of stores within parameters. i saw following example on mongodb documentation ( http://www.mongodb.org/display/docs/geospatial+indexing ), looks distance in radians. center = [50, 50] radius = 10 db.places.find({"loc" : {"$within" : {"$center" : [center, radius]}}}) so, formula convert miles radians? solution awesome people @ mongodb-user helped me find answer. basically, looking way limit distance. per, updated documentation, there 3rd parameter $near query: can use $near maximum distance db.places.find( { loc : { $near : [50,50] , $maxdistance : 5 } } ).limit(20) the value $maxdistance in radians; so, had take distance in miles , divide 69. thank you! as docs say: all distances use radians. allows multiply radius of earth (about 6371 km or 3959 miles) distance in choice ...
Read more