SQL Server ÖÇÄܸÐÖª²å¼þSQL Prompt 4(ÓÐͼÓÐÕæÏà)
²»Åç¿ÚË®!Ö±½ÓÉÏͼ
1.Êý¾Ý¿â¶ÔÏó¼ìË÷¹¦ÄÜ
2.T-SQLÓï·¨°ïÖú
3.³£Óú¯Êý°ïÖú(²»¶®ÄñÓï?13×Ô¼ºÁ·Á·°É!)
Download Now
°²×°Á÷³Ì:
1.ÏȰÑÍøÂçßDzæÁË(¶ÏÍø - -!!)
2.°ÑËùÓеÄSQL Server,VS¶¼¹ØÁË,ÔËÐÐSQLPrompt 4.0.exe°²×°
3.°²×°Íê±Ïºó,Í˳öRedGate.SQLPrompt.TrayApp.exe!
4.°ÑSQLPrompt 4 Keygen.exe¿½±´ÖÁ°²×°Ä¿Â¼,´ò¿ª°´1.patch µÃµ½Serial
5.´ò¿ªSQL Server Management Studio Express,´ËʱעÒâ,ÔÚÉÏÃæµÄ²Ëµ¥À¸¶à³öÁËSQL Prompt 4. Oh year!
6. µã»÷SQL Prompt 4 >> Serial Number >> Enter Serial NumberÊäÈëµÚ4²½µÄSerial
7.ÏÂÒ»²½»ñÈ¡×ó±ßÎı¾¿òµÄÒ»´®×Ö·û´®,¸´ÖƵ½SQLPrompt 4 Keygen.exeµÄÎı¾¿òµã»÷3.Gxxxx
8. °ÑSQLPrompt 4 Keygen.exe¼ÆËãºóµÄÖµ¸´ÖƵ½SQL Prompt 4ÖÐ
9.µã»÷Finish
Ïà¹ØÎĵµ£º
µ±Ê¹ÓÃMicrosoft SQL Server 2008 Management Studioʱ£¬ÓÐʱÔÚ±íÉè¼ÆÆ÷ÖжԱíËù×öµÄ¸ü¸ÄÎÞ·¨±£´æ£¬¾ßÌå±íÏÖΪ£ºµã»÷±£´æ°´Å¥ºóµ¯³ö±£´æ¶Ô»°¿òÌáʾ£º²»ÔÊÐí±£´æÐÞ¸Ä(Saving changes is not permitted)£¬µ¯³öµÄ¶Ô»°¿òÖ»ÓÐ2¸ö°´Å¥¿ÉÒÔµã»÷£¬Ò»¸öCancelÒ»¸öSave Text File£¬Ç°Ò»¸ö¾Í²»ÓÃ˵ÁË£¬ºóÒ»¸ö±£´æµÄÎļþ¸ù±¾Ã»ÒâÒ壨¿ÉÒ ......
1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óÐ ......
ÓÐÖ´ÐÐsqlÌõ¼þÓï¾äwhere id in(@²ÎÊý)µÄʱºò£¬Èç¹û´¦Àí²»µ±£¬¾Í»á³öÏÖÎÊÌ⣺
ÈçÏÂÃæÕâ¸ö´æ´¢¹ý³Ì£º
alter proc Web_gettwtwgoldgameserverGoldSell
@ID int
as
declare @twgoldsellID nvarchar(1000)
select @twgoldsellID=twgoldsellID from twgoldgameserver where ID=@ID
set @twgoldsellID=replace(@twgoldsell ......
JavaÊý¾ÝÀàÐÍ
HibernateÊý¾ÝÀàÐÍ
±ê×¼SQLÊý¾ÝÀàÐÍ
(PS:¶ÔÓÚ²»Í¬µÄDB¿ÉÄÜÓÐËù²îÒì)
byte¡¢java.lang.Byte
byte
TINYINT
short¡¢java.lang.Short
short
SMALLINT
int¡¢java.lang.Integer
integer
INGEGER
long¡¢java.lang.Long
long
BIGINT
float¡¢java.lang.Float
float
FLOAT
double¡¢java.lang.Doubl ......