Skip to content
Koen Aerts
  • Home
  • .NET
  • Java
  • Database
  • Scripting
  • UNIX/Linux
  • Electronics
  • Hacks
  • Arcade1Up Mod
  • RV

Tag: SQL Server

Parse delimited string into rows

June 29, 2020 Koen Leave a comment

Some time ago I had to build an integration app that would on occasion query from a SQL Server 2012…

Continue Reading →

Posted in: Database, SQL, SQL Server Filed under: Database, SQL, SQL Server

How to achieve the LIKE IN effect in SQL Server

January 20, 2014 Koen Leave a comment

SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there…

Continue Reading →

Posted in: Database, SQL, SQL Server Filed under: Database, SQL, SQL Server

Remove leading zeroes from varchar

November 30, 2012 Koen Leave a comment

The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:

Continue Reading →

Posted in: SQL, SQL Server Filed under: Database, SQL, SQL Server

Tags

.NET Artifactory AutoIt Avatar C# Cloud Container Crystal Reports Database DB2 Docker Electronics Errors Firmware GCR Google Container Repository Groovy Hacks HTML Java Javascript Jenkins JSP Machine Learning Media MongoDB OpenShift Oracle PHP Python Regular Expression Scripting Security Servlet SQL SQL Server UNIX/Linux Virtualization VMware WebSphere Windows WordPress

Links

  • JavaRanch
  • LinkedIn Profile
  • WordPress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2023 Koen Aerts — Escapade WordPress theme by GoDaddy