HeavenCore | IT Solutions Built on Open Source Software
View Forum
HeavenCore | IT Solutions Built on Open Source Software » HeavenCore Central » SQL Functions
  Subject Author Views Replies Last Post
No New PostsSticky SQL Server Functions admin 3946 0 admin
26-06-2010 19:17
No New Postseval function for SQL (CLR) admin 9399 0 admin
23-04-2012 11:48
No New PostsCreate Working Days table with bank holidays etc admin 8431 0 admin
12-12-2011 11:44
No New PostsGet Week End Date (Sunday) of any date regardless of DATEFIRST admin 3179 0 admin
25-10-2011 15:05
No New PostsGet Start of Financial Year for any given date admin 2530 0 admin
25-10-2011 14:40
No New PostsSelecting data as XML admin 2419 0 admin
19-10-2011 14:32
No New PostsSQL Mirroring - Create SQL Agent Alerts for Mirroring Events admin 3780 0 admin
19-10-2011 14:30
No New PostsSQL Mirroring - Fore Mirror Online (when principle dies before failing over) admin 2541 0 admin
19-10-2011 14:25
No New PostsSQL Mirroring - List State & Role of each mirrored database admin 2189 0 admin
19-10-2011 14:21
No New PostsSQL Mirroring - Set Mirror Timeout admin 2364 0 admin
19-10-2011 14:19
No New PostsSlow DB Deletion - Add missing MSDB indexes admin 3113 0 admin
19-10-2011 14:15
No New PostsRename database admin 2138 0 admin
19-10-2011 14:09
No New PostsSimple Cursor example admin 2444 0 admin
19-10-2011 14:03
No New PostsFunction to ping in SQL Server admin 4538 0 admin
24-08-2010 11:03
No New PostsFunction to split UpperCaseStrings like this into seperate words admin 4124 0 admin
17-08-2010 17:07
No New PostsFunction to get occurrence of char (charindex + occurrence) admin 3771 0 admin
26-06-2010 19:13
No New PostsFunction to Calculate Distance Between a pair of Long and Latitudes admin 3153 0 admin
26-06-2010 19:12
No New PostsFunction to calculate percentage increase of two values admin 3618 0 admin
26-06-2010 19:11
No New PostsFunction to DATEFIFF() but in words, EG: 3 days, 2 hours admin 2384 0 admin
26-06-2010 19:10
No New PostsFunction to convert weeknumber to date admin 2832 0 admin
26-06-2010 19:09
Jump to Forum
New Posts - Open Thread with new posts since last visitNo New Posts - Open Thread with no new posts since last visit.
Locked Thread - Locked Thread.Sticky Thread - Sticky
Hot Thread - Hot ThreadPoll - Poll
Files Attached - Files AttachedImage Attached - Image Attached