If you are trying to insert SSIS variable values into a SQL table here is one way of doing this: 1. Create “Execute SQL Task”……
Here are few methods: 1. CMD command: Open CMD. Go to the directory in question (cd C:\Directory) and type the below: dir /c /s >……
Each query we execute has an execution plan that is cashed. Once cashed if we run the query again it will return the results quicker……
C# escape characters list: \’ – single quote, needed for character literals \” – double quote, needed for string literals \\ – backslash \0 –……
Here is an example of a vbscript that will show you volume size info for C. It will display the following info: – Computer Name/hostname……
If you are trying to find a table or a view based on a column name here is a piece of code that will be……
Here is a list of LEGAL retail copies of Windows 7, 8, 8.1 and 10 that you can download. None of those come with a……
Here is a list of LEGAL retail copies of Windows 7, 8, 8.1 and 10 that you can download. None of those come with a……
If you want to extract numbers all the numbers (8702000118) from the following string “BlaBla Hill is – 870-200-0118 abx” just use the code below:……
This will teach you how to format a phone number from 1234567890 to (123) 456-7890. SQL Server 2008: SELECT [Phone] AS [Phone Number] , ‘(‘+(SUBSTRING(Phone,1,3)+’)……