数据库
c_PeterChen2001
I am coding, I am happy~
展开
-
函数与存储过程的区别
<br />存储过程是预编译的,执行效率比函数高。<br />存储过程可以不返回任何值,也可以返回多个输出变量,但函数有且必须返回一个值。<br />存储过程必须单独执行,而函数可以嵌入表达式中,使用更灵活。<br />存储过程主要是用于对逻辑处理的应用或解决,函数主要是一种功能应用或解决。原创 2010-08-26 12:58:00 · 570 阅读 · 0 评论 -
Order a column conditional in SQL
<br />The below sample illustrates that we order Z descending if Zone is an even number, order Z ascending if Zone is an odd number.<br /> <br />declare @WhLocation table<br />(<br /> LocationId int identity(1, 1),<br /> Zone int,<br /> Z va原创 2011-04-23 13:54:00 · 597 阅读 · 0 评论 -
Add column to existing table with default value
<br /> <br />IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'WhSkuManagement' AND COLUMN_NAME = 'ReceivingToKivaAllowed')<br /> ALTER TABLE WhSkuManagement ADD ReceivingToKivaAllowed CHAR(1) NOT NULL DEFAULT('Y')原创 2011-04-23 13:57:00 · 795 阅读 · 0 评论