<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[WSH918的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/WSH918</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; WSH918]]></copyright><item><title><![CDATA[查询重复项以及删除重复项]]></title><link>https://blog.youkuaiyun.com/WSH918/article/details/80813756</link><guid>https://blog.youkuaiyun.com/WSH918/article/details/80813756</guid><author>WSH918</author><pubDate>Tue, 26 Jun 2018 13:07:41 +0800</pubDate><description><![CDATA[–查询出重复项。Deptid,catecode,pid为联合主键。可以换成要查询的内容 
select Deptid,catecode,pid,COUNT(0) as num,Max(DepVsSzID) as maxid from EB_DeptVsCostCategory with (nolock) group by  
Deptid,catecode,pid having count(0)&amp;...]]></description><category></category></item><item><title><![CDATA[delete多表连表删除]]></title><link>https://blog.youkuaiyun.com/WSH918/article/details/80813729</link><guid>https://blog.youkuaiyun.com/WSH918/article/details/80813729</guid><author>WSH918</author><pubDate>Tue, 26 Jun 2018 13:03:55 +0800</pubDate><description><![CDATA[delete 多表删除的使用

1、从数据表t1中把那些id值在数据表t2里有匹配的记录全删除掉

DELETE t1 FROM t1,t2 WHERE t1.id=t2.id 

或

DELETE  FROM t1 USING t1,t2 WHERE t1.id=t2.id 

2、从数据表t1里在数据表t2里没有匹配的记录查找出来并删除掉

DELETE t1 FROM t1 LEFT JO...]]></description><category></category></item><item><title><![CDATA[sqlserver查找所有存储过程中是否包含某字符]]></title><link>https://blog.youkuaiyun.com/WSH918/article/details/80813718</link><guid>https://blog.youkuaiyun.com/WSH918/article/details/80813718</guid><author>WSH918</author><pubDate>Tue, 26 Jun 2018 13:01:48 +0800</pubDate><description><![CDATA[–将text替换成要查找的内容  
select name  
from sysobjects o, syscomments s  
where o.id = s.id  
and text like ‘%text%’  
and o.xtype = ‘P’ 

select * from EB_DeptVsCostCategory

–将text替换成要查找的内容  
SELECT ROUTIN...]]></description><category></category></item><item><title><![CDATA[如何在tomcat上部署项目]]></title><link>https://blog.youkuaiyun.com/WSH918/article/details/70799703</link><guid>https://blog.youkuaiyun.com/WSH918/article/details/70799703</guid><author>WSH918</author><pubDate>Wed, 26 Apr 2017 14:01:45 +0800</pubDate><description><![CDATA[第一种方法：在项目未完成时： 
     1，Eclipse的windows-show view-servers-绿色按钮start 
     2，右键单击tomcat,选择add and remove .选择项目 add 完成，启动tomcat 
     3，在浏览器地址栏http://localhost:8080(]]></description><category></category></item><item><title><![CDATA[运算符]]></title><link>https://blog.youkuaiyun.com/WSH918/article/details/60473486</link><guid>https://blog.youkuaiyun.com/WSH918/article/details/60473486</guid><author>WSH918</author><pubDate>Sun, 05 Mar 2017 20:03:58 +0800</pubDate><description><![CDATA[一：算数运算 
（1）算数运算符： 
加（+）：//注意byte和int之间的强制转换
int a=1,b=2;
int c=a+b;
System.out.println(c);减（-） 
乘(*) 
除(/) 
取模(%)适应于整数，char及浮点数int i=10；
int c=i%3;
System.out.println(c);自增(++) 
(1)写在变量前，表示先增加在赋值 
(2)写]]></description><category></category></item><item><title><![CDATA[Java的基本数据类型]]></title><link>https://blog.youkuaiyun.com/WSH918/article/details/60348179</link><guid>https://blog.youkuaiyun.com/WSH918/article/details/60348179</guid><author>WSH918</author><pubDate>Sat, 04 Mar 2017 21:14:01 +0800</pubDate><description><![CDATA[一.基本数据类型的占位及取值范围 
1，整数类型的 
1）.byte(8位）;取值 
2）.short（16位）;取值 
3）.int（32位）;取值 
4）.long（64位）;取值 
2，浮点类型 
1）.float(4个字节）; 
2）.double（6个字节）; 
3，字符型(文本型） 
1）.char（unicode字符32位）; 
四.布尔型 
1）.boolean(8位）;]]></description><category></category></item></channel></rss>