SQL SERCER ±í×Ö¶ÎÐÞ¸Ä ×ܽá
ÕâÁ½ÌìÑо¿ÁËSQL SERVERµÄ×Ö¶ÎÐÞ¸Ä.ÓÐһЩÐĵÃ,д³öÀ´ÎªÈÕºó²Î¿¼:
1,ɾ³ý×Ö¶Î: ALTER TABLE [tablename] DROP COLUMN [fieldname]
ɾ³ýµÄʱºò¸Ã×ֶαØÐëûÓб»ÈκÎÍâ¼üÒýÓÃ,ûÓÐÈκÎÔ¼Êø.
2,ɾ³ýÔ¼Êø: ALTER TABLE [tablename] DROP CONSTRAINT constraint_name
ɾ³ýÔ¼ÊøÊÇÔ¼ÊøÃû²»¿É¼Óµ¥ÒýºÅ.
3,Ôö¼ÓĬÈÏÖµÔ¼Êø: ALTER TABLE [tablename] ADD CONSTRAINT constraint_name DEFAULT 'default_value' FOR [fieldname]
ÓÃFOR¹Ø¼ü×ÖÖ¸¶¨ÎªÄǸö×Ö¶ÎÔö¼ÓĬÈÏÖµÔ¼Êø.
4,ÐÞ¸Ä×Ö¶Î: ALTER TABLE [tablename] ALTER COLUMN [fieldname] new_datatype isnull
Òª¸ü¸ÄµÄÁÐµÄ new_data_type Ó¦·ûºÏÏÂÁÐ×¼Ôò£º
A,ÔÀ´µÄÊý¾ÝÀàÐͱØÐë¿ÉÒÔÒþʽת»»ÎªÐÂÊý¾ÝÀàÐÍ¡£(·¢ÏÖ,Èç¹ûÔÀ´µÄÊý¾ÝÀàÐÍÊÇtextµÄ¾ÍÔÙÒ²²»ÄÜÐÞ¸ÄÊý¾ÝÀàÐÍÁË)
B,new_data_type ÀàÐͲ»ÄÜΪ timestamp¡£
C,¶Ô ALTER COLUMN£¬ANSI ¿ÕĬÈÏֵʼÖÕ´ò¿ª£»Èç¹ûûÓÐÖ¸¶¨£¬Áн«¿ÉΪ¿Õ¡£
D,¶Ô ALTER COLUMN£¬ANSI Ìî³äʼÖÕ´ò¿ª¡£
E,Èç¹ûÒª¸ü¸ÄµÄÁÐÊDZêʶÁУ¬new_data_type ±ØÐëÊÇÖ§³Ö±êʶÊôÐÔµÄÊý¾ÝÀàÐÍ¡£
F,½«ºöÂÔSET ARITHABORTµÄµ±Ç°ÉèÖá£ALTER TABLEÓï¾äµÄÐÐΪÈçͬARITHABORTÑ¡ÏîΪONʱһÑù¡£
G,Ö»ÓÐÁÐÖв»°üº¬¿Õֵʱ£¬ALTER COLUMN ÖвſÉÖ¸¶¨ NOT NULL¡£
½«¿ÕÖµ¸üÐÂΪ·Ç¿ÕÖµ:UPDATE [tablename] SET [nullfield] = 'some_value' WHERE [nullfield] IS NULL
5£¬Ôö¼Ó´øĬÈÏÖµÔ¼ÊøµÄ×Ö¶Î:
ALTER TABLE [tablename] ADD [new_field_name] new_datatype isnull CONSTRAINT constraint_name DEFAULT 'default_value' WITH VALUES
A, 'WITH VALUES' ¿ÉÒÔ²»Ð´,дµÄ»°,¾ÍÓøÃDEFAULTÔ¼ÊøÖ¸¶¨µÄÖµ,Ìî³äÔÚËùÓÐÒÑÓмǼмӵÄ×Ö¶ÎÉÏ,·ñÔòʹÓÃ'NULL'Ìî³äÔÚËùÓÐÒÑÓмǼмӵÄ×Ö¶ÎÉÏ.
B, Ìí¼Óµ½±íÖеÄÐÂÁÐҪôÔÊÐí¿ÕÖµ£¬ÒªÃ´±ØÐëÖ¸¶¨Ä¬ÈÏÖµ¡£
6,ʹÓÃsp_rename´æ´¢¹ý³ÌÐÞ¸Ä×Ö¶ÎÃû³Æ:sp_rename @objname = '[tablename].[fieldname]' , @newname = 'newfieldname' ,@objtype = 'COLUMN'
²ÎÊýobjname±ØÐëÖ¸¶¨Îª[±íÃû].[ÓûÐ޸ĵÄ×Ö¶ÎÃû]ÕâÑùµÄÐÎʽ,ÒªÐÞ¸Ä×Ö¶ÎÃûµÄ»°objtype¾Í±ØÐëÖ¸¶¨Îª'COLUMN'.ÖµµÃ×¢ÒâµÄÊÇnewnameÕâ¸ö²ÎÊýÖеÄ×Ö¶ÎÃû²»¿ÉÒÔʹÓÃ"[]",µ«¿ÉÒÔÔÚÆäÖÐʹÓÿոñ,²»¹ýÔÚÒÔºóʹÓÃÕâ¸ö×Ö¶ÎÃûʱҪΪÆä¼ÓÉÏ"[]",Èç¹û²»Ð¡ÐÄʹÓÃ"[]"µÄ»°×Ö¶ÎÃû³Æ»á±»Ð޸ijÉ[[newfieldname]]]ÕâÑùµÄ¹ÖÑù×ÓµÄ.Õâ¸öÒ»¶¨Òª¼ÇסÁË!
Ïà¹ØÎĵµ£º
C#ÖÐÒÔwindowsÑéÖ¤·½Ê½Á¬½ÓSQL serverÊý¾Ý¿âµÄÀà¡£ºÜ¶àÈËÁ¬½ÓÊý¾Ý¿âʱ¿ÉÄܶ¼ÊÇÍøÉϲéÁËÈ»ºó¾ÍÁ¬ÁË£¬¶ÔÓÚ²ÎÊýµÄº¬Òåµ¹ÊÇûÔõôÔÚÒ⣬żҲÊÇ£¨ºÇºÇ£©£¬µ±È»ÎÒÃǶ¼×¢Öؽá¹ûÂ¿ÉÊÇÕâÑù²»ÈÝÒ×¼ÇÒäÿ´ÎÁ¬µÄʱºò¶¼ÊÇÉÏÍø²é£¬¸Ð¾õͦ²»·½±ã£¬ËùÒÔË÷ÐÔ²éÁËһϡ£~~~Integrated Security=True£»±íʾÔÚÁ¬½ÓÊý¾Ý¿â½øÐÐÉí·ÝÑé֤ʱÓÃwind ......
Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½Ñ§Linq to sql£¨Áù£©£ºÌ½¾¿ÌØÐÔ
Ò»²½Ò»²½Ñ§Linq to sql£¨Æߣ©£º²¢·¢ÓëÊÂÎñ ......
ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪ
DDLÓï¾ä£¨Êý¾Ý¶¨ÒåÓïÑÔ£©£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´Ðж¼ÐèÒª½øÐÐÓ²½âÎö¡£»¹ÓÐÒ»Àà¾ÍÊÇDMLÓï¾ä£¨Êý¾Ý²Ù×ÝÓïÑÔ£©£¬ËûÃÇ»á¸ù¾ ......
1 ·ÀÖ¹sql×¢Èëʽ¹¥»÷(¿ÉÓÃÓÚUI²ã¿ØÖÆ£© #region ·ÀÖ¹sql×¢Èëʽ¹¥»÷(¿ÉÓÃÓÚUI²ã¿ØÖÆ£©
2
3 /**/ ///
4 /// ÅжÏ×Ö·û´®ÖÐÊÇ·ñÓÐSQL¹¥»÷´úÂë
5 ///
6 /// ´«ÈëÓû§Ìá½»Êý¾Ý
7 /// ......
ÎÊÌâÒ»
ÓÐÕâÑùµÄÒ»¸öÎÊÌ⣬Êý¾Ý¿âÖÐÓÐÁ½¸ö±í£¬·Ö±ðÊÇGuest,Hotel£¬¼´ÂÿÍÐÅÏ¢±íºÍÂùÝÐÅÏ¢±í£¬Guest±íÖÐÓÐÒ»¸öÂÿͱàÂëµÄ×ֶΣ¬Õâ¸ö×ֶεÄÓÐ20룬ËüµÄÇ°10λ´ú±íÕâ¸öÂÿÍËùסµÄÂùݣ¬ÏÖÔÚµÄÎÊÌâÊÇÒª¸ù¾ÝGuest±íÖеÄÂÿͱàÂë×Ö¶ÎÐÅÏ¢²éµ½ËûËùסµÄÂùݵÄÃû³ÆºÍÂùݵØÖ·£¡
ÎÊÌâ½â¾ö:
SQL SERVERµÄSQLÓï¾ä£ºselect ......