<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[NanJi_Linx的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/NanJi_Linx</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; NanJi_Linx]]></copyright><item><title><![CDATA[MSSQL类型修改]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/120764135</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/120764135</guid><author>NanJi_Linx</author><pubDate>Thu, 14 Oct 2021 14:53:31 +0800</pubDate><description><![CDATA[IF EXISTS (SELECT 1 FROM sys.types t join sys.schemas s on t.schema_id=s.schema_id and t.name='My_TypeName' and s.name='dbo')
	EXEC sys.sp_rename 'dbo.My_TypeName', 'My_TypeName_old';
CREATE TYPE [dbo].[My_TypeName] AS TABLE(

)


--刷新引用此TYPE的存储过程
DECLARE.]]></description><category></category></item><item><title><![CDATA[VS2019用Installer下载安装慢]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/114855625</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/114855625</guid><author>NanJi_Linx</author><pubDate>Mon, 15 Mar 2021 22:31:37 +0800</pubDate><description><![CDATA[控制面板→网络→网络和共享中心→更改适配器设置→以太网属性→TCP/IPV4

替换DNS服务器地址 8.8.8.8 8.8.4.4

关于8.8.8.8
]]></description><category></category></item><item><title><![CDATA[C# &符号]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/112477915</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/112477915</guid><author>NanJi_Linx</author><pubDate>Mon, 11 Jan 2021 17:07:15 +0800</pubDate><description><![CDATA[--------------------------------------------分割符--------------------------------------------

先记录一下
]]></description><category></category></item><item><title><![CDATA[MSSQL 约束类]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/107375844</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/107375844</guid><author>NanJi_Linx</author><pubDate>Thu, 16 Jul 2020 09:28:01 +0800</pubDate><description><![CDATA[--联合主键
ALTER TABLE [table] WITH NOCHECK ADD CONSTRAINT [PK_pk] PRIMARY KEY  NONCLUSTERED ([column1],[column2])﻿​


]]></description><category></category></item><item><title><![CDATA[MSSQL 清理日志]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/107375784</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/107375784</guid><author>NanJi_Linx</author><pubDate>Thu, 16 Jul 2020 09:27:00 +0800</pubDate><description><![CDATA[USE[master]
 GO
 ALTER DATABASE 要清理的数据库名称 SET RECOVERY SIMPLE WITH NO_WAIT
 GO
 ALTER DATABASE 要清理的数据库名称 SET RECOVERY SIMPLE --简单模式
 GO
 USE 要清理的数据库名称
 GO
 DBCC SHRINKFILE (N'要清理的数据库名称_log' , 2, TRUNCATEONLY) --设置压缩后的日志大小为2M，可以自行指定
 GO
 USE[master]
 GO
 A.]]></description><category></category></item><item><title><![CDATA[MSSQL 判断存在]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/107375678</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/107375678</guid><author>NanJi_Linx</author><pubDate>Thu, 16 Jul 2020 09:24:17 +0800</pubDate><description><![CDATA[--判断库
IF EXISTS(SELECT * FROM master..sysdatabases WHERE name=N'库名') 
    PRINT 'EXISTS'
ELSE
    PRINT 'NOT EXISTS'​​


--判断表 
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'表名') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) 
    PRINT 'EX..]]></description><category></category></item><item><title><![CDATA[MSSQL--根据值查找表和字段]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/106360267</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/106360267</guid><author>NanJi_Linx</author><pubDate>Tue, 26 May 2020 17:09:02 +0800</pubDate><description><![CDATA[--根据值查找表和字段
DECLARE @value  VARCHAR(1024)
set @value='需要查找的字符串'
SET NOCOUNT ON;
DECLARE @sql VARCHAR(1024)
DECLARE @table VARCHAR(64)
DECLARE @column VARCHAR(64)
CREATE TABLE #t
(
    tablename VARCHAR(64),
    columnname VARCHAR(64)
)
DECLARE TABLES CURS.]]></description><category></category></item><item><title><![CDATA[C# ToString()使用方法]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/52438051</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/52438051</guid><author>NanJi_Linx</author><pubDate>Wed, 24 Jan 2018 11:27:17 +0800</pubDate><description><![CDATA[int i=5.67
货币：i.ToString("C")   ￥5.67
小数位： i.ToString("f2")  5.67
                 i.ToString("f5")  5.67000


货币  ToString("C")  ￥5.67
D 
十进制数 
25.ToString("D5") 
00025 
E 
科学型 
25000.To]]></description><category></category></item><item><title><![CDATA[使用HttpURLConnection通过post请求服务器时，URLEncode编码的必要性]]></title><link>https://blog.youkuaiyun.com/NanJi_Linx/article/details/79148721</link><guid>https://blog.youkuaiyun.com/NanJi_Linx/article/details/79148721</guid><author>NanJi_Linx</author><pubDate>Wed, 24 Jan 2018 11:26:51 +0800</pubDate><description><![CDATA[通过Post提交表单数据时，数据类型为x-www-urlencoded,提交到服务器的数据服务器默认是通过URLEncoder.encode()编码过得，所以服务器处理时会用URLDecoder.decode(s)进行解码，此时传输的数据就不能包括一些特殊字符。如+、%2b

原因：通过URLEncoder.encode()空格会被编码成+号，+号会被编码成%2B，所以如果包括+，%2B的元数]]></description><category></category></item></channel></rss>