随笔分类 - sqlserver
摘要：/*查询执行SQL升级前后，存储过程的参数数量变化*/ --升级前 select a.id,b.name, count(1) as c_count into TT99812 from syscolumns a join (select id,name from sysobjects where OB
阅读全文
摘要：字符串转日期 SELECT CONVERT(datetime,'19490224') --： 1949-02-24 00:00:00.000 SELECT CONVERT(datetime,'1949/02/24') -- ： 1949-02-24 00:00:00.000 SELECT CONVE
阅读全文
摘要：select job_id,step_name,message, cast( ( cast( LEFT ( run_date, 4 ) AS VARCHAR ) + '-' + SUBSTRING( cast( run_date AS VARCHAR ), 5, 2 ) + '-' + cast(
阅读全文
摘要：用户的输入经常用到拼音码选择器 --调用方法 select dbo.wsh_GetPY('汉字') ALTER FUNCTION [dbo].[wsh_GetPY] ( @str NVARCHAR(4000) ) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @WO
阅读全文
摘要：/* test110 '2023-04-26','2023-04-26','全部','901100569,901100570,901100571,901100572,901100573'; */ ALTER PROCEDURE [dbo].[test110] @StartDate datetime,
阅读全文
摘要：--创建链接服务器 exec sp_addlinkedserver 'ServerName', ' ', 'SQLOLEDB ', 'IPADDRESS' exec sp_addlinkedsrvlogin 'ServerName', 'false ',null, 'username', 'pass
阅读全文
摘要：package main import ( "database/sql" "fmt" "strconv" "strings" _ "github.com/denisenkom/go-mssqldb" "github.com/xuri/excelize/v2" ) const ( server = "
阅读全文
摘要：--调用方法 select dbo.wsh_sfzjy ('身份证号') ALTER FUNCTION [dbo].[wsh_sfzjy] ( @sfz varchar(20) ) RETURNS varchar(100) AS BEGIN DECLARE @PY varchar(100) DECL
阅读全文
摘要：CREATE FUNCTION DBO.GET_xxx(@S VARCHAR(MAX)) RETURNS VARCHAR(MAX)AS BEGIN DECLARE @SQL VARCHAR(MAX)SET @SQL='' DECLARE @len int set @len=LEN(@S) set @
阅读全文
