34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @icount SMALLINT
DECLARE @manu NVARCHAR(20)
DECLARE @item SMALLINT
SELECT @icount=COUNT(*) FROM (
SELECT @manu=EMS_NO,@item=G_NO FROM dbo.PTS_IMG WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9') t
SELECT @manu,@item,@icount
DECLARE @icount SMALLINT
DECLARE @manu NVARCHAR(2000)
DECLARE @item SMALLINT
SET @manu=''
SET @item=0
SET @icount=0
SELECT @manu=@manu+','+EMS_NO,@item=@item+G_NO,@icount=@icount+1 FROM dbo.PTS_IMG WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9'
SELECT @manu,@item,@icount
SELECT
distinct
@icount=(select COUNT(*) FROM dbo.PTS_IMG where EMS_IMG_ID = T.EMS_IMG_ID)
@manu=EMS_NO,
@item=G_NO ,
FROM dbo.PTS_IMG T
WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9'
SELECT
@icount=(select COUNT(*) FROM dbo.PTS_IMG where EMS_IMG_ID = T.EMS_IMG_ID)
@manu=EMS_NO,
@item=G_NO ,
FROM dbo.PTS_IMG T
WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9'
DECLARE @icount SMALLINT
DECLARE @manu NVARCHAR(20)
DECLARE @item SMALLINT
SELECT @manu=EMS_NO,@item=G_NO FROM dbo.PTS_IMG WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9'
select @icount=count(*) from dbo.PTS_IMG WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9'
SELECT @manu,@item,@icount
DECLARE @icount SMALLINT
DECLARE @manu NVARCHAR(20)
DECLARE @item SMALLINT
SELECT @manu=EMS_NO,@item=G_NO,@icount=COUNT(*) FROM dbo.PTS_IMG WHERE EMS_IMG_ID='9a9162a2-c8f7-40b3-9e61-01760e3358b9'
SELECT @manu,@item,@icount