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

SQLServer 2005 ³£Óõĺ¯Êý

×Ö·û´®º¯Êý£º
¡ñ¡¡ASCII('a')=97---·µ»Ø×Öĸa¶ÔÓ¦µÄASCIIÂë
¡ñ¡¡CHAR('48')=0---·µ»Ø48Õâ¸öASCIIÂë¶ÔÓ¦µÄ×Ö·û
¡ñ¡¡LCASE('ABcdE')="abced" »ò LOWER('ABcdE')="abced"£¨½«¸ø¶¨×Ö·û´®×ªÎªÐ¡Ð´£©
¡ñ¡¡UCASE('ABcdE')="ABCDE" »ò UPPER('ABcdE')="ABCDE"£¨½«¸ø¶¨×Ö·û´®×ªÎª´óд£©
¡ñ¡¡LTRIM('  fgf gh  ')="fgf gh  "£¨È¥µô¸ø¶¨×Ö·û´®×ó±ßµÄ¿Õ¸ñ£©
¡ñ¡¡RTRIM('  fgf gh  ')="  fgf gh"£¨È¥µô¸ø¶¨×Ö·û´®ÓұߵĿոñ£©
¡ñ¡¡LEN('sde123-TRE')=10£¨·µ»Ø¸ø¶¨×Ö·û´®µÄ³¤¶È£©
¡ñ¡¡LEFT('sde123-TRE',5)="sde12"£¨´Ó¸ø¶¨×Ö·û´®×ó±ß¿ªÊ¼£¬È¡Ö¸¶¨³¤¶ÈµÄ×Ö·û£©
¡ñ¡¡RIGHT('sde123-TRE',4)="-TRE"£¨´Ó¸ø¶¨×Ö·û´®Óұ߿ªÊ¼£¬È¡Ö¸¶¨³¤¶ÈµÄ×Ö·û£©
¡ñ¡¡SUBSTRING('sde123-TRE',3,6)="e123-T"£¨´Ó¸ø¶¨×Ö·û´®µÄÖ¸¶¨Î»ÖÿªÊ¼£¬È¡Ö¸¶¨³¤¶ÈµÄ×Ö·û£©
¡ñ¡¡CHARINDEX('23-','sde123-TRE')=5£¨·µ»ØµÚÒ»¸ö×Ö·û´®ÔÚµÚ¶þ¸ö×Ö·û´®ÖгöÏÖµÄÊ×λÖã¬Èç¹ûδ³öÏÖÔò·µ»Ø0£©
      £¨×¢Ò⣺CHARINDEX('23T','sde123-TRE')=0£©        
      £¨×¢Ò⣺CHARINDEX('TRE','DFTRE345TREDGS')=3¶øCHARINDEX('TRE','DFTRE345TREDGS',4)=9£¬ÒòΪµÚÈý¸ö²ÎÊýδдÔò²éÕÒ´ÓµÚÒ»¸ö×Ö·û¿ªÊ¼£»·ñÔò´ÓµÚÈý¸ö²ÎÊýÖ¸¶¨µÄλÖÿªÊ¼²éÕÒ£»µÚ¶þ¸öÀý×ÓÊÇ´ÓµÚ4λ¿ªÊ¼²éÕÒ£¬ÕÒµ½µÄµÚÒ»¸ö"TRE"λÓÚµÚ9룩
¡ñ¡¡REVERSE('SDF463')="364FDS"£¨½«¸ø¶¨×Ö·û´®·´×ª£©
¡ñ¡¡REPLACE('abcdefghicde','cde','xx')="abxxfghixx"£¨ÓõÚÈý¸ö×Ö·û´®Ìæ»»µÚÒ»¸ö×Ö·û´®ÖеÄËùÓеڶþ¸ö×Ö·û´®£©
¡ñ¡¡STR(123.457,5,2)="123.46"£¨½«Êý×ÖתΪ×Ö·û´®£¬µÚÒ»¸ö²ÎÊýÊÇҪת»»µÄÊý×Ö£¬µÚ¶þ¸ö²ÎÊýÊÇת»»ºóµÄ×Ö·û´®µÄ×î´ó³¤¶È£¬µÚÈý¸ö²ÎÊýÖ¸¶¨±£Áô¼¸Î»Ð¡Êý£¬Çë×¢Ò⣬ÕâÖÖת»»ÊÇËÄÉáÎåÈëµÄ£©
      £¨×¢Ò⣺STR(123.457,2,2)="**"------ÒòΪ5СÓÚ123.457µÄ³¤¶È£©
¡ñ¡¡STUFF('I AM NIMMY,WEI COME!',6,5,'RWM')="I AM RWM,WEI COME!"£¨½«¸ø¶¨×Ö·û´®ÖеÄijһ²¿·Öɾ³ý²¢²åÈëÖ¸¶¨µÄ×Ö·û´®£¬µÚÒ»¸ö²ÎÊýÊÇ´ý²Ù×÷µÄ×Ö·û´®£»µÚ¶þ¸ö²ÎÊýÊÇҪɾ³ý²¿·ÖµÄÆðʼλÖ㻵ÚÈý¸ö²ÎÊýÊÇҪɾ³ý²¿·ÖµÄ³¤¶È£»µÚËĸö²ÎÊýÊÇÒª²åÈëµÄ×Ö·û´®£©
      £¨×¢ÒâËüºÍREPLACEµÄÇø±ð£ºSTUFF('ERTY23TY',3,2,'K')='ERK23TY"¶øREPLACE('ERTY23TY','TY','K')="ERK23K"£©
¡ñ¡¡REPLICATE('


Ïà¹ØÎĵµ£º

SQLSERVERÐÞ¸´Ð¡ÖªÊ¶

ÔÚÓëÊý¾Ý¿â´ò½»µÀµÄ¹¤×÷ÖÐʱ³£»áÅöµ½Ò»Ð©Êý¾Ý¿âµÄ´íÎó£¬Õâ¾ÍÉæ¼°µ½ÁËÐÞ¸´µÄ¹ý³Ì£¬ÒÔÏÂ֪ʶµã¶¼ÊÇ´ÓÍøÉÏÊÕ¼¯¶øÀ´:
1¡¢dbcc checkdb
Õâ¸öÃüÁî¿ÖÅÂÊÇÎÒÃÇ×î³£ÓõÄÁË£¬´ø¼ì²éºÍÐÞ¸´¹¦ÄÜ
Óï·¨¸ñʽ£º
DBCC CHECKDB
[
[ ( database_name | database_id | 0
[ , NOINDEX
| , { REPAIR_ALLOW_DATA_LOS ......

ʹÓÃSqlserverÊÂÎñ·¢²¼ÊµÏÖÊý¾Ýͬ²½

      ÊÂÎñµÄ¹¦ÄÜÔÚsqlserverÖÐÓÉÀ´ÒѾã¬ÒòΪ×î½üÔÚ×öÒ»¸öÊý¾Ýͬ²½·½°¸£¬ËùÒÔÓлú»áÔÙ´ÎÑо¿Ò»ÏÂËüÒÔ¼°¿ìÕյȣ¬·¢ÏÖ»¹ÊÇÓкܶ಻´íµÄ¹¦Äܺ͸ĽøµÄ¡£ÕâÀïÒÔsqlserver2008µÄÊÂÎñ·¢²¼¹¦ÄÜΪÀý£¬¶Ô·¢²¼¶©Ôĵķ½Ê½¼òÒª½éÉÜһϲÙ×÷Á÷³Ì£¬Ò»·½Ãæ×ö¸ö×ܽᱸ·Ý£¬Ò»·½ÃæÓë´ó¼Ò½øÐÐһϷÖÏíºÍ½»Á÷¡£·Ñ»°¾Í² ......

ͨÓõÄSqlServer²Ù¿ØÀà

 using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;


public class CommandInfo
{
public string CommandText;
public SqlPa ......

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬»úËã»úÅ ......

sqlserver ÆÚÖп¼ÊÔÌâ

 create database DB
use DB
--רҵ±í
create table major
(spno char(5) not null primary key,
 spname varchar(20) not null,
 pno char(2) )
--ѧÉú±í
create table student
(sno char(7) not null primary key,
 sname varchar(20) not null,
 ssex char(2) not null,
 sag ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ