MSSQL根据数据库字段类型判断存储过程参数类型

<script runat="template"> public string GetAllDbType(ColumnSchema column) { string re=""; switch (column.NativeType.ToString().ToLower()) { case "bigint":re="BigInt";break; case "binary":re="Binary";break; case "varbinary":re="VarBinary";break; case "char":re="Char";break; case "carchar":re="VarChar";break; case "nchar":re="NChar";break; case "nvarchar":re="NVarChar";break; case "varchar":re="VarChar";break; case "datetime":re="DateTime";break; case "smalldatetime":re="SmallDateTime";break; case "decimal":re="Decimal";break; case "numeric":re="Numeric";break; case "float":re="Float";break; case "real":re="Real";break; case "int":re="Int";break; case "smallint":re="SmallInt";break; case "tinyint":re="TinyInt";break; case "money":re="Money";break; case "smallmoney":re="SmallMoney";break; case "bit":re="Bit";break; case "timestamp":re="Timestamp";break; case "uniqueidentifier":re="UniqueIdentifier";break; case "text":re="Text";break; case "image":re="Image";break; case "ntext":re="NText";break; } if (column.Size > 0&&column.NativeType.ToString().ToLower()!="ntext"&&column.NativeType.ToString().ToLower()!="text") { re+=","+column.Size; } //re=column.NativeType.ToLower(); return re; } </script>

转载于:https://www.cnblogs.com/erik168/archive/2006/11/16/562238.html