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

SQLÊý¾Ý¿â³£ÓÃÃüÁî ´´½¨,ɾ³ý±í Ìí¼Ó,ÐÞ¸Ä,ɾ³ý×Ö¶Î

SQLÊý¾Ý¿â³£ÓÃÃüÁî-´´½¨,ɾ³ý±í-Ìí¼Ó,ÐÞ¸Ä,ɾ³ý×Ö¶Î
http://blog.csdn.net/cncco/archive/2009/08/08/4424555.aspx
'´´½¨±í
CREATE TABLE dbo£®CategoriesNew
(CategoryID intIDETITY (1£¬1) NOT NULL£¬
CategoryName nvarchar(15) NOT NULL£¬
Description ntext NULL£¬
Picture image NULL)
'ɾ³ý±í
DROP TABLE table_name[,...n]
'Ôö¼Ó×Ö¶Î
addsqlstr = "alter table docdsp add dspcode char(200)"
'ɾ³ý×Ö¶Î
delsqlstr = "ALTER TABLE table_NAME DROP COLUMN column_NAME"
'ÐÞ¸Ä×Ö¶ÎÀàÐÍ
editsqlstr = "ALTER TABLE table_name ALTER COLUMN column_name new_data_type"
Ïêϸ˵Ã÷£º
3.2 ´´½¨±í
ÔÚ¶¨ÒåÁ˱íµÄËùÓÐÊý¾ÝÀàÐÍÖ®ºó£¬¾Í¿ÉÒÔ´´½¨±í¡¢Ìí¼ÓºÍɾ³ýÁС¢ÒÔ¼°Éú³ÉÁÐÖµÁË¡£
3.2.3 ´´½¨ºÍɾ³ý±í
1¡¢´´½¨±íµÄ»ù±¾ÒªÇó
´´½¨±íʱ±ØÐëÖ¸¶¨±íÃû¡¢ÁÐÃûÒÔ¼°Êý¾ÝÀàÐÍ¡£¶Ô¸ø¶¨µÄ±íÀ´Ëµ£¬ÁÐÃû±ØÐëΨһ£¬µ«ÊÇ£¬Í¬Ò»¸öÊý¾Ý¿âÖв»Í¬±íµÄÁеÄÃû³Æ¿ÉÒÔÏàͬ¡£±ØÐëΪÿһÁж¼Ö¸¶¨Êý¾ÝÀàÐÍ¡£
ÒÔÏÂÊÇÔÚSQL ServerÖд´½¨±íµÄ¼«ÏÞ£º
􀂋 ÿ¸öÊý¾Ý¿âÖпÉÒÔÓÐ20ÒÚ¸ö±í¡£
􀂋 ÿ¸ö±í¿ÉÒÔÓÐ1024¸öÁС£
􀂋 ÿ¸öÁпÉÒÔÓÐ8060×Ö½Ú(ÕâÒ»—½üËÆµÄ×î´ó³¤¶È²»ÊÊÓÃÓÚtext¡¢ntextºÍimageÊý¾ÝÀàÐÍ)¡£
2¡¢ÁÐÕûÐò(Column Collation)
SQL ServerÖ§³ÖÔÚͬһ¸öÊý¾Ý¿âÖÐÒÔ²»Í¬µÄÕûÐò·½Ê½´æ´¢¶ÔÏó¡£²»Í¬µÄSQL ServerÕûÐò·½Ê½¿ÉÒÔÔÚÁм¶Ö¸¶¨£¬ÕâÑù£¬±íÖеÄÿ¸öÁж¼¿ÉÒÔÖ¸¶¨²»Í¬µÄÕûÐò·½Ê½¡£
3¡¢Ö¸¶¨NULL»òNOT NULL
ÎÒÃÇ¿ÉÒÔÔÚ±í¶¨ÒåÖÐÖ¸¶¨ÔÚÿ¸öÁÐÉÏÊÇ·ñÔÊÐí¿ÕÖµ¡£Èç¹ûδָ¶¨NULL»òNOT NULL£¬SQL Server¸ù¾Ý»á»°¼¶»òÊý¾Ý¿â¼¶µÄȱʡÉèÖÃÌṩÏàÓ¦µÄNULL»òNOT NULLÌØÐÔ¡£µ«ÊÇ£¬ÕâЩȱʡÉèÖÿÉÄܻᷢÉú±ä»¯£¬Òò´Ë£¬²»ÒªÒÀÀµÕâЩȱʡÉèÖá£NOT NULLÊÇSQL ServerµÄȱʡÉèÖá£
4¡¢´´½¨±íµÄ²¿·ÖÓï·¨
CREATE TABLE table_name
column_name datatype [COLLATE<collation_name>]
[NULL|NOT NULL]
| column_name AS computed_column_expression
[,...n]
ÏÂÃæµÄÀý×Ó´´½¨ÁËÒ»¸ödbo.CategoriesNew±í£¬Í¬Ê±ÃèÊöÁ˱íÖеÄÁУ¬Ã¿ÁеÄÊý¾ÝÀàÐͺÍÿÁÐÊÇ·ñÔÊÐíΪNullÖµ¡£
CREATE TABLE dbo£®CategoriesNew
(CategoryID intIDETITY (1£¬1) NOT NULL£¬
CategoryName nvarchar(15) NOT NULL£¬
Description ntext NULL£¬
Picture image NULL)
×¢Ò⣺Äã¿ÉÒÔʹÓÃSQL Server Enterprise Manager»òÖ´ÐÐsp_helpϵͳ´æ´¢


Ïà¹ØÎĵµ£º

Sql Server2005 ת Access

ÔÚÍøÉÏÕÒÁËºÃ¶à¹ØÓÚSqlServer2005תaccessµÄ·½·¨£¬´ó¶à¶¼ÊÇÓÃsqlÓï¾ä£¬¶øÎÒ²»ÏëÓÃÄÇÖÖ·½·¨£¬ÓÚÊÇÎÒ×Ô¼ºÃþË÷³öÀ´ÈçºÎ½«SqlServerÊý¾Ý¿âת»»³Éaccess£¬·½·¨¿ÉÄÜÓе㱿£¬²»¹ýÍê³ÉÁËת»»µÄ¹¦ÄÜ¡£ÏÂÃæÊǾßÌå²½Ö裺
1.´ò¿ªAccess£¬½¨Á¢Ò»¸öºó׺ÃûΪ.mdbµÄ¿ÕµÄÊý¾Ý¿âÎļþ£¨Ä¬ÈϺó׺¿ÉÄÜÊÇ.accdb,ÎÒÃǰÑËü¸ÄΪ.mdb¾Í¿ÉÒÔÁË£©£¬È»ºó ......

ÔÚSQL SERVERµÄ±íÖУ¬ÈçºÎʵÏÖ²¿·Ö¼Ç¼µÄ¸´ÖÆ£¿

ÏÖÓÐSQL SERVERµÄÊý¾Ý±í£¨SalesItem£©,SalestemÓÐÒÔÏÂ×Ö¶Î:¿Í»§±àºÅ£¬ÏîÄ¿±àºÅ£¬¿Í»§Æ·ºÅ£¬»õ±Ò£¬µ¥¼Û£¬ÏúÊÛÔ±¡£ÐèÒª´Ó±íÖÐÈ¡³öC145µÄÊý¾Ý£¬ÔÙ°ÑÕâЩÊý¾ÝµÄ¿Í»§±àºÅ¸ÄΪC522£¬ÔÙ±£´æ»Ø±íSalesItemÎÊÌâ²¹³ä£ºÕâÀïÓÐ2²¿·ÖµÄÊý¾Ý£¬C145µÄÊý¾Ý²»±ä£¬»¹ÊÇÓеģ¬C522·ÝµÄÊý¾ÝÊÇ´Ó±íÖÐÈ¡³öC145¿Í»§±àºÅµÄÊý¾Ý£¬ÔÙ°ÑÕâЩÊý¾ÝµÄ¿Í»§± ......

PL/SQL ʵÏÖ»ù±¾µÄËÄÔòÔËËã

CREATE OR REPLACE PACKAGE BODY PACK_RISK_FUNCTION AS
--- 1 ½«·ûºÅÌæ»»³É#ºÅ »òÐí¿ÉÒÔÓÃÕýÔò±í´ïʽ£¬µ«ÊÇÏÓÂé·³»¹ÊÇÖ±½ÓÓÃÌæ»»
FUNCTION CHANGE_OPERATOR(FORMULA VARCHAR2)
RETURN VARCHAR2
AS
V_FORMULA VARCHAR2(100);
BEGIN
V_FORMULA := REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(FORMULA,'(',''), ......

SQL SERVER³£ÓÃÈÕÆÚº¯Êý


1.Ò»¸öÔµÚÒ»ÌìµÄ
Select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
2.±¾ÖܵÄÐÇÆÚÒ»
Select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)
3.Ò»ÄêµÄµÚÒ»Ìì
Select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
4.¼¾¶ÈµÄµÚÒ»Ìì
Select DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)
5.µ±ÌìµÄ°ëÒ¹
Select DATEADD(dd, DAT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ