ÇáËɵ¼Èëµ¼³öSQLµÇ¼ÕʺÅ
1¡¢ÔÚÐèµ¼³öµÇ¼ÕʺŵÄSQL·þÎñÆ÷ÉÏÖ´ÐÐÒÔϲéѯÓï¾ä£º
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
@binvalue varbinary(256),
@hexvalue varchar(256) OUTPUT
AS
DECLARE @charvalue varchar(256)
DECLARE @i int
DECLARE @length int
DECLARE @hexstring char(16)
SELECT @charvalue = '0x'
SELECT @i = 1
SELECT @length = DATALENGTH (@binvalue)
SELECT @hexstring = '0123456789ABCDEF'
WHILE (@i
Ïà¹ØÎĵµ£º
index.jsp
<%@ page language="java" import="java.sql.*" import="java.lang.*" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%!
& ......
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
ÔÚSQL Server 2005Êý¾Ý¿âÖУ¬Í¨¹ýÐÂÔöµÄService Broker¿ÉÒÔʵÏÖÒì²½´¥·¢Æ÷µÄ´¦Àí¹¦ÄÜ¡£±¾ÎÄÌṩһÖÖʹÓÃService BrokerʵÏÖµÄͨÓÃÒì²½´¥·¢Æ÷·½·¨¡£
ÔÚ±¾Õâ¸ö·½·¨ÖУ¬Í¨¹ýService Broker¹¹ÔìÒì²½´¥·¢Æ÷´¦Àí¼Ü¹¹£¬¶ÔÓÚҪʹÓÃÕâÖּܹ¹µÄ±í£¬Ö»ÐèÒª´´½¨ÏàÓ¦µÄ´¥·¢Æ÷¼°´¦Àí´¥·¢Æ÷ÖÐÊý¾ÝµÄ´æ´¢¹ý³Ì£¬²¢ÇÒÔÚÒì²½´¥·¢Æ÷¼Ü¹¹ÖÐµÇ¼Ç ......
ϵͳÊý¾Ý¿â
ϵͳÊý¾Ý¿âºÜÖØÒª£¬´ó¶àÊýʱºò²»Ó¦ÐÞ¸ÄËüÃÇ¡£Î¨Ò»µÄÀýÍâÊÇmodelÊý¾Ý¿â£¬ËüÄܹ»ÈÃÓû§²¿Êð¸ü¸Ä£¨Èç´æ´¢¹ý³Ì£©µ½ÈκÎд´½¨µÄÊý¾ÝÂÊÖС£
1 ResourceÊý¾Ý¿â
¸ÃÊý¾Ý¿â°üº¬SQL Server Õý³£ÔËÐÐËùÐèµÄÖØÒª±í£¬ÔªÊý¾ÝºÍ´æ´¢¹ý³Ì£¬ËüÃÇÊÇÖ»¶ÁµÄ¡£Ëü²»°üº¬ÓйØÓû§µÄʵÀý»òÊý¾Ý¿âµÄÈκÎÐÅÏ¢£¬ÒòΪËüÖ»Êǰ²×°ÐµIJ¹¶¡³Ì ......