mbt clearance select * from people | ugg sydney-australian ugg ...
增**段,juicy couture outletalter table docdsp add <a href="http://www.mbt-shoes-sale.com/mbt-chapa-c-474.html"><strong>mbt chapa shoes</strong></a> dspcode char(200)*除*段ALTER TABLE table_NAME DROP COLUMN column_NAME修改*段类型ALTER TABLE table_name ALTER COLUMN column_name new_data_type改名sp_rename更改当前数据库 *用户创建对象（如表、列或用户定义 数据类型）的名称。 *法sp_rename [ @objname = ] ‘object_name’ , [ @newname = ] ‘new_name’ [ ,mbt clearance, [ @objtype = ] ‘object_type’ ] –假设要处理的表名为: tb–判*要添*列的表*是否有主键if <a href="http://www.mbt-shoes-sale.com/mbt-changa-c-477.html"><strong>cheap mbt changa shoes</strong></a> exists(select 1 from sysobjects where parent_obj=object_id(‘tb’) and xtype=’PK’)begin <a href="http://www.mbt-shoes-sale.com/mbt-changa-c-477.html"><strong>mbt changa black</strong></a> print ‘表*已经有主键,列只能做为普通列添 *’ –添*int类型的列,默认值为0 alter table tb add 列名 int default 0 endelsebegin print ‘表**主键,添*主键列’ –添*int类型的列,默认值为0 alter table tb add 列名 int primary key default 0 end/************************************************** ************************************/ 判*table1*是否*在name*段if exists(select <a href="http://gellarfan.org/##############/displayimage.php?album=random&cat=0&pos=-7048"><strong>MBT Kaya brown shoes create natural balanced walking posture ...</strong></a> * from syscolumns where id=object_id(‘table1′) and name=’name’) beginselect * from people;end Tags: juicy couture, mbt clearance
|
