Izrj的博客

DECLARE @TableName sysname = 'Company';--表名 SELECT column_id dolumnId, ISNULL(t.desctr, '') AS desr, col.name colname, typ.name, col.is_nullable as nullableSign FROM sys.columns col LEFT JOIN ( SELECT ISNULL(CAST(properties.v

--获取对应的 ASCII 码 print ASCII('"') --字符串拼接 ASCII 码 print concat('w',char(34)) BEGIN TRAN DECLARE @TableName sysname = 'Company';--表名 DECLARE @Result VARCHAR(MAX) = 'public class ' + @TableName + ' {'; SELECT @Result = @Result + CHAR(13) +'[Column('.

带有逗号的SQL查询怎么弄 --Description: 字符处理 create function splitstr(@SourceSql varchar(8000),@StrSeprate varchar(5)) returns @temp table(F1 varchar(2000)) as begin declare @i int set @SourceSql=rtrim(ltrim(@SourceSql)) set @i=charindex(@StrSeprate,@SourceSql)