Skip to content
June 7, 2023
  • 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 Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • 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
    • Browse Events
    • Suggest Topics
  • 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 by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • 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: CTE

SQL Server / SQL Server Accidental DBA Series

SQL function to get weekday – weekly calendar

April 10, 2015December 20, 2019 - by SQL Geek - Leave a Comment

In this blog post we’ll look at a way to list out all week days of a week a particular date belongs too. This can be even referred to as weekly …

SQL function to get weekday – weekly calendar Read More
SQL Server / SQL Server Accidental DBA Series

Reverse string in SQL Server

February 17, 2015December 20, 2019 - by SQL Geek - Leave a Comment

SQL Server has in build function REVERSE to reverse string. A T-SQL example is given below The function is very much direct. It takes an input string and returns the reversed …

Reverse string in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

Function to parse alphanumeric characters from string in SQL Server

February 11, 2015December 20, 2019 - by SQL Geek - 2 Comments.

Alphanumeric string consists of alphabets and numbers for example a string 123xyz456abc is an alphanumeric string. Many a times it is required to extract only alphanumeric characters from a string excluding …

Function to parse alphanumeric characters from string in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

SQL Function to remove characters from string

December 19, 2014December 20, 2019 - by SQL Geek - Leave a Comment

One of the most common questions over forums is a SQL function to remove characters from string. The function for the same is given below. — Method 1: Loop IF(Object_id(‘dbo.fn_removecharactersfromstring’)) is …

SQL Function to remove characters from string Read More
SQL Server / SQL Server Accidental DBA Series

SQL function to extract number from string

November 23, 2014December 20, 2019 - by SQL Geek - 1 Comment

A common question among forum is a SQL function to extract number from string. Let’s see how this can be achieved. One way to achieve this is with while loop as …

SQL function to extract number from string Read More
SQL Server / SQL Server Accidental DBA Series

T SQL paging stored procedure

November 9, 2014December 23, 2019 - by SQL Geek - 2 Comments.

Paging is a process of splitting large result set into subset of pages. So, instead of displaying 5000 records resulting from a search, first 20 records are shown and then next …

T SQL paging stored procedure Read More
SQL Server / SQL Server Accidental DBA Series

T-SQL script to find duplicates

June 20, 2014December 23, 2019 - by SQL Geek - Leave a Comment

A common task for DBAs/Developers is to find duplicates in tables to avoid redundancy and storage misuse. Here is a T-SQL script to find duplicates. Create table tblDup(Sno int identity, Col1 …

T-SQL script to find duplicates Read More
SQL Server

SQL Server – What is Common Table Expression (CTE)?

July 13, 2011November 14, 2014 - by Piyush Bajaj - 12 Comments.

Hello Folks, You must have heard CTE before. If you don’t know much about it, then don’t worry at all. I will be giving you some heads up: The Common Table …

SQL Server – What is Common Table Expression (CTE)? Read More

Subscribe to SQLServerGeeks

Free Live Event


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

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

Virtual Symposium

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