从今天开始，认真做学习笔记，嗯。

羞于问人的经纬度转10进制数:例如乌鲁木齐最小纬度42°45′32〃，转化为10为进制是42+45/60+32/3600=42.758888

我++,sql语句里任何值与null相加都为空!

判断字符串是否包含全角字符(汉字或占两个字节的英文字符)
if(string.length>encoding.default.getcountbyte(string) bool ==true;

select isnull(tab.comumn,0) from tab 返回某列的值，如果是null，则返回0

sql判断包含字符串是否全角字符:
if len('abcd我')<>datalength('abcd我')
print '含有汉字'
else
print '不含有汉字'
len 判断是字符的长度
datalength 判断是字节

USE [HKCK_SB]
GO
/****** 对象: StoredProcedure [dbo].[P_EP_Info_BG_del] 脚本日期: 12/20/2013 22:37:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
--[P_EP_Info_BG_del] '6501020001',0
-- =============================================
-- Author:<Author,,Name>
-- Create date: <Create Date,,>
-- Description: [P_EP_Info_BG_del] '6501030124',2012,1 select * from T_EP_Info_BG
-- =============================================
ALTER PROCEDURE [dbo].[P_EP_Info_BG_del]
@Code nvarchar(20),
@Year nvarchar(4),
@ReturnValue int output
AS
BEGIN
--delete T_EP_Info_BG where Code=@Code
declare @Sql nvarchar(max)
declare @tab nvarchar(50)
declare _cur cursor for select 'delete '+[Name] +' where [Year]='''+@Year+''' and Code='+@Code ,[Name] from sys.tables where left([Name],4)='T_EP'--TB
open _cur
fetch next from _cur into @Sql,@tab
while @@fetch_status = 0
begin
exec(@Sql)
--exec ('delete '+@tab+' where not exists(select * from T_EP_Info_BG where Code ='+@tab+'.Code and [Year]='+@tab+'.[Year]) ')
fetch next from _cur into @Sql,@tab
end
close _cur
DEALLOCATE _cur
set @ReturnValue=@@error
END