[VB6]WSAStartup未定義問題

Declare Function WSAStartup Lib "ws2_32.dll" _
(ByVal wVersionRequired As Long, lpWSAData As WSAData) As Long

[MSSQL]ssms工具

http://www.ssmstoolspack.com/

[T-SQL]BEGIN TRAN

用來防止下錯指令 有挽救的機會 BEGIN TRAN ROLLBACK

Web Service傳輸大小限制

   
   
   
 <binding name="ServiceSoap" maxBufferSize="2147483647" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647">   
   
   
  

Update卡住問題

這幾天發現之前寫的程式 在遇到update時會卡住 也不會逾時 後面發現是在主查詢階段 table 被鎖住 需透過WITH (NO LOCK)語法 避免鎖定問題 PS: WITH (NO LOCK)使用上需謹慎

[VBNET]TcpClient的Timeout

 Dim tcpClient As New System.Net.Sockets.TcpClient()  
 Dim result = tcpClient.BeginConnect(serverIP, serverPort, Nothing, Nothing)  
 Dim check As Boolean = result.AsyncWaitHandle.WaitOne(TimeSpan.FromSeconds(5))  

[Windows]內建防火牆開放PING

名稱找ICMPv4-In(IPv4) 啟用