plpgsql 循环插脚本
注意获取execute的结果保存到变量，使用into，execute ... into variable、select ... into variable拼接字符串，使用||，或者使用函数concat('A', 'B', ...)PERFORM vs EXECUTE :PERFORM 调用无返回值的函数EXECUTE 执行动态生成的语名pg_sleep(secends)， PERFORM p...
SqlServer实现数组遍历
思路把数据保存为带分隔符长字符串，如"aaa,bbb,ccc,ddd,..."，利用字符串方法遍历每个元素知识点查询结果拼接成字符串查询字符数组元素个数获取字符数组指定元素sql try...catch事务-- 删除fun
If Exists (Select * from sys.objects where name ='Get_StrArrayLength' and type =N'FN...
FreeSql中With...As(...)的一种实现
Sql:WITH tmp AS ( SELECT cardnum, MAX ( receivetime ) AS receivetime FROM uwb20230626 GROUP BY cardnum )
SELECT b.*, A.farfromroadway, A.backroadwaydirection
FROM
worksite A
INNER JOIN uwb202...
PL/pgSQL简单上手
前言PL/pgSQL是Postgres的sql实现，借鉴了PL/SQL，后者是Oracle的sql实现语法[ <<label>> ]
[ DECLARE
declarations ]
BEGIN
statements
END [ label ];例：CREATE FUNCTION somefunc() RETURNS integer AS $$
<...