System Stored Procedures SQL Server

SQL Server > System Stored Procedures

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

Catalog

• sp_databases
• sp_columns
• sp_tables
• sp_server_info

Extended

• xp_cmdshell

Mail

• sp_send_dbmail

Database Engine

• sp_who
• sp_dbremove
• sp_clean_db_free_space

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

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.

• IsMatch
• Split

System.Text namespaces C#

C# > Text

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

• Regular expression
• StringBuilder

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