摘要：DECLARE @filed VARCHAR(50) DECLARE @sqlstring NVARCHAR(4000) DECLARE @productNo VARCHAR(30)= 'SS24SU5K04' DECLARE @color VARCHAR(50) = '64' DECLARE @size VARCHAR(50)= '35' DECLARE @sqlSelectString NVARCHAR(1000)DECLARE @realNumbe INT BEGIN SET @filed = ( SELECT CONVERT(VARCHA 阅读全文

摘要：SET @filed = ( SELECT CONVERT(VARCHAR(50), [Field]) FROM [shop].[dbo].[tbl_stockid] WHERE stockid = 2 ) --SET @number= CONVERT(VARCHAR(50), 100) SET @number= 200 SET @productNo=''''+@productNo+'''' SET @pingjie=''+@filed+''+'='+''+@numb 阅读全文

摘要：DECLARE @lastprice_new VARCHAR(50) DECLARE @part_var VARCHAR(50) DECLARE @part_var2 VARCHAR(50) SET @lastprice_new='1525852252252.0' --判断是否有小数点，大于0表示有小数点，等于0则表示没有小数点 PRINT charindex('.',@lastprice_new) --输入为 14 BEGIN SELECT @part_var2=Substring(@lastprice_new,0,CHARINDEX('.', 阅读全文