摘要：SQL SERVER:在SQL中分类合并数据行 --1. 创建表，添加测试数据CREATE TABLE test(code varchar(50), [values] varchar(10))INSERT test SELECT '001', 'aa'UNION ALL SELECT '001', 'bb'UNION ALL SELECT '002', 'aaa'UNION ALL SELECT '002', 'bbb'UNION ALL SELECT '00 阅读全文

摘要：Column constraint name maximum length is limited to 15 characters 在使用PD12时出现诸如以下错误： Reference constraint name maximum length is limited to 7 characters Key constraint name maximum length is limited to... 阅读全文

摘要：ORA-01034sqlplus /nologconnect / as sysdbastartup 阅读全文

摘要：create or replace PROCEDURE PROCSENDEMAIL(P_TXT VARCHAR2, P_SUB VARCHAR2, P_SENDOR VARCHAR2, ... 阅读全文

摘要：IF EXISTS (SELECT name FROM sysobjects WHERE name = 'gcht_jzgh_temp' AND type = 'U') DROP Table gcht_jzgh_temp --倒入excel文件 set @temp = '''MSDASQL.1''' set @temp1 = '''driver=Microsoft Excel ... 阅读全文

摘要：CREATE PROCEDURE sys_sendmail @From varchar(100) , @To varchar(100) , @Bcc varchar(100) , @Subject varchar(400)=" ", @Body nText =" " AS Declare @object int Declare @hr int EXEC @hr = s... 阅读全文