随笔分类 - SQL Server

摘要：SELECT SPID = er.session_id ,Status = ses.status ,[Login] = ses.login_name ,Host = ses.host_name ,BlkBy = er.blocking_session_id ,DBName = DB_Name(er. 阅读全文

posted @ 2023-03-13 15:13 zhangdapangzi 阅读(105) 评论(0) 推荐(0) 编辑

1.自定义拆分函数，查找任意位置字符

摘要：create function char_index(@string varchar(8000),@char varchar(64),@index int) --@string:待查找字符串，@index:查找位置 returns int as begin declare @i int,--当前找到阅读全文

posted @ 2023-03-13 14:45 zhangdapangzi 阅读(33) 评论(0) 推荐(0) 编辑