weixin_42206447的博客

ALTER Function [dbo].[FormatDateNew] (@Format nvarchar(60),@date datetime)  RETURNS varchar(60)  AS  BEGIN      if @Format='yyyy'            select @Format= year(@date)      if @Format='MMddyy'...

DECLARE @username varchar(20),@UserId varchar(100)DECLARE cursor_name CURSOR FOR --定义游标 SELECT TOP 10 UserId,UserName FROM UserInfo ORDER BY UserId DESCOPEN cursor_name --打开游标FETCH NEXT FR...