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

sqlÖÐÈçºÎ²éѯÊý¾Ý¿â±íµÈÐÅÏ¢

1.²éѯÊý¾Ý¿âÖеıíÊÇ·ñ´æÔÚ£º
sqlÓï¾ä£º
select   count(1)   from   sysobjects   where object_name(id)='±íÃû'
»ò£º
select count(*) from sysobjects where id = object_id(N'[±íÃû]') and OBJECTPROPERTY(id, N'IsUserTable') = 1
´æ´¢¹ý³Ì£º
IF Exists(Select 1 from sysObjects Where Name ='±íÃû' And Type In ('S','U'))
  Print 'Exists Table'
Else
  Print 'Not Exists Table'
ת£º
µÚÒ»ÖÖ·½·¨£ºÅжÏϵͳ¶ÔÏóÊÇ·ñ´æÔÚ
DECLARE
  @DbTableFileName VARCHAR(100)
SET @DbTableFileName = 'tx'
IF objectproperty(object_id(@DbTableFileName),'IsUserTable') IS NOT NULL
  PRINT 'EXISTS '
 ELSE
  PRINT 'NOT EXISTS '
IF object_id(@DbTableFileName) IS NOT NULL
  PRINT 'EXISTS '
 ELSE
  PRINT 'NOT EXISTS '
IF EXISTS (SELECT Object_id(@DbTableFileName))
  PRINT 'EXISTS '
 ELSE
  PRINT 'NOT EXISTS '
µÚ¶þÖÖ·½·¨£ºÍ¨¹ý²éѯϵͳ±í
DECLARE
  @DbTableFileName VARCHAR(100)
SET @DbTableFileName = 'tx'
 IF EXISTS (SELECT 1
           from   sysobjects
           WHERE  name = @DbTableFileName
                  AND TYPE = 'u')
  PRINT 'EXISTS '
 ELSE
  PRINT 'NOT EXISTS '
×¢£ºa ÊÇÒ»¸ö±í£¬U´ú±íÊÇÊý¾Ý±íÀàÐÍ
ÀàËÆÓÚUµÄÀàÐÍ´úÂ룬ÈçÏÂËùʾ
¶ÔÏóÀàÐÍ£º
AF = ¾ÛºÏº¯Êý (CLR)
C = CHECK Ô¼Êø
D = DEFAULT£¨Ô¼Êø»ò¶ÀÁ¢£©
F = FOREIGN KEY Ô¼Êø
PK = PRIMARY KEY Ô¼Êø
P = SQL ´æ´¢¹ý³Ì
PC = ³ÌÐò¼¯ (CLR) ´æ´¢¹ý³Ì
FN = SQL ±êÁ¿º¯Êý
FS = ³ÌÐò¼¯ (CLR) ±êÁ¿º¯Êý
FT = ³ÌÐò¼¯ (CLR) ±íÖµº¯Êý
R = ¹æÔò£¨¾Éʽ£¬¶ÀÁ¢£©
RF = ¸´ÖÆÉ¸Ñ¡¹ý³Ì
SN = ͬÒå´Ê
SQ = ·þÎñ¶ÓÁÐ
TA = ³ÌÐò¼¯ (CLR) DML ´¥·¢Æ÷
TR = SQL DML ´¥·¢Æ÷
IF = SQL ÄÚÁª±íÖµº¯Êý
TF = SQL ±íÖµº¯Êý
U


Ïà¹ØÎĵµ£º

MySQL ×Ö·û¼¯µ¼ÖÂSQLÁ¬½ÓÖ®ºóÖÐÎÄÂÒÂëµÄÎÊÌ⣡

character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......

SQL2005ºÍ(Excel |access)Ö®¼äµÄÊý¾Ýµ¼Èëµ¼³ö


Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º    
  
  
--Excel---->SQL2005  µ¼È룺    
  
  
select * into useinfo from O ......

JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,Oracle

import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
  
public static void main(String[] args)throws Exception {
  
   Connection conn=null;
  
       //====Á¬½ÓACCESSÊý¾Ý¿â ......

[ÊÕ£] ÓÃsqlite Ö´Ðбê×¼ sql Óï·¨

http://www.umgr.com/blog/PostView.aspx?bpId=36294
 1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬  char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......

SQL Server£¬¸ºÔؾùºâ£¬Êý¾Ý¿â¼¯Èº

SQL Server 2005ʵÏÖ¸ºÔؾùºâ
ǰÑÔ
InternetµÄ¹æÄ£Ã¿Ò»°ÙÌì¾Í»áÔö³¤Ò»±¶£¬¿Í»§Ï£Íû»ñµÃ7Ìì×24СʱµÄ²»¼ä¶Ï¿ÉÓÃÐÔ¼°½Ï¿ìµÄϵͳ·´Ó¦Ê±¼ä£¬¶ø²»Ô¸ÂŴο´µ½Ä³¸öÕ¾µã“Server Too Busy”¼°Æµ·±µÄϵͳ¹ÊÕÏ¡£
Ëæ×ÅÒµÎñÁ¿µÄÌá¸ß,ÒÔ¼°·ÃÎÊÁ¿ºÍÊý¾ÝÁ÷Á¿µÄ¿ìËÙÔö³¤£¬ÍøÂç¸÷¸öºËÐIJ¿·ÖµÄ´¦ÀíÐÔÄܺͼÆËãÇ¿¶ÈÒ²ÏàÓ¦Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ