Search This Blog

Friday, November 8, 2013

System Stored Procedures SQL Server

SQL Server > System Stored Procedures

Using system stored procedures you can perform many administrative and informational activities.

Catalog
Extended
Mail
Database Engine




sp_databases SQL Server

SQL Server > System Stored Procedures > sp_databases

sp_databases lists databases that reside in an instance of the SQL Server Database .

Example:

USE master;
GO
EXEC sp_databases;

DATABASE_NAME           DATABASE_SIZE               REMARKS
action_plan        4160       NULL
master  4864       NULL
model   2624       NULL
msdb     13312    NULL
tempdb                2560       NULL





Thursday, November 7, 2013

Regular expression C#

C# > Text > Regular expression

A regular expression is a pattern. The engine try to find matches in input text using this pattern.
A pattern contains character literals, operators and constructs.




System.Text namespaces C#

C# > Text

Text in  C# defines types for character encoding and string manipulation





Regex IsMatch method

C# > Text > RegularExpressions > IsMatch

Regex IsMatch method indicates whether the regular expression specified finds a match in a specified input string.

Example:

string[] partNumbers = { "1298-6736","343434" };
Regex rgx = new Regex(@"^[a-zA-Z0-9-]*-[a-zA-Z0-9]*$");

foreach (string partNumber in partNumbers)
   if (rgx.IsMatch(partNumber))
     MessageBox.Show  (partNumber);

Pattern

^                      begin the match at the beginning of the line.
[a-zA-Z0-9]    match a single alphabetic character (a through z or A through Z) or numeric character.
-                      match a hyphen
*                      must be zero or more of these characters
$                      end the match at the end of the line





Convert color to html color C#

C# > Color

ColorTranslator.ToHtml translates the specified Color structure to an HTML string color.

Example:

Color cl = Color.FromArgb(0, 99, 148);
string htmlColor = ColorTranslator.ToHtml(cl);







Get Oracle Version

Oracle > Version

V$VERSION displays version numbers of core library components in the Oracle Database.

Example:

select * from v$version

Result:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production