Al Programming

SQL Server > Built-in Functions   > PATINDEX PATINDEX  returns the start position of pattern occurrence in an expression. Warning...

SQL Server > Built-in Functions   > MAX MAX returns the maximum value. Warning! Null values are ignored! Example CREATE T...

C#  > Data > OLE DB > Access - all tables Use GetSchema to get all tables in MS Access Example OleDbConnection con = new ...

SQL Server > Built-in Functions   >    RTRIM RTRIM returns a sting after truncate trailing blanks. Example: DECLARE @str var...

SQL Server > Built-in Functions   >    LTRIM LTRIM returns a sting after removes leading blanks. Example: DECLARE @str ...

SQL Server > Built-in Functions   > AVG  > Without zerous   Example to calculate average without zero create table #sale ...

C# > System.Data    > DataGridView > Delete rows How to delete rows from DataGridView without delete rows from DataTable? Solu...