SQL Server - 随笔分类(第2页) - sekihin

【SQLSERVER】动态游标的实现

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> CREATE TABLE #tabTmp(id int) INSERT #tabTmp EXECUTE('SELECT id FROM '+@TableName)... 阅读全文

posted @ 2007-05-11 12:44 sekihin 阅读(3201) 评论(1) 推荐(1) 编辑

【SQLSERVER】存儲過程的寫法格式規格

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->******************************************************** author：Susan*** date:2005/08/05*** expliation... 阅读全文

posted @ 2007-05-11 11:56 sekihin 阅读(3906) 评论(1) 推荐(0) 编辑

【SQLSERVER】拷贝表数据

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->insert into dest-tablename(a, b, c) select d,e,f from source-tablename; 还可以这样 Code hig... 阅读全文

posted @ 2007-05-10 16:55 sekihin 阅读(471) 评论(0) 推荐(0) 编辑

【SQLSERVER】复制表结构

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->create table dest-tablename as select * from source-tablename where 1=2; Code highlighting produced by... 阅读全文

posted @ 2007-05-10 16:00 sekihin 阅读(1362) 评论(0) 推荐(0) 编辑

【SQLSERVER】 "in"的替换方法

摘要：期望效果： Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select * From Empoylee Where(Address1,Address2) in(Select Address1,Address2From EmpoyleeAdresses... 阅读全文

posted @ 2007-04-26 11:36 sekihin 阅读(2864) 评论(0) 推荐(0) 编辑

SQL语句Select Case和If else

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->(case FieldName When 0 then 1 when Null then 1 else FieldName end) as FieldName 阅读全文

posted @ 2007-04-20 16:21 sekihin 阅读(5849) 评论(1) 推荐(0) 编辑

表的字段修改（SQL语句）

摘要：1.添加字段 ALTER table customer add Gender char(1) ALTER table customer add（Gender char(1)） 2.修改字段名称 ALTER table customer change Address Addr char(50) ALTER table customer change Address（Addr char(50)） ... 阅读全文

posted @ 2007-04-10 17:22 sekihin 阅读(6165) 评论(2) 推荐(0) 编辑

SQL Server 取整函数FLOOR

摘要：FLOOR(expr) 返回小于等于expr的最大整数.FLOOR(1,1)返回报,FLOOR(-1,1)返回-2,FLOOR(1)返回1 阅读全文

posted @ 2007-04-03 14:51 sekihin 阅读(4356) 评论(0) 推荐(0) 编辑