摘要:
ALTER procedure [dbo].[Sp_QueryFeeInfo]@feedict varchar(100),@idnum varchar(20)asbeginSET NOCOUNT ON;declare @sql nvarchar(4000)declare @ParameterDefinition nvarchar(4000);select @ParameterDefinition='@nameParameter varchar(100),@idnumParameter varchar(20)';select @sql=N'select * from ch 阅读全文
摘要:
SQL语句中的N'xxxx'是什么意思我们在一些sql存储过程,触发器等中经常会见到类似 N'xxxx' 是什么意思?例如:if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_getProByIdAndName]') and OBJECTPROPERTY(id,N'IsProcedure') = 1)drop procedure [dbo].[sp_getProByIdAndName]REPLACE(@pstrin,N'' 阅读全文