C:\Windows\System32\odbcad32.exe --> 64bit C:\Windows\SysWOW64\odbcad32.exe --> 32bit
C:\Windows\System32\odbcad32.exe --> 64bit C:\Windows\SysWOW64\odbcad32.exe --> 32bit
exec sp_addlinkedserver '10.10.10.1'; exec sp_addlinkedsrvlogin '10.10.10.1', 'FALSE', NULL, 'username1', 'password1';
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) < @EndDateOutput :
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
-- @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
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/