投递简历
SELECT cv_auto_id,user_id,CVTitle,CVStatus,
               UserGroup,UpdateDate,ViewCount,OpenCVLang,
               OpenLevel,ChangeStateDate,AcceptDirCV,CVMethod,CVStyle,
               XMLCNDate,XMLENDate,IsShowPic
        FROM cv_base
        WHERE user_id = @user_id and IsDel!=1 ORDER BY cv_auto_id

修改简历就这样？？？
BEGIN   
    --中文   
    IF(@ResumeType=0)   
    BEGIN   
        --中文简历   
        SELECT [pf].[gender] AS [gender],[pf].[birthday] AS [birthday],[pf].[ResidenceState] AS [ResidenceState]
        ,[pf].[ResidenceCity] AS [ResidenceCity],[pf].[OtherCityCN] AS [OtherCity],[pf].[HuKouState] AS [HuKouState]
        ,[pf].[HuKouCity] AS [HuKouCity],[pf].[IDType] AS [IDType],[pf].[IDNo] AS [IDNo],[pf].[Degree] AS [Degree]
        ,[pf].[polity] AS [polity],[pf].[homepage] AS [homepage],[pf].[contact_type1] AS [contact_type1]
        ,[pf].[contact_no1] AS [contact_no1],[pf].[contact_type2] AS [contact_type2],[pf].[contact_no2] AS [contact_no2]
        ,[pf].[contact_type3] AS [contact_type3],[pf].[contact_no3] AS [contact_no3],[pf].[postalcode] AS [postalcode]
        ,[pf].[NameCN],[pf].[NameEN],[pf].[NationalityCN] AS [Nationality],[pf].[AddrCN] AS [Addr],[pf].[wed_state] AS [WedState]
        ,[cb].[prc_loc] AS [Stu_HuKouLoc],[cb].[prc_other_locCN] AS [Stu_HukouOther],[cb].[appl_type] AS [Appl_type],[cb].[graduate_date] AS [Graduate_Date]   
        FROM [cv_profile] AS [pf] LEFT OUTER JOIN [cv_compus_basic] AS [cb]
        ON [pf].[user_id]=[cb].[user_id]    
        WHERE [pf].[user_id]=@user_id   
    END   
    ELSE   
    BEGIN   
        --英文简历   
        SELECT [pf].[gender] AS [gender],[pf].[birthday] AS [birthday],[pf].[ResidenceState] AS [ResidenceState]
        ,[pf].[ResidenceCity] AS [ResidenceCity],[pf].[OtherCityCN] AS [OtherCity],[pf].[HuKouState] AS [HuKouState]
        ,[pf].[HuKouCity] AS [HuKouCity],[pf].[IDType] AS [IDType],[pf].[IDNo] AS [IDNo],[pf].[Degree] AS [Degree]
        ,[pf].[polity] AS [polity],[pf].[homepage] AS [homepage],[pf].[contact_type1] AS [contact_type1]
        ,[pf].[contact_no1] AS [contact_no1],[pf].[contact_type2] AS [contact_type2],[pf].[contact_no2] AS [contact_no2]
        ,[pf].[contact_type3] AS [contact_type3],[pf].[contact_no3] AS [contact_no3],[pf].[postalcode] AS [postalcode]   
        ,[pf].[NameEN],[pf].[NameCN],[pf].[NationalityEN] AS [Nationality],[pf].[AddrEN] AS [Addr],[pf].[wed_state] AS [WedState]    
        ,[cb].[prc_loc] AS [Stu_HuKouLoc],[cb].[prc_other_locEN] AS [Stu_HukouOther],[cb].[appl_type] AS [Appl_type],[cb].[graduate_date] AS [Graduate_Date]    
        FROM [cv_profile] AS [pf] LEFT OUTER JOIN [cv_compus_basic] AS [cb]
        ON [pf].[user_id]=[cb].[user_id]    
        WHERE [pf].[user_id]=@user_id   
    END   
END

查询简历
SELECT cv_auto_id,user_id,CVTitle,CVStatus,
               UserGroup,UpdateDate,ViewCount,OpenCVLang,
               OpenLevel,ChangeStateDate,AcceptDirCV,CVMethod,CVStyle,
               XMLCNDate,XMLENDate,IsShowPic
        FROM cv_base
        WHERE user_id = @user_id and IsDel!=1 ORDER BY cv_auto_id

SELECT COUNT(agentisold.agent_id) as agentCount FROM agentisold left join job_agent on agentisold.agent_id=job_agent.auto_id where user_id=@userId

|UserId   |Int64|
|PageSize |Int16|
|PageIndex|Int16|
查询内容

DECLARE @SqlString  nvarchar(4000)
       
   SELECT count([auto_id]) as RecordCount FROM jobs_favorite WHERE [user_id]=@UserId AND [JobStatus]=0  AND IsDel = 0   
         
   IF @PageIndex=0    
   BEGIN   
    SET @SqlString='  
    SELECT TOP '+Cast(@PageSize as nvarchar)+' [auto_id],[JobPostDate],[SaveDate],[CompanyID],[CompanyName],[PositionId],[PositionName],[JobStatus],[CVStatus],[CvTitle],IsApply = CASE WHEN DATEDIFF(day, SaveDate, GETDATE()) <= 7 THEN 0 ELSE 1 END
    FROM jobs_favorite     JF 
    WHERE [user_id]=' + CONVERT( VARCHAR(50),@UserId ) + ' AND [JobStatus]=0   AND IsDel = 0  
    ORDER BY [SaveDate] desc'   
   END   
   ELSE   
   BEGIN           
    SET @SqlString='   
    SELECT TOP '+Cast(@PageSize as nvarchar)+' [auto_id],[JobPostDate],[SaveDate],[CompanyID],[CompanyName],[PositionId],[PositionName],[JobStatus],[CVStatus],[CvTitle] ,IsApply = CASE WHEN DATEDIFF(day, SaveDate, GETDATE()) <= 7 THEN 0 ELSE 1 END
    FROM jobs_favorite     JF 
    WHERE ([user_id]=' + CONVERT( VARCHAR(50),@UserId ) + ' AND [JobStatus]=0) AND  IsDel = 0 AND  [auto_id] NOT IN   
    (SELECT TOP '+Cast(@PageIndex*@PageSize as nvarchar)+' [auto_id] FROM jobs_favorite WHERE [user_id]=' + CONVERT( VARCHAR(50),@UserId ) + ' AND [JobStatus]=0  AND IsDel = 0 ORDER BY [SaveDate] desc)   
    ORDER BY [SaveDate] desc'   
             
   END    
         
   Execute(@SqlString)

没想到中国英才网的，企业数据表这样简单
|name         |type    |
------------------------
|@ApplyType   |Byte    |  
|@user_id     |Int64   |   
|@SaveDate    |DateTime|    
|@CompanyName |String  |    
|@PositionId  |Decimal |      
|@PositionName|String  |      
|@JobPostDate |DateTime|    
|@ExpectState |String  | 
|@JobStatus   |Byte    |    
|@CVTitle     |String  |       
|@CVStatus    |Byte    |    
|@CompanyID   |Int64   |         
|@auto_id     |Int32   |