如何在varchar类型查询中使用像sql server一样 [英] how to use like in sql server in varchar type query

问题描述

hii all

i想在我的查询中使用like运算符..我得到错误..请给我正确的语法..



我的sp是：

hii all
i want to use like operator in my query.. i m getting error.. please give me correct syntax..

my sp is:

USE [SCJ]
GO
/****** Object:  StoredProcedure [dbo].[spGetCHILD_outof state]    Script Date: 04/17/2014 03:16:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<author,,name>
-- Create date: <create>
-- Description:	<description,,>
-- =============================================

-- [spGetFilteredSchl] '12','01','101'

ALTER PROCEDURE [dbo].[spGetCHILD_outof state]
(
	@DistrictID varchar(250),
	@BlockID varchar(250),	
	@VillageID varchar(250)
)
AS
BEGIN	
	
	SET NOCOUNT ON;	
		
		DECLARE
	@ChildTblName AS VARCHAR (125), 
   
     @vQuery1 AS VARCHAR (max); 
    
    SET @ChildTblName = '[' + @DistrictID + 'Child_D' + ']'
    	
	  CREATE TABLE #childcount
    (
        
        schname nvarchar(30),
        total_child varchar(30) 
    );
	 SET @vQuery1='select B.schname as schname,COUNT(A.cname) as total_child from ' + @ChildTblName + ' A, 
               SCHMAST B where A.cname like '%11111' and  B.DCODE='+ @DistrictID +' AND B.BCODE='+ @BlockID +'and B.VCODE='+ @VillageID +'' 
	
   --insert into #childcount
   exec(@vQuery1)
  select * from  #childcount
     
    drop table #childcount;
	
	
	
END

推荐答案

试试这个

try this

SET @vQuery1='select B.schname as schname,COUNT(A.cname) as total_child from ' + @ChildTblName + ' A, 
               SCHMAST B where A.cname like ''%11111%'' and  B.DCODE='+ @DistrictID +' AND B.BCODE='+ @BlockID +'and B.VCODE='+ @VillageID +''

这篇关于如何在varchar类型查询中使用像sql server一样的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！