[SQL Server] µ¼³ö±í½á¹¹(Êý¾Ý×Öµä)
-- Êý¾Ý×Öµä
SELECT
(case when a.colorder=1 then d.name else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) ±êʶ,
(case when (SELECT count(*)
from sysobjects
WHERE (name in
(SELECT name
from sysindexes
WHERE (id = a.id) AND (indid in
(SELECT indid
from sysindexkeys
WHERE (id = a.id) AND (colid in
(SELECT colid
from syscolumns
&nb
Ïà¹ØÎĵµ£º
˵Ã÷£ºÒÔÏÂÎåÊ®¸öÓï¾ä¶¼°´ÕÕ²âÊÔÊý¾Ý½øÐйý²âÊÔ£¬×îºÃÿ´ÎÖ»µ¥¶ÀÔËÐÐÒ»¸öÓï¾ä¡£
ÎÊÌâ¼°ÃèÊö£º
--1.ѧÉú±í
Student(S#,Sname,Sage,Ssex) --S# ѧÉú±àºÅ,Sname ѧÉúÐÕÃû,Sage ³öÉúÄêÔÂ,Ssex ѧÉúÐÔ±ð
--2.¿Î³Ì±í
Course(C#,Cname,T#) --C# --¿Î³Ì±àºÅ,Cname ¿Î³ÌÃû³Æ,T# ½Ìʦ±àºÅ
--3.½Ìʦ±í
Teacher(T#,Tname) -- ......
ͼ±í
ͼ±í(ÓֳƹØÏµÍ¼)ÊÇSQL ServerÖÐÒ»ÀàÌØÊâµÄÊý¾Ý¿â¶ÔÏó£¬ËüÌṩ¸øÓû§Ö±¹ÛµØ¹ÜÀíÊý¾Ý¿â±íµÄ·½·¨¡£Í¨¹ýͼ±í£¬Óû§¿ÉÒÔÖ±¹ÛµØ´´½¨¡¢±à¼Êý¾Ý¿â±íÖ®¼äµÄ¹ØÏµ£¬Ò²¿ÉÒÔ±à¼±í¼°ÆäÁеÄÊôÐÔ¡£ÀûÓÃÆóÒµ¹ÜÀíÆ÷´´½¨Í¼±íµÄ¾ßÌå²½ÖèÈçÏ£º
(1)ÔÚÆóÒµ¹ÜÀíÆ÷ÖУ¬Õ¹¿ªÖ¸¶¨µÄ·þÎñÆ÷ºÍÊý¾Ý¿â£¬´ò¿ªÒª½¨Á¢µÄͼ±íËùÔÚµÄÊý¾Ý¿â£¬ÓÒ»÷ͼ±íÍ ......
1Replaceº¯Êý
ÔÚSQL SERVER 2000ÖÐÓÐÒ»¸öÐÅÏ¢±í£¬´æ·ÅÐÂÎÅÐÅÏ¢£¬ÏÖÔÚ¿Í»§ÏëÅúÁ¿¸üÐÂÕâ¸ö×Ö¶ÎÖеÄijЩÎÄ×Ö£¬Ì滻ΪÆäËûÎÄ×Ö¡£
½â¾ö·½·¨£ºÀûÓÃreplaceº¯Êý
update detail set content=replace(content,'ÔÎÄ×Ö','Ìæ»»ºóÎÄ×Ö') where Ìõ¼þ ......
/*****************************
³£ÓÃÈÕÆÚº¯Êý
*****************************/
use studentInfo
--ÏòÊý¾Ý¿âÖвåÈëÈÕÆÚµÄ³£¼û¸ñʽ£ºÈç²åÈë2010Äê10ÔÂ3ÈÕÕâ¸öÈÕÆÚ
--ÆäÖÐtb_dateΪһ¸ö²âÊÔÓÃµÄ±í£¬ÀïÃæ¾ÍÒ»¸ö×Ö¶Îtime£¬ÎªdatetimeÀàÐÍ
insert tb_date values('2010.10.3')
insert tb_date values('2010-10-3 12:14:35 ......
sql CHARINDEXº¯Êý
SQL Server 2010-01-15 09:01:15 ÔĶÁ888 ÆÀÂÛ0 ×ֺţº´óÖÐС
CHARINDEXº¯Êý·µ»Ø×Ö·û»òÕß×Ö·û´®ÔÚÁíÒ»¸ö×Ö·û´®ÖÐµÄÆðʼλÖá£CHARINDEXº¯Êýµ÷Ó÷½·¨ÈçÏ£º
CHARINDEX ( expression1 , expression2 [ , start_location ] )
  ......