欧少的博客

语法：ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)select  row_number() over(partition by pdctno order by pdctno) as id2 ,* into #temp20 from engmail --where pdctno='02047829ga

SQL中，将周期转换为日期，取当周第一天的日期，格式：dbo.get_WeekToDate(Week,WeekFormat)CREATE Function [dbo].[get_WeekToDate](@week varchar(4),@wkformat varchar(4)) Returns dateAS BEGIN declare @year varchar(

CREATE FUNCTION [dbo].[int2Char](@id bigint)  RETURNS char(4)  AS  BEGIN;      DECLARE @char_return varchar(10) = '', @v_count int;      WHILE @id > 0           SELECT              @v_count = @id %...