Tag: sql

  • 24 hours of PASS.. Get better at SQL

    If you missed a webinar, want to replay your favorites, or wish to share this training with colleagues, now is your chance! The webinar recordings are ready for viewing, learning, and sharing. This event and session recordings are brought to you by the generous support of our presenting sponsors. View their sessions below:SQL Server on […]

  • The fastest way to split a string using CLR

    The original post appeared here: http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx Please visit the original website for more discussion, this is for reference purpose only.   using System; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction( FillRowMethodName = “FillRow_Multi”, TableDefinition = “item nvarchar(4000)” ) ] public static IEnumerator SplitString_Multi( [SqlFacet(MaxSize = -1)] […]

  • learn LINQ in 5 minutes

    Translating SQL to LINQ can prove difficult for new and experienced C# developers. This post contains common SQL queries written in LINQ. I hope it’ll serve as a reference when writing LINQ queries. I’ll use a MS SQL database and Entity Framework for my examples. However, these examples can be extracted to other ORMs and […]