10 2017 档案
摘要:set @strSQL='select * from testtable AS P WHERE P.Type='+@PType+' and P.PName ='''+@PName+''' and P.PCode='+@PCode+' '; -- like ''%'+@PName+'%'' ' ;
阅读全文
摘要:@EmptyCount int output 参数 declare @strCount nvarchar(max); 声明变量 取值语句: 执行命令语句
阅读全文
摘要:PROCEDURE [dbo].[SP_GetList] ( @ParkUserId varchar(100), @arrearsStatus int, @lastID int=0, --最小ID @pageSize int=10, --每页显示记录数 @CityCode varchar(50) ) AS declare @DICT_Berth ...
阅读全文
摘要:测试表 测试参数 DECLARE @return_value int, @vmax_waterno bigint EXEC @return_value = [dbo].[get_waterno] @vtableName = N'testtable', @vcnt = 1, @vmax_waterno
阅读全文
摘要:Windows server 2008服务器部署: DotNetCore.1.0.0.RC2-WindowsHosting 或者DotNetCore.1.0.5_1.1.2-WindowsHosting.exe Redis-x64-3.2.100.msi Windows6.1-KB2533623-x
阅读全文
摘要:jdbc:oracle:thin:@(DESCRIPTION=(failover=on)(enable=broken)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.110.120.10)(PORT=1521))(LOAD_BALANCE=yes))(C
阅读全文