SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOALTER proc sp_nrc_pattern_body /*this procedure is for the report ID:NRC002 Other procedure sp_uploadpicwithpath: upload the pictures to database */ ASdeclare @fname_in varchar(1000) ,@m_tbname varchar(50) --the name of the temporary table ,@sql varchar