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

5±¾¾­µäSQLµç×ÓÊé


SQL±¦µä

SQL±ØÖª±Ø»áµÚÈý°æ

SQLÈëÞ­µäµÚËİæ

Sams Teach Yourself SQL in 10 Minutes Third Edition

SQL The Complete Reference



Ïà¹ØÎĵµ£º

¹ØÓÚ³ÌÐò´úÂëÖеÄSQLÓï¾ä

ÔÚ³ÌÐòÖÐÓÐЩ²éѯÓï¾äÏà¶Ô½Ï³¤£¬¿ÉÒÔ½«Óï¾äµ¥¶ÀдÔÚÒ»¸öXXX.sqlÎļþÖУ¬ÔÚ³ÌÐòÖжÁÈ¡SQLÎļþ
¾ßÌåÉæ¼°µ½
import java.io.File;
import org.apache.commons.io.FileUtils;
import java.net.URL;
URL resourceUrl = XXXX.class.getClassLoader().getResource(SQL_PATH+sqlName);//SQL_PATH¾ßÌåSQLÎļþ´æÔÚ·¾¶£¬sqlName¼ ......

ÈýÖÖSQL·ÖÒ³·¨¡¾×ªÌû¡¿

Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«

±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)

1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)

Óï¾äÐÎʽ£º 
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
  (SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
  from ± ......

ÈÃSQL SERVERÍ»ÆÆ2GÄÚ´æÏÞÖÆ


32
λµÄ²Ù×÷ϵͳֻÄÜÓÃ
4G
µÄÄڴ棨²»È·¶¨Õâ¾ä»°ÊÇ·ñÕýÈ·£©£¬ÒòΪ
2
µÄ
32
´Î·½ÊÇ
4G
¡£Ä¬ÈϵÄÇé¿öÏ£¬²Ù×÷ϵͳ¸ø×Ô¼ºÁôÁË
2G
£¬Ê£ÏµÄ
2G
¸øÓ¦ÓóÌÐò¡£ËùÒÔ£¬Ã¿¸öÓ¦ÓóÌÐòËùÄÜʹÓõÄÄڴ棬×î´ó²»³¬¹ý
2G
¡£¾Ý˵¿ÉÒÔ¸Ä
WINDOWS
µÄ
BOOT.INI
£¬Ç¿ÖƲÙ×÷ϵͳֻʹÓÃ
1G
£¬¼´Ê¹ÕâÑù£¬Ó¦ÓóÌÐòÒ²ÖÁ¶àÊÇ ......

Discuz!NT 3.0 SQL×¢Èë©¶´

 ·¢±íϱ¾È˽øÐЩ¶´ÍÚ¾òµÄÊׯªÔ­´´ÎÄÕ£º
¶ÔDiscuz nT3.0½øÐÐÁË·ÖÎö£¬·¢ÏÖspacemanage.aspxÒ³Ãæ´æÔÚÒ»¸ö×¢Èë©¶´£¬
¸ÃÒ³ÃæÎ»Öãºdnt3_src\dnt3\Discuz.Web\space\Admin
´úÂëÈçÏ£º
public void BindData()
{
DataGrid1.AllowCustomPaging = true;
string username = Usernam ......

SQL Server µÄÁ¬½Ó¡¢²éѯÓë¸üÐÂ

#Region " ÃüÃû¿Õ¼ä "
Imports System.Data
Imports System.Data.SqlClient
#End Region
Public Class DBCommon
Implements IDisposable
#Region " ³ÉÔ±±äÁ¿ "
Private conn As SqlConnection
Private cmd As SqlCommand
Private trans As SqlTransaction
#End Region
#Region " ¹¹Ô캯Êý "
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ