Sql µãµÎ
ID int identity(1,1) primary key ×Ô¶¯Ôö³¤,Ö÷¼ü
EXEC sp_rename 'login_info','PDI_login_info' Ö´Ðд洢¹ý³Ì sp_rename , ½«login_info±íÃû ¸ü¸ÄΪ PDI_login_info
SET XACT_ABORT {ON|OFF} Èç¹ûÊÂÎñÖз¢Éú´íÎó£¬on Ôò»áÖÕÖ¹Õû¸öÊÂÎñµÄÖ´ÐУ¬Èç¹ûOFF£¬¼ÌÐø´íÎóµÄÏÂÃæÒ»¾ä
SET ANSI_NULLS {ON|OFF} ÓÃÓÚºÍNULLµÄ±È½Ï£¬È磺null=nullÔÚoffʱ»á·µ»Ø true,ÔÚon ʱΪfalse
set QUOTED_IDENTIFIER ON Ϊ ON ʱ£¬±êʶ·û¿ÉÒÔÓÉË«ÒýºÅ»òÕß[]·Ö¸ô£¬¶øÎÄ×Ö±ØÐëÓɵ¥ÒýºÅ·Ö¸ô,Ϊ OFF ʱ£¬±êʶ·û²»¿É¼ÓÒýºÅ£¬ÇÒ±ØÐë·ûºÏËùÓÐ Transact-SQL ±êʶ·û¹æÔò
SET NOCOUNT {ON| OFF} µ±SET NOCOUNT Ϊ ON ʱ£¬²»·µ»Ø¼ÆÊý£¨±íʾÊÜ Transact-SQL Óï¾äÓ°ÏìµÄÐÐÊý£©¡£µ± SET NOCOUNT Ϊ OFF ʱ£¬·µ»Ø¼ÆÊý
Ïà¹ØÎĵµ£º
windowsÉÏ´æÔÚ32bitµÄÏÞÖÆ£¬ÈçAIX¡¢HP UNIX µÈÓÐÃ÷È·µÄ64BIT OS and ORACLEµÄ°æ±¾£¬32bit oracle¿ÉÒÔ×°ÔÚ64bit os ÉÏ£¬64 bit oracle²»ÄÜ×°ÔÚ32 bit OSÉÏ
oracleÊÇ64bit or 32 bit,32bit ͨ³£ SGAÓÐ 1.7G µÄÏÞÖÆ(ijЩOSµÄ´¦Àí»òÕßWINDOWSÉÏÓÐÌØ¶¨É趨¿ÉÒÔÖ§³Öµ½2GÒÔÉÏÉõÖÁ´ïµ½3.7G
ÈçºÎ²é³öǰ̨ÕýÔÚ·¢³öµÄsqlÓï¾ä:
sele ......
1.oracleɨÃèµÄ˳ÐòΪ´Óϵ½ÉÏ£¬´ÓÓÒµ½×ó
ËùÒÔÎÒÃÇÒª¾¡¿ÉÄܵİÑÊý¾ÝÉٵıí·ÅÔÚºóÃæ£¬½»²æ±í·ÅÔÚºóÃæ£¬×îÄܹýÂ˵ÄÌõ¼þ·ÅÔÚºóÃæ
2.²»ÒªÔÚË÷ÒýÉÏʹÓüÆËãºÍnot²Ù×÷·û
Ë÷ÒýÒ»µ©²ÎÓë¼ÆËã»òÊ¹Ó ......
ÎÄÖеÄSQL¶¼ÊÇ´ÓÎÒµÄÏîÄ¿ÖÐÖ±½Ócopy¹ýÀ´£¬Òò´ËºÜ¶à±íÃûʲô¶¼ÓÐÁË
//´´½¨±í
"CREATE TABLE FEED_TABLE(FeedID TEXT, Title TEXT, Summary TEXT, Author TEXT, ImageName VARCHAR(21), ImageType TEXT, MaxIndex INT, ImageData BLOB)"
//²éѯ¼Ç¼
"select * form 'table_name'"
"select * form 'table name' where val ......
½ñÌìҪͬ²½Ô¶³ÌÊý¾Ý¿âʱ³ö´í£¬±¨´í“ʵ¼ÊµÄ·þÎñÆ÷Ãû³Æ¡£¡£¡£¡£”£¬ÒÔÏÂÊǽâ¾ö·½·¨
SQL code--²é¿´µ±Ç°·þÎñÃû³Æ
select @@servername
--Èç¹ûÓ뵱ǰ¼ÆËã»úÃû²»Ò»Ö£¬ÔòÓÃÒÔÏÂÓï¾äÐÞ¸ÄSQL Server·þÎñÆ÷Ãû
sp_dropserver 'old_name' --ÏÈɾ³ýÔÃû³Æ
GO
sp_addserver 'new_name', lo ......