![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MSSQL
johnsonvily
这个作者很懒,什么都没留下…
展开
-
MSSQL游标的使用
CREATE FUNCTION getPurchaser(@porid DECIMAL(20,0)) returns varchar(100) as begin declare @str varchar(100) declare @temp varchar(20) declare cur cursor for select distinct purchaser from re_purchaser where porid = @porid set @str = '' set原创 2010-12-28 15:14:00 · 440 阅读 · 0 评论 -
Oracle和MSSQL中循环的使用
1、oracle CREATE OR REPLACE FUNCTION SETSTATE(OLDVALUE VARCHAR2, POS NUMBER, SVALUE VARCHAR2) RETURN VARCHAR2 IS RETURN_VALUE VARCHAR2 (20); LEN NUMBER(8); I NUMBER(8); TEMP_VALUE VARCHAR2(1); BEGIN原创 2011-12-28 10:19:21 · 1082 阅读 · 0 评论