how-to scroll a page after page load based on element id

<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
        <span class="rem">/* START --- scroll till anchor */</span>
            (function($) {
                 $.fn.goTo = function() {
                      <span class="kwrd">var</span> top_menu_height=$(<span class="str">'#div_menu_header'</span>).height() + 5 ;
                      <span class="rem">//alert ( 'top_menu_height is:' + top_menu_height );</span>
                      $(<span class="str">'html, body'</span>).animate({
                            scrollTop: (-1)*top_menu_height + $(<span class="kwrd">this</span>).offset().top + <span class="str">'px'</span>
                      }, 500);
                      <span class="kwrd">return</span> <span class="kwrd">this</span>; <span class="rem">// for chaining...</span>
                 }
            })(jQuery);

            $(document).ready(function(){

              <span class="kwrd">var</span> url = document.URL, idx = url.indexOf(<span class="str">"#"</span>) ;
              <span class="kwrd">var</span> hash = idx != -1 ? url.substring(idx+1) : <span class="str">""</span>;

              $(window).load(function(){
                 <span class="rem">// Remove the # from the hash, as different browsers may or may not include it</span>
                 <span class="kwrd">var</span> anchor_to_scroll_to = location.hash.replace(<span class="str">'#'</span>,<span class="str">''</span>);
                 <span class="kwrd">if</span> ( anchor_to_scroll_to != <span class="str">''</span> ) {
                     anchor_to_scroll_to = <span class="str">'#'</span> + anchor_to_scroll_to ;
                     $(anchor_to_scroll_to).goTo();
                 }
                });
            });
        <span class="rem">/* STOP --- scroll till anchror */</span></pre>

how-to get sql server 2008 tables' and columns' meta data

-- get columns meta data 

SELECT top 100000

 INFORMATION_SCHEMA.COLUMNS.TABLE_CATALOG              AS 'DataBaseName' 

,INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA               AS 'SchemaName'

,SysObjects.NAME                                       AS 'TableName'

,sys.all_columns.NAME                                  AS 'ColumnName'

,INFORMATION_SCHEMA.COLUMNS.ORDINAL_POSITION           AS 'OrdinalPosition'

,sys.types.name                                        AS 'DataType' 

,sys.all_columns.is_nullable                           AS 'IsNullable' 

,sys.all_columns.is_identity                           AS 'IsPrimaryKey'  

,sys.all_columns.max_length                            AS 'MaxLength' 

,sys.all_columns.is_computed                           AS 'IsComputed' 

,syscomments.text                                      AS 'DefaultValue'

FROM dbo.sysobjects  

INNER JOIN sys.all_columns 

   ON ( SysObjects.id = sys.all_columns.object_id )

INNER JOIN sys.types 

   on ( sys.types.system_type_id = sys.all_columns.system_type_id )

LEFT JOIN syscomments  

   on ( SysObjects.id = syscomments.id ) 

-- LEFT JOIN sys.tables stb on sc.object_id = SysObjects.parent_obj

LEFT JOIN INFORMATION_SCHEMA.COLUMNS  

on  (     INFORMATION_SCHEMA.COLUMNS.TABLE_NAME=SysObjects.NAME 

      and sys.all_columns.NAME = INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME ) 

--LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id  

--inner join sys.types st

--on sc.xtype = st.system_type_id

WHERE 1=1 

AND SysObjects.xtype = 'U'  

and sys.types.name <> 'sysname' --to a bug with this one occurs if enabled 

and sys.all_columns.is_computed = 0 --todo a bug with this one occurs if enabled 

-- and SysObjects.name = @TableName --uncomment this line while debugging

-- AND sys.all_columns.name LIKE '%TABLE_NAME_TO_SRCH%'

ORDER BY DatabaseName , SchemaName , TableName , INFORMATION_SCHEMA.COLUMNS.ORDINAL_POSITION

; 

oracle create table template

-- @SCHEMA_NAME define nice date and number formatting
-- enable printing
set serveroutput on format wrapped;
set feedback off ;
Begin
  Dbms_Output.Put_Line('START RUNNING script : /path/to/sql/script.sql');
  Dbms_Output.Put_Line('SETTING YYYY-MM-DD HH24:MI:SS date format and Finnish numeric chars formatting');
  Dbms_Output.Put_Line('START CREATING THE TABLE_NAME TABLE');
  Dbms_Output.Put_Line('------------------------------------------------------');
End;
/

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
Alter Session Set Nls_Numeric_Characters=', ';
set feedback on ;

/*
Run all by : Ctrl + A, F5 in Sql Developer
DROP THE TABLE IF IT EXISTS
*/
declare
   c int;
begin
   select count(*) into c from user_tables where table_name = upper('TABLE_NAME');

   if c = 1 then
      execute immediate 'DROP TABLE TABLE_NAME';

   end if;
end;
/
--------------------------------------------------------
--  DDL for Table TABLE_NAME
--------------------------------------------------------
CREATE TABLE "TABLE_NAME" (
  "TABLE_NAME_ID"         NUMBER (15,0) NOT NULL
 , "DWRUNTIME" DATE NOT NULL ENABLE
 , CONSTRAINT "TABLE_NAME_RECEIPT_NUMBER_PK" PRIMARY KEY ("TABLE_NAME_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TABLE_SPACE"  ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS NOLOGGING
  STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TABLE_SPACE"
  ;

create oracle view template

-- @SCHEMA_NAME define nice date and number formatting
-- enable printing
set serveroutput on format wrapped;
set feedback off ;
Begin
  Dbms_Output.Put_Line('START RUNNING script : /path/to/sql/script.sql');
  Dbms_Output.Put_Line('SETTING YYYY-MM-DD HH24:MI:SS date format and Finnish numeric chars formatting');
  Dbms_Output.Put_Line('START CREATING THE VIEW_NAME VIEW');
  Dbms_Output.Put_Line('------------------------------------------------------');
End;
/

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
Alter Session Set Nls_Numeric_Characters=', ';
set feedback on ;

Create or replace View SCHEMA_NAME.VIEW_NAME
As
SELECT ' BOO' FROM DUAL ;

;
/
Set Feedback Off ;
Begin
  Dbms_Output.Put_Line('GRANTING THE SELECT TO THE VIEW_NAME VIEW TO THE TO SCHEMA_NAME ACCOUNT');
  Dbms_Output.Put_Line('------------------------------------------------------');
End ;
/

Grant Select On SCHEMA_NAME.VIEW_NAME To SCHEMA_NAME
;
/

Set Feedback Off ;
-- SELECT  AS "ACTION_PERFORMED" FROM DUAL ;
begin
  Dbms_Output.Put_Line('CHECKING THAT THE VIEW VIEW_NAME HAS BEEN CREATED');
  Dbms_Output.Put_Line('------------------------------------------------------');
End;
/

Select View_Name From All_Views
Where 1=1
AND VIEW_NAME = 'VIEW_NAME'
;

Set Feedback Off ;
-- SELECT  AS "ACTION_PERFORMED" FROM DUAL ;
Begin
  Dbms_Output.Put_Line('CHECKING the data of the VIEW_NAME VIEW');
  Dbms_Output.Put_Line('------------------------------------------------------');
End;
/

Select * From SCHEMA_NAME.VIEW_NAME
;

Set Feedback Off ;
Begin
  Dbms_Output.Put_Line('STOP RUNNING FILE : /path/to/sql/script.sql');
End;
/
Set Feedback On ;