摘要：ALTER TABLE表名 ALTER COLUMN字段名 VARCHAR(长度)例如：将m_pissue表中的acce_man长度改为20ALTER TABLE m_pissue ALTER COLUMN acce_man VARCHAR(20) 阅读全文

摘要：sql语句Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--IFOBJECT_ID('dbo.gettableinfo')ISNOTNULLDROPPROCEDUREdbo.gettableinfoGOcreateprocdbo.gettableinfo... 阅读全文

摘要：SELECT * FROM table1 WHERE (dbo.fGetPy(字段)) like'字符%' COLLATE chinese_prc_ci_as 阅读全文

摘要：select isnull(max(cast(role as int )),0)as taxis from m_role where isnumeric(role)=1 阅读全文

摘要：#region 字符串过滤 /// <summary> /// 字符串过滤 /// </summary> /// <param name="str"></param> /// <returns></returns> public static string repstr(string str) { if (str != nul... 阅读全文

摘要：增加字段alter table docdsp add dspcode char(200)删除字段ALTER TABLE table_NAME DROP COLUMN column_NAME修改字段类型ALTER TABLE table_name ALTER COLUMN column_name new_data_type改名sp_rename更改当前数据库中用户创建对象（如表、列或用户定义数据类型... 阅读全文

摘要：//在查询中添加一个自动编号的列USE pubsSELECT IDENTITY(INT,1,1)AS id,job_desc,min_lvl INTO #temp FROM jobsSELECT * FROM #temp ORDER BY idDROP TABLE #temp 阅读全文