Aylık Arşiv: Ocak 2018

Vb script – MapNetworkDrive

Vb script – MapNetworkDrive

Option Explicit Dim objNetwork, objFSO, objShell Dim strDriveLetter, bForce, bUpdateProfile, strNewName strDriveLetter = "Z:" bForce = "True" bUpdateProfile = "True" strNewName = "\\bıdıbıdı\folder" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objNetwork = CreateObject("Wscript.Network") If (objFSO.DriveExists(strDriveLetter) =...

Sql XML PATH

Sql XML PATH

I had a similar issue when I was trying to join two tables with one-to-many relationships. In SQL 2005 I found that XML PATH method can handle the concatenation of the rows very easily. If there...