随笔分类 - Sql Server
摘要：select ROW_NUMBER() over( order by sort_id asc) as rows,* into #tmp_tbfrom tb_district其中sort_id为您原表的排序列。tb_district为要操作的表。
阅读全文
摘要：Create table Tab([Col1] int,[Col2] nvarchar(1)) Insert Tabselect 1,N'a' union all select 1,N'b' union all select 1,N'c' union all select 2,N'd' union all select 2,N'e' union all select 3,N'f' Go create function F_Str(@Col1 int) returns nvarchar(100) as
阅读全文
摘要：exec sp_configure 'show advanced options',1 RECONFIGURE WITH OVERRIDE go exec sp_configure 'database mail xps',1 RECONFIGURE WITH OVERRIDE go --2.创建邮件帐户信息 EXEC msdb..sysmail_add_account_sp @ACCOUNT_NAME ='ETLErrorMailLog', -- 邮件帐户名称 @EMAIL_ADDRESS ='******@126.com' ,
阅读全文
