sharepoint培训

采用远程访问，文件共享。

应该不行吧，至少我这样的菜鸟不知道。

CREATE TRIGGER [MyINSERT] ON [dbo].[AllUserData] FOR INSERTASDECLARE @tp_id int select @tp_id = tp_Id from insertedDECLARE @ygid int, -- 员工基本信息表ID@kcid int, -- 部门培训计划及培训记录信息表ID@ygname nvarchar(30), -- 姓名 nvarchar1@ygznbmid int, -- 员工职能部门ID int3@ygznbm nvarchar(100), -- 员工职能部门名称 nvarchar1@kclbid int, -- 课程类别ID int3@kclb nvarchar(30), -- 课程类别@kcname nvarchar(100), -- 培训计划课程名称 nvarchar1@kcmudi nvarchar(100), -- 培训计划课程目的 ntext2@kctime nvarchar(30), -- 课程时间 float2@kcxxfy float, -- 显性费用 float5@kcyxfy float, -- 隐性费用 float7@kcsjrs float, -- 实际人数 float4@kcrjfy float -- 人均费用 =(显性费用+隐性费用)/实际人数SELECT@ygid = int3,@kcid =(case when int1 is null then 0 else convert(float,int1) end) --从“员工培训记录信息表中获取员工基本信息表ID和部门培训计划及培训记录信息表IDFROM AllUserDataWHERE (tp_ListId = 'e7803513-08f7-4d3d-a08b-db700e87d679') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @tp_id )--print @ygid--print @kcidSELECT @ygname = nvarchar1, --从员工基本信息表中获取员工姓名@ygznbmid = int1FROM AllUserDataWHERE (tp_ListId = '9bd52d9e-07fa-44b6-901c-81d64ec854c3') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @ygid )SELECT @ygznbm = nvarchar1 --根据从职能部门id中职能部门表中取职能部门的名称FROM AllUserDataWHERE (tp_ListId = 'C9ABE852-EA28-4462-8B55-D66674EB8DE5') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @ygznbmid )--print @ygnameif @kcid > 0beginSELECT @kclbid = int3, --从部门培训计划及培训记录信息表中获取课程相关信息@kcname = convert(nvarchar,nvarchar1),@kcmudi = nvarchar3,@kctime = (case when float2 is null then 0 else convert(float,float2) end),@kcxxfy = (case when float5 is null then 0 else convert(float,float5) end),@kcyxfy = (case when float7 is null then 0 else convert(float,float7) end),@kcsjrs = (case when float4 is null then 0 else convert(float,float4) end) FROM AllUserDataWHERE (tp_ListId = '6e485a60-e970-40de-adc8-f52ee5160a55') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @kcid )--print @kcmudiSELECT @kclb = nvarchar1 --根据从课程类别id中课程类别中课程类别的名称FROM AllUserDataWHERE (tp_ListId = 'CD72D055-8EBD-4D07-9CD2-7C3B39098CD6') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @kclbid )/*print '@kcbm 职能部门名称= ' + convert(char, @kcbm)print '@kclb 课程类别= ' + convert(char, @kclb)print '@kcname 课程名称= ' + convert(char, @kcname)print '@kcmudi 课程目的= ' + convert(char, @kcmudi)print '@kctime 课程时间= ' + convert(char, @kctime)print '@kcxxfy 显性费用= ' + convert(char, @kcxxfy)print '@kcyxfy 隐性费用= ' + convert(char, @kcyxfy)print '@kcsjrs 实际人数= ' + convert(char, @kcsjrs)*/if @kcsjrs > 0beginset @kcrjfy = ( @kcxxfy + @kcyxfy ) / 11 -- 人均费用 =(显性费用+隐性费用)/实际人数endif @kcsjrs = 0beginset @kcrjfy = 0end--print '@kcrjfy 人均费用= ' + convert(char, @kcrjfy)update AllUserDataset nvarchar6=convert(nvarchar,@ygname), --姓名nvarchar9=@kcname, --培训计划课程名称nvarchar10=@ygznbm, --职能部门nvarchar8=@kclb, --课程类别float3=@kctime, --计划课时float2=@kcrjfy, --人均费用nvarchar3=@kcmudi --课程目的WHERE (tp_ListId = 'e7803513-08f7-4d3d-a08b-db700e87d679') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @tp_id )endif @kcid = 0beginupdate AllUserDataset nvarchar6=convert(nvarchar,@ygname), --姓名nvarchar10=@ygznbm --职能部门WHERE (tp_ListId = 'e7803513-08f7-4d3d-a08b-db700e87d679') AND (tp_SiteId = '28CDD940-C516-4569-829B-1D3F3B71FB7C')AND(tp_Id = @tp_id )end