求高手注释已存储过程

2012-10-12 08:22:58 139 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

机器人强化学习入门学习笔记如果你追求高精度动力学仿真、用于强化学习或机器人研究，MuJoCo 是一个非常优秀的选择。如果需要快速实验、使用真实机器人模型，PyBullet 或 Gazebo可能更合适；如果你追求大规模并行训练，Isaac Gym 或 BraX会更高效。legged gym底层是编辑isaacgym，基于gpu训练可以多环境并行训练，收敛到一个稳定行走的策略快。本视频MuJoCo基于cpu训练很慢。阅读详情

USE [UPhoneCloud_Data]
GO
/****** Object: StoredProcedure [dbo].[U_Sp_StoresLogSeelct] Script Date: 10/12/2012 19:37:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[U_Sp_StoresLogSeelct]
@UserId INT,
@StoresId INT,
@DateType INT,
@PageSize INT,
@PageIndex INT,
@Count INT OUTPUT,
@AppId INT
AS
DECLARE @PageLowerBound INT
DECLARE @PageUpperBound INT
SET @PageLowerBound=@PageSize * (@PageIndex-1)
SET @PageUpperBound=@PageLowerBound + @PageSize + 1
CREATE TABLE #TableStoresLog
(
IndexId int IDENTITY(1,1) NOT NULL,
StoresLogId int
)
DECLARE @SQL NVARCHAR(1000)
SET @SQL='SELECT StoresLogId FROM U_StoresLog U WHERE 1=1'
IF @UserId<>0
BEGIN
SET @SQL=@SQL + ' AND UserId ='+CAST(@UserId AS NVARCHAR(50))+''
END
IF @StoresId<>0
BEGIN
SET @SQL=@SQL + ' AND StoresId ='+CAST(@StoresId AS NVARCHAR(50))+''
END
IF @DateType<>0
BEGIN
IF @DateType=1
BEGIN
SET @SQL=@SQL + ' AND DATEDIFF(dd,LogAddtime,GETDATE())=0'
END
IF @DateType=2
BEGIN
SET @SQL=@SQL + ' AND DATEDIFF(mm,LogAddtime,GETDATE())=0'
END
IF @DateType=3
BEGIN
SET @SQL=@SQL + ' AND DATEDIFF(wk,LogAddtime,GETDATE())=0'
END
IF @DateType=4
BEGIN
SET @SQL=@SQL + ' AND DATEDIFF(yy,LogAddtime,GETDATE())=0'
END
END
IF @AppId<>0
BEGIN
SET @SQL=@SQL + ' AND ((AppId ='+CAST(@AppId AS NVARCHAR(50))+') OR (SELECT COUNT(StoresLogId) FROM U_StoresLog WHERE APPID='+CAST(@AppId AS NVARCHAR(50))+' AND LogLevel=U.StoresLogId )>0)'
END
SET @SQL=@SQL +' AND LogLevel=0 ORDER BY LogAddtime DESC'

INSERT INTO #TableStoresLog (StoresLogId) EXEC(@SQL)
SELECT U.* FROM U_StoresLog U , #TableStoresLog WHERE U.StoresLogId=#TableStoresLog.StoresLogId
AND #TableStoresLog.IndexId>@PageLowerBound AND #TableStoresLog.IndexId<@PageUpperBound
SELECT @Count=COUNT(StoresLogId) FROM #TableStoresLog
RETURN @Count

...全文