Over the years extracting the filename from a full path has always been a pain for me. Working with C#, I discovered a one line, easy to use, solution. FileName = FileName.Split(‘\\’)[FileName.Split(‘\\’).Count() – 1]; Filename = “c:\TextFile.txt” Will return: “TextFile.txt” And FileName = (FileName.Split(‘\\’)[FileName.Split(‘\\’).Count() – 1]).Split(‘,’); Filename = “c:\TextFile.txt” Will return: “TextFile”
The first way is to create a temporary table and insert values into it. DECLARE @declareTable TABLE (seq int, name VARCHAR(5) ) ; INSERT INTO @declareTable (seq,name) values (1,’one’), (2,’two’), (3,’three’) select * from @declareTable as dt; The second way is to create the values inside the select statement. select * from (values (1,’one’), (2,’two’),… Read More »
Here is an easy way to get CPU information from the command line: wmic cpu get /format:list Below is examples of some of the information provided from the command: Description L2 Cache L3 Cache Max Clock Speed Name Number of Cores
The easiest way to convert FoxPro to Microsoft SQL Server is to copy the FoxPro file to a CSV and use the SQL Server Import and Export Wizard. In FoxPro use NameOfFile (or ?) copy to NameOfFile type csv This will give you a clean CSV with a header line.
Click Project -> Mange NuGet Packages Choose NuGet in Package Source. Search for Log4Net Choose Log4Net and Install Add one line to Project->Properties->AssemblyInfo.cs. This line will path to the Log4Net.xml config file. [assembly: log4net.Config.XmlConfigurator(ConfigFile = “log4net.xml”, Watch = true)] Add new xml item to the project called log4net.xml (or whatever you called it above) Here… Read More »