Senin, 15 Februari 2016

C:\Windows\System32\odbcad32.exe --> 64bit
C:\Windows\SysWOW64\odbcad32.exe --> 32bit

Sabtu, 06 Februari 2016

SQL Server How To Linked Server

exec sp_addlinkedserver '10.10.10.1';
exec sp_addlinkedsrvlogin '10.10.10.1', 'FALSE', NULL, 'username1', 'password1';

Senin, 26 Mei 2014

How To List All Dates Between Two Dates

declare @StartDate smalldatetime, @EndDate smalldatetime

set @StartDate = '2013-12-30'
set @EndDate = '2014-02-02'

select dateadd(day,number+1,@StartDate) as DateId
from master..spt_values
where type = 'P' and dateadd(day,number+1,@StartDate) < @EndDate
Output :
DateId
2013-12-31 00:00:00
2014-01-01 00:00:00
2014-01-02 00:00:00
2014-01-03 00:00:00
2014-01-04 00:00:00
2014-01-05 00:00:00
2014-01-06 00:00:00
2014-01-07 00:00:00
2014-01-08 00:00:00
2014-01-09 00:00:00
2014-01-10 00:00:00
2014-01-11 00:00:00
2014-01-12 00:00:00
2014-01-13 00:00:00
2014-01-14 00:00:00
2014-01-15 00:00:00
2014-01-16 00:00:00
2014-01-17 00:00:00
2014-01-18 00:00:00
2014-01-19 00:00:00
2014-01-20 00:00:00
2014-01-21 00:00:00
2014-01-22 00:00:00
2014-01-23 00:00:00
2014-01-24 00:00:00
2014-01-25 00:00:00
2014-01-26 00:00:00
2014-01-27 00:00:00
2014-01-28 00:00:00
2014-01-29 00:00:00
2014-01-30 00:00:00
2014-01-31 00:00:00
2014-02-01 00:00:00

Rabu, 21 Mei 2014

See Log Start-Up and Shutdown Times in WIN XP & WIN 7

Silahkan... WIN : http://superuser.com/questions/315836/windows-xp-is-it-possible-to-log-startup-and-shutdown-times-in-the-system-event UNIX : http://askubuntu.com/questions/37132/how-do-i-find-the-last-logged-system-boot-and-shutdown-times

Kamis, 16 Januari 2014

How To Find Columns In All Tables Sybase / ENIQ Database

Just Run Query
-- @denjaka
select 
  b.name as tablename
  , a.name as columnname
from dbo.syscolumns a 
join dbo.sysobjects b 
  on (a.id = b.id) 
where 
  b.type='U' 
  and a.name like '%BSCGPRS%' --> column name

Rabu, 14 Agustus 2013

Bookmark URL

http://codex.wordpress.org/Changing_The_Site_URL

Minggu, 04 Agustus 2013

Notepad++




Notepad++ is a free source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL Licence.

Based on a powerful editing component Scintilla, Notepad++ is written in C++ and uses pure Win32 API and STL which ensures a higher execution speed and smaller program size. By optimizing as many routines as possible without losing user friendliness, Notepad++ is trying to reduce the world carbon dioxide emissions. When using less CPU power, the PC can throttle down and reduce power consumption, resulting in a greener environment.

    Syntax Highlighting and Syntax Folding
    WYSIWYG
    User Defined Syntax Highlighting
    Auto-completion
    Multi-Document
    Multi-View
    Regular Expression Search/Replace supported
    Full Drag 'N' Drop supported
    Dynamic position of Views
    File Status Auto-detection
    Zoom in and zoom out
    Multi-Language environment supported
    Bookmark
    Brace and Indent guideline Highlighting
    Macro recording and playback

Download here : 

http://www.filehippo.com/download_notepad/