Skip to content
June 27, 2022
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: XML

SQL Server / SQL Server Accidental DBA Series

Function to Convert Text String to Proper Case in SQL Server

October 9, 2014December 23, 2019 - by SQL Geek - Leave a Comment

Many a times need arises to convert a string into proper case specially the names. Let’s have a look at a SQL Server function to convert text string to proper case. …

Function to Convert Text String to Proper Case in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

Function to Convert String to Date in SQL Server

October 8, 2014December 23, 2019 - by SQL Geek - Leave a Comment

The SQL Server has inbuilt function to convert string to date. It can be done using CAST/CONVERT as shown below DECLARE @stringdate varchar(100), @cast_dt datetime, @conver_dt datetime SET @stringdate=’09/25/2014′ SET @cast_dt=CAST(@stringdate …

Function to Convert String to Date in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

SQL function – convert list to table

May 3, 2014December 23, 2019 - by SQL Geek - 1 Comment

Here is quick SQL function to convert list to table. — sql function to convert list to table CREATE FUNCTION fn_listtotable ( @list nvarchar(max), @delimeter nvarchar(100) ) RETURNS @split TABLE ( …

SQL function – convert list to table Read More
SQL Server

How to Handle Null Values in XML

January 14, 2013September 12, 2014 - by Piyush Bajaj - 2 Comments.

Hello Folks, You might be wondering about how to handle NULLS if it’s a part of XML result set. Well, I have some keynotes about it, so please see it carefully: Till …

How to Handle Null Values in XML Read More
SQL Server

XML Datatype in SQL Server- A small example

July 22, 2011November 14, 2014 - by Rahul Sharma - Leave a Comment

Dear All, XML data type was introduced in SQL Server 2005. This type allows you to store XML data up to 2 GB. Here is a small example of, pretty much …

XML Datatype in SQL Server- A small example Read More

Subscribe to SQLServerGeeks

Ad

Virtual Symposium

master classes

SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Virtual Symposium

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.