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

ÇósqlserverѲ¼ìÎĵµ...

ÇósqlserverѲ¼ìÎĵµ...
...

»¹ÇëÎÊÏÖÔÚÆóÒµÖ÷Á÷sqlserverÊÇÓÃÄĸö°æ±¾£¿ÊÇ2005Âð£¿
Çë¸÷ÎÊ°ïæÌṩһЩÖÐÎĵÄsqlserver¹ÜÀíά»¤Îĵµ£¡

ûÌý˵¹ý,°ï¶¥.

......

ÎÒÁÐÁËÒÔÏÂѲ¼ìÄÚÈÝ£º
Êý¾Ý¿âÃû
°æ±¾ÐÅÏ¢
Êý¾Ý¿âµÄλÊý
Êý¾Ý¿â¿ÉÓÃÐÔ
·¢ÉúËÀËøµÄ´ÎÊý
Á¬½Óµ½Êý¾Ý¿âµÄ»á»°ÊýÁ¿
Êý¾Ý¿âÁ¬½ÓÊý
Ä¿Ç°Ö´ÐеĻỰÊýÁ¿
¿ÉÓûº´æ´óС
»º´æÃüÖÐÂÊ
Ê£Óà´ÅÅÌ¿Õ¼ä
´ÅÅ̶ÁдÇé¿ö
Êý¾ÝÎļþ/ÈÕÖ¾Îļþ´óС
SQLÓï¾äÏìӦʱ³¤
====================
¸÷λ¿´¿´»¹ÓÐʲôÖØÒª¼ì²éÄÚÈÝÐèÒª²¹³ä£¡

¹Ø×¢

¸÷λ°ï¸ö棬±ð¶¼¸ø...ѽ



ÒýÓÃ
»¹ÇëÎÊÏÖÔÚÆóÒµÖ÷Á÷sqlserverÊÇÓÃÄĸö°æ±¾£¿ÊÇ2005Âð£¿
Çë¸÷ÎÊ°ïæÌṩһЩÖÐÎĵÄsqlserver¹ÜÀíά»¤Îĵµ£¡



2005°É

ллlsµÄ¡£µÚÒ»ÌìÃþsqlserver£¬¾Í±»ÒªÇóдѲ¼ìÎĵµ¡£ÎÒÁ¬sqlserverÊÇʲôÑù¶¼²»ÖªµÀ¡£

´óÎڹ꣬¾ÍÊÇÐèҪһЩ¶¨ÆÚ¼ì²é¿Í»§sqlserverÊý¾Ý¿âµÄÖ¸±ê¡£

¸÷λÓбȽϺõÄ2005ÖÐÎĹÜÀíά»¤ÎĵµÍƼöÏÂÂð£¿

Åå·þ¡£fredrickhu


Ïà¹ØÎÊ´ð£º

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

Ôõô»ñÈ¡sqlserver×îºó²åÈëÐÐÄÚµÄ×ֶΣ¿

Ö÷¼üÊÇuniqueidentifierÀàÐÍ£¬Ã»ÓÐ×ÔÔö×ֶΡ£¡£

ÕâÑùÓ¦¸ÃÔõô»ñÈ¡£¿


L@_@K
SQL code:
SELECT ISNULL(SCOPE_IDENTITY(), -1) AS [SCOPE_IDENTITY]

°´Ê±¼äÅÅÐò
»ò
guid²»Òª×Ô¶¯Éú³É
......

sqlserver ×Ô¶¨Ò庯Êýreturn ÎÊÌâ

SQL code:
create function subDepartment(@id varchar(36),@flag int)
returns @re table(subid varchar(36))
as
begin
insert @re select deli_id from departmentlink where deli_type=32
a ......

php+sqlserver È¡¼Ç¼ʱµÃµ½idµÄÎÊÌ⣬ÔÚÏßµÈ

ÒÑÖª sql serverÖÐ
$server="se";
$username="us";
$password="pa";
$datebase="ds";

1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ