ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ȷÈÏʹÓÃjava.io.file.separatorcharÁ¬½ÓĿ¼
......
ÎÒдһ¸öÇåÀíÈÕÖ¾µÄ
CREATE PROCEDURE dbo.ClearLog
AS
USE [ta]
GO
DBCC SHRINKDATABASE(N'ta')
GO
˵go´¦´íÎó,ºÍ²»ÔÊÐíʹÓÃuse database ÎªÊ²Ã´ÄØ?
ÒýÓÃ
ÎÒдһ¸öÇåÀíÈÕÖ¾µÄ
CREATE PROCEDURE dbo.ClearLog
AS
USE [ta]
GO
DBCC SHRINKDATABASE(N'ta')
GO
˵go´¦´íÎó,ºÍ²» ......
table a
Êý¾ÝÏî
id num1 num2
1 1 0
2 0 1
3 1 1
num1 num2 Ö»ÄÜΪ 1»ò0
table b
id t1 t2
1 0 0
2 10 10
3 1 0
t1 ,t2 ±íʾ idÎ ......
ÏÂÃæÊÇdaoµÄ·½·¨£º
public void insertstuSubject(int stuid, int subid, String date) {
// TODO Auto-generated method stub
String sql="insert into stusubject(studentid,subjectid,subbegin) values("+stuid+","+subid+","+date+")";
log.info("Ö´ÐÐÁ˲å ......
create proc p_getlinkinfo
@dbname sysname=null,--Òª²éѯµÄÊý¾Ý¿âÃû,ĬÈϲéѯËùÓÐÊý¾Ý¿âµÄÁ¬½ÓÐÅÏ¢
@includeip bit=0--ÊÇ·ñÏÔʾIPµØÖ·,ÒòΪ²éѯIPµØÖ·±È½Ï·Ñʱ,ËùÒÔÔö¼Ó´Ë¿ØÖÆ
as
declare @dbid int
set @dbid=db_id(@dbname)
create table #tb(id int identity(1,1),dbname sysname,hostnam ......
ÎÒÒª±ÀÀ£ÁË£¬ºÜ¼òµ¥µÄÀý×Ó£¬Ôõô¾ÍÊä²»³öÕýÈ·´ð°¸ÄØ
----------------------------------
<?php
$xml_str = " <?xml version='1.0' encoding='UTF-8'?>";
$xml_str .= " <EMAILDOCUMENT>";
$xml_str .= " <TITLE>×î½üÔÚѧʲô </TITLE&g ......