SQL 返回刚刚插入的ID及存储过程返回table

SQL 返回刚刚插入的ID 及 存储过程返回table

1、SQL 返回刚刚插入的ID：
INSERT INTO rrl_pics ([pic_data], [filetype], [thekey], [lenght], [bid]) OUTPUT inserted.id

2、存储过程返回table：

Create PROCEDURE [dbo].[sp_stat_toal_game_play_user_list]
@stat_date AS varchar(50)
AS
BEGIN
SELECT
*
FROM
user
END


调用：exec dbo.sp_stat_toal_game_play_user_list ‘2018/05/05’

注：存储过程名和参数之间空格分隔，参数之间,号隔开