漫漫技术人生路

今天我们来看一个比较简单的句子：

It's no fun to lose any friend --- and losing a real old one is even tougher.
失去朋友真不是个滋味，失去真正的老朋友更让人受不了。

句型提炼：
It is no fun to do sth. (--- and ... is even tougher.)
干某事可不是件有趣的事，（... 更让人受不了。）

造句：
for example
洗一大堆脏衣服可不是件有趣的事，在大冷天里洗更让人受不了。
It's no fun to wash piles of dirty clothes --- and washing them in a cold winter day is even tougher.

补充句型：
It's fun to do sth.

drop procedure mCount
go
create procedure mCount
@month int
as
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tempTable'))
drop table #tempTable
create Table #tempTable
(
   ID int IDENTITY PRIMARY KEY,
   userName varchar(50),
   minusCount int
)

declare minusCount cursor for
select distinct userId from AccountTable
declare @userId varchar(50)
declare @preMonthScore int
declare @currentMonthScore int
declare @minusCount int
declare @userName varchar(50)
declare @minus int
set @minus=@month-1
open minusCount
fetch next from minusCount into @userId
while @@fetch_status=0
begin
fetch next from minusCount into @userId
set @currentMonthScore=(select scoreCount from  mountCount(@month,@userId))
set @preMonthScore=(select scoreCount from  mountCount2(@minus,@userId))
set @minusCount=@preMonthscore-@currentMonthScore
set @userName=(select [name] from userTable where userid=@userId)
insert into #tempTable values (@userName,@minusCount)
end
close minusCount
deallocate minusCount
select top 3 * from #tempTable
drop procedure mCount
go
create procedure mCount
@month int
as
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tempTable'))
drop table #tempTable
create Table #tempTable
(
   ID int IDENTITY PRIMARY KEY,
   userName varchar(50),
   minusCount int
)

declare minusCount cursor for
select distinct userId from AccountTable
declare @userId varchar(50)
declare @preMonthScore int
declare @currentMonthScore int
declare @minusCount int
declare @userName varchar(50)
declare @minus int
set @minus=@month-1
open minusCount
fetch next from minusCount into @userId
while @@fetch_status=0
begin
fetch next from minusCount into @userId
set @currentMonthScore=(select scoreCount from  mountCount(@month,@userId))
set @preMonthScore=(select scoreCount from  mountCount2(@minus,@userId))
set @minusCount=@preMonthscore-@currentMonthScore
set @userName=(select [name] from userTable where userid=@userId)
insert into #tempTable values (@userName,@minusCount)
end
close minusCount
deallocate minusCount
select top 3 * from #tempTable
drop procedure mCount
go
create procedure mCount
@month int
as
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tempTable'))
drop table #tempTable
create Table #tempTable
(
   ID int IDENTITY PRIMARY KEY,
   userName varchar(50),
   minusCount int
)

declare minusCount cursor for
select distinct userId from AccountTable
declare @userId varchar(50)
declare @preMonthScore int
declare @currentMonthScore int
declare @minusCount int
declare @userName varchar(50)
declare @minus int
set @minus=@month-1
open minusCount
fetch next from minusCount into @userId
while @@fetch_status=0
begin
fetch next from minusCount into @userId
set @currentMonthScore=(select scoreCount from  mountCount(@month,@userId))
set @preMonthScore=(select scoreCount from  mountCount2(@minus,@userId))
set @minusCount=@preMonthscore-@currentMonthScore
set @userName=(select [name] from userTable where userid=@userId)
insert into #tempTable values (@userName,@minusCount)
end
close minusCount
deallocate minusCount
select top 3 * from #tempTable
drop procedure mCount
go
create procedure mCount
@month int
as
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tempTable'))
drop table #tempTable
create Table #tempTable
(
   ID int IDENTITY PRIMARY KEY,
   userName varchar(50),
   minusCount int
)

declare minusCount cursor for
select distinct userId from AccountTable
declare @userId varchar(50)
declare @preMonthScore int
declare @currentMonthScore int
declare @minusCount int
declare @userName varchar(50)
declare @minus int
set @minus=@month-1
open minusCount
fetch next from minusCount into @userId
while @@fetch_status=0
begin
fetch next from minusCount into @userId
set @currentMonthScore=(select scoreCount from  mountCount(@month,@userId))
set @preMonthScore=(select scoreCount from  mountCount2(@minus,@userId))
set @minusCount=@preMonthscore-@currentMonthScore
set @userName=(select [name] from userTable where userid=@userId)
insert into #tempTable values (@userName,@minusCount)
end
close minusCount
deallocate minusCount
select top 3 * from #tempTable
drop procedure mCount
go
create procedure mCount
@month int
as
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tempTable'))
drop table #tempTable
create Table #tempTable
(
   ID int IDENTITY PRIMARY KEY,
   userName varchar(50),
   minusCount int
)

declare minusCount cursor for
select distinct userId from AccountTable
declare @userId varchar(50)
declare @preMonthScore int
declare @currentMonthScore int
declare @minusCount int
declare @userName varchar(50)
declare @minus int
set @minus=@month-1
open minusCount
fetch next from minusCount into @userId
while @@fetch_status=0
begin
fetch next from minusCount into @userId
set @currentMonthScore=(select scoreCount from  mountCount(@month,@userId))
set @preMonthScore=(select scoreCount from  mountCount2(@minus,@userId))
set @minusCount=@preMonthscore-@currentMonthScore
set @userName=(select [name] from userTable where userid=@userId)
insert into #tempTable values (@userName,@minusCount)
end
close minusCount
deallocate minusCount
select top 3 * from #tempTable
drop procedure mCount
go
create procedure mCount
@month int
as
if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#tempTable'))
drop table #tempTable
create Table #tempTable
(
   ID int IDENTITY PRIMARY KEY,
   userName varchar(50),
   minusCount int
)

declare minusCount cursor for
select distinct userId from AccountTable
declare @userId varchar(50)
declare @preMonthScore int
declare @currentMonthScore int
declare @minusCount int
declare @userName varchar(50)
declare @minus int
set @minus=@month-1
open minusCount
fetch next from minusCount into @userId
while @@fetch_status=0
begin
fetch next from minusCount into @userId
set @currentMonthScore=(select scoreCount from  mountCount(@month,@userId))
set @preMonthScore=(select scoreCount from  mountCount2(@minus,@userId))
set @minusCount=@preMonthscore-@currentMonthScore
set @userName=(select [name] from userTable where userid=@userId)
insert into #tempTable values (@userName,@minusCount)
end
close minusCount
deallocate minusCount
select top 3 * from #tempTable