mysql 一列加一列,怎样给sql数据库的一个表格添加一列自动加一的列。设置 SQL 参数的值...

ALTER   TABLE   user2account   ADD   column_b   VARCHAR(20)   NULL;

ALTER   TABLE   user2account   modifycolumn_b   VARCHAR(50);

ALTER   TABLE   user2account   DROP  COLUMNcolumn_b ;

怎样给sql数据库的一个表格添加一列自动加一的列。谢谢

ALTER   table table_name

{

add column column_name int IDENTITY(1,1)

}

Dim MyCommand As New sqlCommand("ALTER TABLE gonggao ADD id int IDENTITY(1,1)", conn)就对了。

SQL存储过程

declare   @dd_dateDa   datetime,@dd_dateST   datetime

如果现在   @dd_dateDa   的值   是   2004-05-31   1:00:01

想   select   @dd_dateST=@dd_dateDa   但要   @dd_dateST   的值为   2004-05-31

中间该怎么作呢？

declare   @dd_dateDa   datetime,@dd_dateST   datetime

set   @dd_dateDa='2004-05-31   1:00:01'

set   @dd_dateST=convert(varchar(10),@dd_dateDa,120)

declare @Language varchar(100)

declare @ServiceID int

set @Language = 'jpn'

set @ServiceID = 32

Select  AssetID 'ID', Case @Language When 'Jpn' Then Case When (AssetNameJp <> Null Or LTrim(RTrim(AssetNameJp))   <> '') Then AssetNameJp Else AssetName End When 'Chi' Then Case When (AssetNameZh <> Null Or LTrim(RTrim(AssetNameZh))   <> '') Then AssetNameZh Else AssetName End   Else AssetName End 'Name',Case @Language When 'Jpn' Then Case When (AssetDescriptionJp <> Null Or LTrim(RTrim(AssetDescriptionJp)) <> '')   Then AssetDescriptionJp Else IsNull(AssetDescription,'') End When 'Chi' Then Case When (AssetDescriptionZh <> Null Or LTrim(RTrim(AssetDescriptionZh)) <> '')   Then AssetDescriptionZh Else IsNull(AssetDescription,'') End  Else IsNull(AssetDescription,'') End 'Summary', AssetType 'Type',  Case @Language When 'Jpn' Then Case When (IconPathJp <> Null Or LTrim(RTrim(IconPathJp)) <> '')   Then IconPathJp Else IconPath End When 'Chi' Then Case When (IconPathZh <> Null Or LTrim(RTrim(IconPathZh)) <> '')   Then IconPathZh Else IconPath End  Else IconPath End 'Image',OrderId   From Asset  Where AssetID IN (   Select ContentID From PackageContent Where PackageID   In (Select PackageID From   ServicePackage Where ServiceID   In (Select ServiceID From Service Where ServiceID =@ServiceID) And   PackageType='Package'      )) And AssetType = 'Live'      UNION ALL    Select  AssetID 'ID', Case @Language When 'Jpn' Then Case When (AssetNameJp <> Null Or LTrim(RTrim(AssetNameJp))   <> '') Then AssetNameJp Else AssetName End When 'Chi' Then Case When (AssetNameZh <> Null Or LTrim(RTrim(AssetNameZh))   <> '') Then AssetNameZh Else AssetName End Else AssetName End 'Name',  Case @Language When 'Jpn' Then Case When (AssetDescriptionJp <> Null Or LTrim(RTrim(AssetDescriptionJp)) <> '')   Then AssetDescriptionJp Else IsNull(AssetDescription,'') End  When 'Chi' Then Case When (AssetDescriptionZh <> Null Or LTrim(RTrim(AssetDescriptionZh)) <> '')   Then AssetDescriptionZh Else IsNull(AssetDescription,'') End Else IsNull(AssetDescription,'') End 'Summary', AssetType 'Type',  Case @Language When 'Jpn' Then Case When (IconPathJp <> Null Or LTrim(RTrim(IconPathJp)) <> '')   Then IconPathJp Else IconPath End  When 'Chi' Then Case When (IconPathZh <> Null Or LTrim(RTrim(IconPathZh)) <> '')   Then IconPathZh Else IconPath End Else IconPath End 'Image' ,OrderId   From Asset  Where AssetID IN (Select PackageID From ServicePackage Where ServiceID   In (Select ServiceID   From Service Where ServiceID = @ServiceID) And PackageType='Asset' )  And AssetType = 'Live'      UNION ALL      Select PackageID 'ID', Case @Language When 'Jpn' Then Case When (PackageNameJp <> Null Or LTrim(RTrim(PackageNameJp))   <> '') Then PackageNameJp Else PackageName End When 'Chi' Then Case When (PackageNameZh <> Null Or LTrim(RTrim(PackageNameZh))   <> '') Then PackageNameZh Else PackageName End Else PackageName End 'Name',  Case @Language When 'Jpn' Then Case When (PackageDescriptionJp <> Null Or LTrim(RTrim(PackageDescriptionJp)) <> '')   Then PackageDescriptionJp Else IsNull(PackageDescription,'') End When 'Chi' Then Case When (PackageDescriptionZh <> Null Or LTrim(RTrim(PackageDescriptionZh)) <> '')   Then PackageDescriptionZh Else IsNull(PackageDescription,'') End Else IsNull(PackageDescription,'') End 'Summary', PackageType 'Type',  Case @Language When 'Jpn' Then Case When (IconPathJp <> Null Or LTrim(RTrim(IconPathJp)) <> '')   Then IconPathJp Else IconPath End  When 'Chi' Then Case When (IconPathZh <> Null Or LTrim(RTrim(IconPathZh)) <> '')   Then IconPathZh Else IconPath End Else IconPath End 'Image',OrderID  From Package   Where PackageID In (Select distinct PackageID From ServicePackage Where   PackageType='Package' and ServiceID    In (Select ServiceID From Service Where ServiceID =@ServiceID  ))  And PackageType = 'SVOD' order by OrderID