动态游标

 

DECLARE @WHERE VARCHAR(500)
SELECT @WHERE='( ClinicAndNurse=1 Or  ClinicAndNurse=2 )'

DECLARE @SQL NVARCHAR(2000)
SELECT @SQL=N'DECLARE ABC CURSOR FOR '
SELECT @SQL=@SQL+N'SELECT ID,CHARGETYPE,PAYTYPE,(SELECT TypeName FROM TBCHARGETYPE WHERE ID=PAYTYPE) AS PAYNAME,CLINICANDNURSE,MONEY,OPERATOR,CREATETIME FROM TBPRC'

IF((@WHERE<>'') OR (@WHERE <>NULL))
 SELECT @SQL=@SQL+N' WHERE '+@WHERE

SELECT @SQL=@SQL+N' ORDER BY CREATETIME DESC'

EXEC(@SQL)

DECLARE @ID INT
DECLARE @CHARGETYPE INT
DECLARE @PAYTYPE INT
DECLARE @PAYNAME VARCHAR(20)
DECLARE @CLINICANDNURSE INT
DECLARE @MONEY INT
DECLARE @OPERATOR VARCHAR(20)
DECLARE @CREATETIME DATETIME

OPEN ABC
FETCH NEXT FROM ABC INTO @ID,@CHARGETYPE,@PAYTYPE,@PAYNAME,@CLINICANDNURSE,@MONEY,@OPERATOR,@CREATETIME
WHILE @@FETCH_STATUS=0
BEGIN

 FETCH NEXT FROM ABC INTO @ID,@CHARGETYPE,@PAYTYPE,@PAYNAME,@CLINICANDNURSE,@MONEY,@OPERATOR,@CREATETIME
END

CLOSE ABC
DEALLOCATE ABC