목록2023/07/14 (1)
낭만 프로그래머
[MSSQL] DB 전체에 특정 문자열 찾기
1. 프로시저 생성 CREATE PROCEDURE spSearchOnAlldb @phrase varchar(8000), @OutFullRecords bit=0 AS declare @sql varchar(8000) declare @tbl varchar(128) declare @col varchar(128) declare @id_present bit declare @is_char_phrase bit declare @min_len int declare @loop_idx int declare @loop_chr char(1) set nocount on if IsNull(@phrase,'')='' begin raiserror('Phrase is absent',16,-1) return end select @loop_..
ETC
2023. 7. 14. 11:46