Categories
ASP.NET

Console Applications

Console Applications are command-line oriented applications that allow us to read characters from the console, write characters to the console and are executed in the DOS version. Console Applications are written in code and are supported by the System.Console namespace. (Source) Hello World – Console Application

Categories
ASP.NET

Try Catch in .NET

The Try word means “Try to execute this code”. The Catch word means “Catch any errors here”. The ex is a variable, and the type of variable it is an Exception object. Example Public Function Delete(ByVal fileName As String) As Boolean Try File.Delete(String.Format(“{0}\{1}”, ConfigurationManager.AppSettings(“ImageDirectory”), fileName)) Return True Catch ex As Exception Return False End Try […]

Categories
HTML

The correct use of em and en

The em dash (—) is used to indicate a sudden break in thought. The en dash (–) is used to indicate a range of just about anything with numbers, including dates, numbers, game scores, and pages in any sort of document.

Categories
SQL

SELECT RIGHT

RIGHT Returns the part of a character string starting a specified number of integer_expression characters from the right. Example CREATE TABLE #CustomerNames ( CustomerId int, CustomerName varchar(25) ) INSERT INTO #CustomerNames SELECT 1, ‘Bob Johnson’ UNION ALL SELECT 2, ‘Al Riley’ UNION ALL SELECT 3, ‘Mike Henry’ SELECT RIGHT(CustomerName, 5) FROM #CustomerNames Results hnson Riley […]

Categories
SQL

SELECT WHERE ANY

SELECT * FROM VTM_DATA_DETAILS WHERE (PRO_NUMBER = ANY (SELECT pro_no FROM vtm_data_combination WHERE (total_weight = 0) AND (total_charges = 0) AND (total_pieces = 0))) This query is essentially, imagining PRO_NUMBER is a 3 digit number: SELECT * FROM VTM_DATA_DETAILS WHERE (PRO_NUMBER = 097) OR (PRO_NUMBER = 647) OR (PRO_NUMBER = 324)…..etc. Until all PRO_NUMBER are […]

Categories
SQL SQL Server

Changing datatype from varchar to decimal

Another way to go about changing the data type varchar to decimal is to change the varchar to money then convert the money data type to decimal. It may not be the best way to do it but it has work for me.

Categories
SQL

IsNumeric function

The function returns 1 for numeric values, and 0 for non-numeric values. CREATE TABLE #CustomerNames ( CustomerId int, CustomerName varchar(25) ) INSERT INTO #CustomerNames SELECT 1, ‘Bob Johnson’ UNION ALL SELECT 2, ‘Al Riley’ UNION ALL SELECT 3, ‘Mike Henry’ SELECT ISNUMERIC(CustomerID), ISNUMERIC(CustomerName) FROM #CustomerNames Results 1     0 1     0 1     0

Categories
SQL

Convert from varchar to decimal

Here’s a way to convert a VARCHAR to DECIMAL, wrap the CONVERT in a CASE and IsNumeric function to make sure that it doesn’t cause errors when the varchar data is non-numeric DECLARE @test VARCHAR(25) –Numeric SET @test = ‘2.55’ SELECT CONVERT(DECIMAL(3,2), CASE WHEN ISNUMERIC(@test) = 1 THEN @test ELSE ‘0’ END) –Non-Numeric SET @test […]

Categories
SQL Server

SQL Server Datatypes

Data Types sql_variant: Stores values of various SQL Server-supported data types, except text, ntext, and timestamp. timestamp: Stores a database-wide unique number that gets updated every time a row gets updated. uniqueidentifier: Stores a globally unique identifier (GUID). xml: Stores XML data. You can store xml instances in a column or a variable (SQL Server […]

Categories
SQL

Stored Procedures

Creating CREATE PROCEDURE sp_GetRecord @pro_num varchar(10) AS SELECT * FROM DATA_DETAILS WHERE pro_number = @pro_num Executing EXECUTE sp_GetRecord ‘16571565’