SQL# (SQLsharp) - Enabling more powerful SQL

 

Features:

• String: Contains, Count, Cut, EndsWith, Equals, IndexOf, InitCap, Join, LastIndexOf, Newline, NthIndexOf, PadLeft, PadRight, Split, SplitIntoFields, StartsWith, Trim, WordWrap
• RegEx: IsMatch, Matches, Match, MatchLength, MatchSimple, Replace, Split
• Math: CompoundAmortizationSchedule, Constant (30 physics constants), Convert (22 measurement conversions), Cosh, Factorial, IsPrime, RandomRange, Sinh, Tanh
• Date: BusinessDays, DaysInMonth, DaysLeftInYear, FirstDayOfMonth, FormatTimeSpan, FromUNIXTime, FullDateString, FullTimeString, IsBusinessDay, IsLeapYear, LastDayOfMonth, ToUNIXTime
• InterNet (not available in free version): AddressToNumber, FtpDo, FtpGet, FtpPut, GetHostName, GetIPAddress, GetWebPages, IsValidIPAddress, NumberToAddress, Ping, PingTime
• File (not available in free version): ChangeEncoding, Copy, CopyMultiple, CreateDirectory, Decrypt, Delete, DeleteDirectory, DeleteMultiple, Encrypt, GetDirectoryListing, GetDriveInfo, GetFile, GetFileBinary, GetRandomFileName, GetTempPath, GUnzip, GZip, Move, MoveMultiple, PathExists, SplitIntoFields, WriteFile, WriteFileBinary
• Miscellaneous: CRC32, Deflate, GenerateDateTimeRange, GenerateDateTimes, GenerateFloatRange, GenerateFloats, GenerateIntRange, GenerateInts, GUnzip, GZip, Hash, Inflate, IsValidCC, IsValidSSN, ToWords
• Database: DumpData (not available in free version)
• Convert: BinaryToHexString, FromBase64, HexStringToBinary, ROT13, ToBase64
• LookUps: GetCountryInfo, GetStateInfo
• Internal: Version, Help, Setup, Uninstall, GrantPermissions, IsUpdateAvailable, Update (not available in free version), SetSecurity, WebSite
• User-Defined Aggregates: GeometricAvg, Join, Median, Random, RootMeanSqr
• User-Defined Types: FloatArray, HashTable, NVarcharArray

---

What can SQL# do?

• SQL# gives you the easiest access to the power of the CLR!
  – a single assembly with over 100 functions, 5 User-Defined Aggregates, 3 User-Defined Types, and more being added!
• SQL# installs easily and in moments!
  – download one small install sql script, execute it, and enjoy the power of the CLR!
• SQL# is backed up and restored with the database along with all other objects and data!
  – no need to worry about separate DLLs as with COM Extended Stored Procedures
• SQL# has built in documentation (list of function and procedure signatures)!
  – if you ever lose the documention, the worst off you are is one procedure call away from viewing the entire list of function signatures!
• SQL# can easily be updated via the web in moments!
  – you can optionally install updates via the web with a single procedure call
• SQL# saves countless hours learning CLR and .Net, not to mention the cost of Visual Studio 2005!
  – time is money and you have work to do so why stop and learn yet another language, especially when you might need to purchase additional software just to compile a basic function!
• SQL# lets you focus on SQL programming without sacrificing the power of the CLR!
  – again, there is only so much time in the day so do you want to spend it NOT being productive?

Download

Download Free Version of SQL# (SQLsharp) here!

The manual and “What’s New” document cover both Free and Paid-For versions.
Manual in PDF format (766k)
What’s New in Version 2.5.20/2.5.21 (122k)

Date_BusinessDays ExcludeDaysMask Worksheet .
Download Spreadsheet (19k)

Via SQL# (SQLsharp) - Enabling more powerful SQL (Features)

Essential SQL Server Date, Time and DateTime Functions

Standard Date, Time & TimeSpan Functions

function DateOnly(@DateTime DateTime)
– Returns @DateTime at midnight; i.e., it removes the time portion of a DateTime value.
returns datetime

create function Date(@Year int, @Month int, @Day int)
– returns a datetime value for the specified year, month and day
– Thank you to Michael Valentine Jones for this formula (see comments).
returns datetime

create function Time(@Hour int, @Minute int, @Second int)
– Returns a datetime value for the specified time at the “base” date (1/1/1900)
– Many thanks to MVJ for providing this formula (see comments).
returns datetime

create function TimeOnly(@DateTime DateTime)
– returns only the time portion of a DateTime, at the “base” date (1/1/1900)
returns datetime

create function DateTime(@Year int, @Month int, @Day int, @Hour int, @Minute int, @Second int)
– returns a dateTime value for the date and time specified.
returns datetime

create function TimeSpan(@Days int, @Hours int, @Minutes int, @Seconds int)
– returns a datetime the specified # of days/hours/minutes/seconds from the “base” date of 1/1/1900 (a “TimeSpan”)
returns datetime

create function TimeSpanUnits(@Unit char(1), @TimeSpan datetime)
– returns the # of units specified in the TimeSpan.
– The Unit parameter can be: “d” = days, “h” = hours, “m” = minutes, “s” = seconds
returns int

For More Details: Essential SQL Server Date, Time and DateTime Functions

see also:

• SQL# CLR
• Working with Time Spans and Durations in SQL Server
• Group by Month (and other time periods)
• Working with Date and/or Time values in SQL Server: Don’t Format, Don’t Convert — just use DATETIME
• Data Types — The Easiest Part of Database Design
• How to format a Date or DateTime in SQL Server
• Breaking apart the DateTime datatype — Separating Dates from Times in your Tables
• Date Only and Time Only data types in SQL Server 2005 (without the CLR)

Extract frames from video files - The Code Project - Multimedia

 

Introduction

This class contains methods to use the IMediaDet interface, that can be found in Microsoft DirectShow.
The Media Detector object, among other things, can be used to extract still pictures from several file formats including .avi, .wmv and some .mpeg files. This class exposes the GetFrameFromVideo, GetVideoSize and SaveFrameFromVideo methods that can be used from any .net application. The class also takes care of translating HRESULTs returned from the functions to meaningful .net exceptions.

Using the code

Just add a reference to JockerSoft.Media.dll in your project (or include the source code). Remember also to distribute Interop.DexterLib.dll  All the methods are static, so to use them just do something like

try
{
    this.pictureBox1.Image = FrameGrabber.GetFrameFromVideo(strVideoFile, 0.2d);
}
catch (InvalidVideoFileException ex)
{
    MessageBox.Show(ex.Message, "Extraction failed");
}
catch (StackOverflowException)
{
    MessageBox.Show("The target image size is too big", "Extraction failed");
}

or

try
{
    FrameGrabber.SaveFrameFromVideo(strVideoFile, 0.2d, strBitmapFile);
}
catch (InvalidVideoFileException ex)
{
    MessageBox.Show(ex.Message, "Extraction failed");
}

Via Extract frames from video files - The Code Project - Multimedia

Read/Write App.Config

In .NET 2.0+ and with the help of Visual Studio Generated Settings.settings, you can do the following:

Load your settings programmatically:

Settings set = Settings.Default;

Read from your settings:

string str = set.testSetting;

Write to your settings:

set.testSetting = “xyz”;
set.Save();

Very Easy

LINQ, C# Rolls

 

What’s New in C# 

• Dinesh Kulkarni is the C# PM in charge of LINQ to SQL. He has recently revved up his blog: http://blogs.msdn.com/dinesh.kulkarni/. Here are a few of his recent posts:
  • Saved by SSEUtil (you should have it too if you are a SQL Express user)
  • LINQ to SQL, LINQ to Amazon, LINQ to Coffee Machine
  • LINQ is Pronounced Link, not Lin Cue
  • What? No recycling at one of the largest convention centers (Orlando)?
• Sreekar Choudhary is an SDE on the C# Team. This is his second post.
  • Debugging Features in C# 3.0 Part 1
• Browsing Eric Lippert’s blog for the first time is a bit like finding a first class book on C#. Fortunately for us, he has many wonderful new posts to browse:
  • Calling static methods on type variables is illegal, part one
  • Calling static methods on type variables is illegal, part two
  • Bad Names
  • C# and VB Closures
  • Should We Produce Warnings for unused or un-initialized Internal Fields?
  • Why are overloaded operators always static in C#?
• Matt Warren is one of the top developers on the C# Team
  • The Blue Screen of Mort
  • LINQ to SQL: Ignorance is Bliss
  • LINQ to SQL: The Mapping Engine
  • Reddit Randomness and Wayward SPAM
  • Rotten to the Multi-Core
  • Agile at Microsoft
  • IQueryable’s Deep, Dark Secret
  • The Origin of LINQ to SQL
• Jomo Fisher is C# developer on the LINQ to SQL team. Any technical posts he produce are mandatory reading in my book. He has three new posts for us:
  • Dealing with Linq?s Immutable Expression Trees
  • Leaky Functions, Barrel of Bugs
  • Evolution of a C# Query?Step by step from C# 1.1 to LINQ
• Luca Bolognese is C# Lead PM
  • ObjectSpaces early days …
• Luke Hoban is the PM on the Compiler Team
  • C#3.0 Session at TechEd2007 - Code Samples
  • F12 - Go To Definition
  • The Channel 9 Video
• Wes Dyer
  • In Case You Haven’t Heard
  • More on Partial Methods
• I have a few new posts:
  • Intro to LINQ to SQL on Orcas Beta 1
  • Important C# Videos
• How to be random with LINQ to Objects
• LINQ to the Semantic Web Additional information here and also on Hooked on LINQ.
• LINQ to Expressions
• LINQ to Bits
• Work at Microsoft: http://blogs.msdn.com/jobsblog/archive/2007/06/12/my-new-gig-as-a-sourcer.aspx

Community Web Sites and Downloads

• Hooked on LINQ
• Popfly
• Dan Fernandez on Beginning C#
  • Beginning Dev Center
  • Beginner’s Center the Ad
  • Dan Fernandez on Facebook and Popfly

Source from : Charlie Calvert’s Community Blog

del.icio.us Tags: LINQ, C#

LINQ, C# 3.0, VS2008 Beta2

 

Spec: C# Language Specification Version 3.0

Samples and HOL:

• LINQ and language samples for Visual Studio 2008 Beta 2
• LINQ Hands On Labs
• C# 3.0 Language Enhancements Hands On Lab
• Visual Studio 2008 Samples Download Page.

 

del.icio.us Tags: LINQ, VS2008, C#