TSQL Determine Table Size
Determine the size of database tables in a MSSQL Server Database. SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
PL/SQL Determine Table Size
Original Source Link COLUMN TABLE_NAME FORMAT A32 COLUMN OBJECT_NAME FORMAT A32 COLUMN OWNER FORMAT A10 SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE …
Convert RTF data to unmarked up string
static public string ConvertToText(string rtf) { using(RichTextBox rtb = new RichTextBox()) { rtb.Rtf = rtf; return rtb.Text; } } Catch ArgumentException …
TSQL is decimal an INT
Determine if a decimal number can be converted to an INT without any loss of precision. Check if either of the rightmost two digits are non-zero substring(convert(varchar(10), a.DebitAmount), len(convert(varchar(10), a.DebitAmount)) …