SQL语句判断

1、

      /// <summary>
        /// 判断是否存在某表的某个字段
        /// </summary>
        /// <param name="tableName">表名称</param>
        /// <param name="columnName">列名称</param>
        /// <returns>是否存在</returns>
        public static bool ColumnExists(string tableName, string columnName)
        {
            string sql = "select count(1) from syscolumns where [id]=object_id('" + tableName + "') and [name]='" + columnName + "'";
            object res = GetSingle(sql);
            if (res == null)
            {
                return false;
            }
            return Convert.ToInt32(res) > 0;
        }



//带参数的SQL
   /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int Delete(int id)
        {
            string sql = @"DELETE FROM ProjectProcedure WHERE ID=@ID";
            SqlParameter[] parameters = new SqlParameter[]{
new SqlParameter("@ID", SqlDbType.Int){ Value = id }
};
            return dbHelper.Execute(sql, parameters);
        }



创建表之前先判断数据库是否存在该表，如果存在就先删除再创建
if exists (select * from sysobjects where name = 'ContractCategory')
drop table ContractCategory 
create table ContractCategory 
(
 ID Int identity(1,1) primary key,--
 Name Varchar(50), --类别名称
)
go