Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

jdbcÁ¬½Ósql server

import java.sql.*;
public class JdbcUtil
{
    public static void close(Statement st, Connection con)
    {
        try
        {
            st.close();
        }catch(Exception e)
        {
        }
       
        try
        {
            con.close();
        }catch(Exception e)
        {
        }
    }
   
    public static void close(ResultSet rs, Statement st, Connection con)
    {
        try
        {
            rs.close();
        }catch(Exception e)
        {
        }
        close(st, con);
    }
   
    public static Connection getConnection() throws Exception
    {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
        return DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db", "sa", "54321");
    }
}


Ïà¹ØÎĵµ£º

ORACLE+SQLÐÔÄÜÓÅ»¯ÏµÁÐ

ORACLE SQLÐÔÄÜÓÅ»¯ÏµÁÐ
 
1. ·ÃÎÊTableµÄ·½Ê½
ORACLE ²ÉÓÃÁ½ÖÖ·ÃÎʱíÖмǼµÄ·½Ê½:
a. È«±íɨÃè
È«±íɨÃè¾ÍÊÇ˳ÐòµØ·ÃÎʱíÖÐÿÌõ¼Ç¼. ORACLE²ÉÓÃÒ»´Î¶ÁÈë¶à¸öÊý¾Ý¿é(database block)µÄ·½Ê½ÓÅ»¯È«±íɨÃè.
b. ͨ¹ýROWID·ÃÎʱí
Äã¿ÉÒÔ²ÉÓûùÓÚROWIDµÄ·ÃÎÊ·½Ê½Çé¿ö,Ìá¸ß·ÃÎʱíµÄЧÂÊ, , ROWID°üº¬Á˱íÖмǼµ ......

ms sql³£ÓÃÓï¾ä(¸ù¾ÝÐèÒªËæÊ±¸üÐÂ)


²éÑ¯ÖØ¸´Öµ£¬ÏÔʾ³ö²»Öظ´µÄ²¿·Ö
select distinct(employeeid) from orders
²éѯÁ½¸ö±íÖ®¼äÏàͬÊý¾Ý
select orders.EmployeeID,Employees.EmployeeID
from orders  INNER JOIN Employees
on Employees.EmployeeID=orders.EmployeeID
ʵÏÖÄ¿µÄ£¬Ò»¸ö±í´æ·ÅÓû§±àºÅºÍÓû§Ãû£¬ÔÚÁíÒ»¸ö±íÖпÉÒÔ¸ù¾ÝÓû§±àº ......

SQL Server 2005ÐÂÌØÐÔ£¬²¿·Ö±¸·Ý£¨partial backup£©

Ò²ÊÇSQL Server 2005´øÀ´µÄÐÂÌØÐÔ£¬²¿·Ö±¸·Ý£¨partial backup£©×Ô¶¯´´½¨Êý¾Ý¿âÖÐÖ÷Îļþ×éºÍËùÓ줻î¶Áд¹¦ÄܵÄÎļþ×éµÄ±¸·Ý¡£Èç¹û±¸·Ý´æÔÚÖ»¶ÁÎļþ×éµÄÊý¾Ý¿â£¬²¿·Ö±¸·Ý½«Ö»¶ÔÖ÷Îļþ×é½øÐб¸·Ý¡£Õâ¸öÑ¡Ïî¶ÔÓÚÄÇЩ´æÔÚÖ»¶ÁÎļþ×éµÄ³¬´óÐÍÊý¾Ý¿âÊÇÀíÏëµÄ£¬Ëü²»ÐèÒªÏñÄÇЩ¿ÉдµÄÎļþ×鱸·ÝµÃÄÇôƵ·±¡£
³ýÁËÐèÒªÖ¸¶¨READ_WRIT ......

ÈçºÎʶ±ð SQL Server µÄ°æ±¾¡¾×ª×Ômsdn¡¿

ÈçºÎÈ·¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾
Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
ÔËÐнá¹ûÈçÏ£º
²úÆ·° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ