ÇósqlserverѲ¼ìÎĵµ...
ÇósqlserverѲ¼ìÎĵµ...
... »¹ÇëÎÊÏÖÔÚÆóÒµÖ÷Á÷sqlserverÊÇÓÃÄĸö°æ±¾£¿ÊÇ2005Â𣿠Çë¸÷ÎÊ°ïæÌṩһЩÖÐÎĵÄsqlserver¹ÜÀíά»¤Îĵµ£¡ ûÌý˵¹ý,°ï¶¥. ...... ÎÒÁÐÁËÒÔÏÂѲ¼ìÄÚÈÝ£º Êý¾Ý¿âÃû °æ±¾ÐÅÏ¢ Êý¾Ý¿âµÄλÊý Êý¾Ý¿â¿ÉÓÃÐÔ ·¢ÉúËÀËøµÄ´ÎÊý Á¬½Óµ½Êý¾Ý¿âµÄ»á»°ÊýÁ¿ Êý¾Ý¿âÁ¬½ÓÊý Ä¿Ç°Ö´ÐеĻỰÊýÁ¿ ¿ÉÓûº´æ´óС »º´æÃüÖÐÂÊ Ê£Óà´ÅÅÌ¿Õ¼ä ´ÅÅ̶ÁдÇé¿ö Êý¾ÝÎļþ/ÈÕÖ¾Îļþ´óС SQLÓï¾äÏìӦʱ³¤ ==================== ¸÷λ¿´¿´»¹ÓÐʲôÖØÒª¼ì²éÄÚÈÝÐèÒª²¹³ä£¡ ¹Ø×¢ ¸÷λ°ï¸ö棬±ð¶¼¸ø...ѽÒýÓà »¹ÇëÎÊÏÖÔÚÆóÒµÖ÷Á÷sqlserverÊÇÓÃÄĸö°æ±¾£¿ÊÇ2005Â𣿠Çë¸÷ÎÊ°ïæÌṩһЩÖÐÎĵÄsqlserver¹ÜÀíά»¤Îĵµ£¡ 2005°É ллlsµÄ¡£µÚÒ»ÌìÃþsqlserver£¬¾Í±»ÒªÇóдѲ¼ìÎĵµ¡£ÎÒÁ¬sqlserverÊÇʲôÑù¶¼²»ÖªµÀ¡£ ´óÎڹ꣬¾ÍÊÇÐèҪһЩ¶¨ÆÚ¼ì²é¿Í»§sqlserverÊý¾Ý¿âµÄÖ¸±ê¡£ ¸÷λÓбȽϺõÄ2005ÖÐÎĹÜÀíά»¤ÎĵµÍƼöÏÂÂ𣿠Åå·þ¡£fredrickhu
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿ ......
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 ......
Ö÷¼üÊÇuniqueidentifierÀàÐÍ£¬Ã»ÓÐ×ÔÔö×ֶΡ£¡£ ÕâÑùÓ¦¸ÃÔõô»ñÈ¡£¿ L@_@K SQL code: SELECT ISNULL(SCOPE_IDENTITY(), -1) AS [SCOPE_IDENTITY] °´Ê±¼äÅÅÐò »ò guid²»Òª×Ô¶¯Éú³É ......
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 ......
ÒÑÖª sql serverÖÐ $server="se"; $username="us"; $password="pa"; $datebase="ds"; 1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ ......