September 1, 2020

Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008 Part 24



In this video we will learn about commonly string functions in sql server 2008 like Replicate, Space, Patindex, Replace, and Stuff. We will look at some real time examples of where we can use these functions.

Text version of the video

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

Nguồn: https://belahanajima.com/

Xem thêm bài viết khác: https://belahanajima.com/cong-nghe/

Related Posts

Hướng dẫn cách cài đặt lại / restore Macbook (không cần chạy lại hệ điều hành) | MACMALL channel

July 3, 2020

July 3, 2020 32

Có rất nhiều cách để Restore Macbook , nhưng đây là một trong những cách mình thấy hữu dụng và...

Git Tutorial: Fixing Common Mistakes and Undoing Bad Commits

July 4, 2020

July 4, 2020 36

In this video we will look at some common mistakes in Git and how we can fix these mistakes. Specifically...

How to Repair a DEAD Computer

June 28, 2020

June 28, 2020 28

In this video, I have an HP computer that will not boot-up. Watch as I explain the diagnostic process and...

Hướng dẫn render mặt cắt trong sketchup, how to render section plan in Sketchup

July 1, 2020

July 1, 2020 6

Website:dạy 3d kiến trúc và nội thất hàng đầu việt nam Học 3d trực tuyến online hàng đầu Việt Nam...

BacBa – Hard Reset Samsung Galaxy J2 Prime

June 30, 2020

June 30, 2020 46

– You can also try Tenorshare 4uKey for Android ( to unlock Pattern or Pin lock on Samsung, Huawei, LG,...

Samsung Factory Data Reset Tutorial

July 4, 2020

July 4, 2020 14

Products in this video: Samsung Galaxy Note10+: My Video Equipment: Main Camera: Camera Lens: Second Lens: Microphone: SUBSCRIBE here, it’s...

Browserify: Use require() In Client Side JavaScript

June 29, 2020

June 29, 2020 8

Browserify bundles your JS code with the source of all the modules you included and makes a new JS file....

Hướng dẫn cách Reset đầu ghi Hikvision về mặc định của nhà sản xuất

June 29, 2020

June 29, 2020 1

#congnghecuocsong. Hiện nay hệ thống camera giám sát rất thông dụng được nhiều hộ gia định tự mua về lắp...

hướng dẫn reset canon g2000-g2010 tổng quát lỗi 5b00 và lỗi 1700

July 7, 2020

July 7, 2020 8

hướng dẫn reset canon g1000-g2000-g3000-g1010-g2010-g3010 tổng quát lỗi 5b00 và lỗi 1700. .Mọi người không hiểu vấn gì thì cứ...

How to reset identity to 1 in SQL server | Difference b/w Truncate and Delete | Database Sql server

July 4, 2020

July 4, 2020 1

Microsoft SQL Server’s identity column generates sequential values for new records using a seed value. The term seed refers to...

How to Repair Corrupt Windows By Using COMMAND PROMPT!

July 6, 2020

July 6, 2020 1

How to Repair Corrupt Windows By Command Prompt! How to Repair Windows 10 using DISM 1. DISM /Online /Cleanup-Image /CheckHealth...

Cách đổ mực ,reset cartridge Brother TN-B022 (máy in Brother HL-B2080DW, B2000D , B7535DW ,B7715DW )

July 8, 2020

July 8, 2020 12

Trong video này, Việt Bis sẽ hướng dẫn bạn cách đổ mực máy in Brother HL-B2080DW, HL-B2000D , DCP-B7535DW ,...

Epson L130 L220 L310 L360 L365 Ink pad is at the end of its service life error problem solution

July 7, 2020

July 7, 2020 31

IF YOU SHOW ERROR MESSAGE BY ANY PRINTER EPSON L SERIES printer’s ink pad is at the end of its...

Candle flame is repelled by magnets (and Zeeman follow-up)

July 4, 2020

July 4, 2020 22

Why is a candle flame repelled by magnets? It turns out to be a combination of diamagnetic soot particles and...

Hướng dẫn reset máy in canon g1000-g1010 báo lỗi 5b00 và lỗi 1700

June 29, 2020

June 29, 2020 5

Hướng dẫn reset máy in canon g1000-g1010 báo lỗi 5b00 và lỗi 1700. Link mua máy canon G1010 giá rẻ...

Comments
  • Hi venkat,
    Could you please tell me how to write the below sql statement in Oracle
    Patindex(‘%0-9%’, alphanumeric column)
    How to give range in instr function??

  • Come on Venkat, or someone…if could explain what is happening here… Because without CHARINDEX('@', Email)+1) at the end also return the same result :
    select FirstName, LastName,

    SUBSTRING(Email, 1, 2) + REPLICATE('*',5) + SUBSTRING(Email, CHARINDEX('@', Email), LEN(Email))

    from tblEmployee

  • Venkat for president ❤️… Love your video tutorials bro, wish I could meet you one day, you are an amazing teacher

  • Hello Sir! I really appreciate your hard work simplifying SQL in the best way ever, I admit I never found anyone who can do it in the best way as you do. Thus, I really want to be like you, you're my role model, I am doing my best for the moment, however, I just want to know how much it took you to learn using SQL just as you do now ? A year, two … ? I am actually making sure to learn all of what you provided in here and I am learning fast, does this mean if I ever finished all of your tutorial videos, and eventually will be able to use all of the queries you provided that I am well qualified to use SQL ? I hope you would answer me so soon.
    regards.

  • How can i split this into two columns
    like
    ID and Description
    867 Other infectious and parasitic diseases diagnoses with mcc
    Integer value in Id column and rest will be in Description column]

  • Thanks Venkat for providing such comprehensive tutorial. I have been practicing sql questions online and came across a question to find median of a column. I would love you to do a tutorial on writing a sql for finding the median of a column in a table (for example median salary per department).

  • STUFF is simpler if compared to REPLICATE function inside Substring.
    Sample Code on STUFF with REPLICATE:: SELECT Name,STUFF(Email,2,3,REPLICATE('*',5)) from tblPerson;

  • I don't understand the idea of SPACE-function. I understand how it works, but I don't understand why it exists. SPACE(5) = REPLICATE(' ', 5), right? Why separate function is needed?

  • It's the best video tutorial, even if it is to compare with the courses wich I bought. I'm reading also the book Querying Microsoft SQL Server 2012 Training Kit and I can see the quality of your video's. Thank's for your work.

  • Hi Venkat ,your videcs are awesome and easily understandable,thanks a lot for making it,i got doubt regarding patindex and charindex ……when I am using charindex it is giving me result as you said …I was trying it with patindex too…..where I got the result forselect SUBSTRING(Email,PATINDEX('%@%',Email)+1,LEN(Email)-PATINDEX('%@%',Email))as domain from tblemployee   but when I use in group by it is throwing errorselect SUBSTRING(Email,PATINDEX('%@%',Email)+1,LEN(Email)-PATINDEX('%@%',Email))as domain, count(Email) from tblemployee group by SUBSTRING(Email,PATINDEX('%@%',Email)+1,len(Email)-PATINDEX('@',Email))can u suggest me y?thanks in advance…..

  • Hi Venkant , Your videos are of high quality . Thanks for making it . Could you please make a video of finding first monday of the month

  • Just for Info actual query to replace .com with .net in the table would be
    UPDATE tblEmployee SET Email=REPLACE(Email,'.com','.net')

  • select ID, Name, SUBSTRING(Email,1,2)+REPLICATE('*',2)+SUBSTRING(Email, CHARINDEX('@',Email),LEN(Email)) from tblPerson
    I think len(email) is better because anyways there are no characters after the last .domain name. It saves the trouble of calculating the remaining length but still for other situations we might need the exact remaining length. Nice explaination. Just watching one by one.

  • Mask all characters between the first letter and the @ sign:
    select *, stuff(Email, 2, len(Email) – (len(Email) – charindex('@', Email) + 2),
    replicate('*', len(Email) – (len(Email) – charindex('@', Email) + 2))) as StuffedEmail from tblEmployee

  • Hi, Awsome. we are learing lot of things from right professional
    .
    I have one small doubt on Patindex . i understood that it is used with wild card.

    But,     select * from emailtable where email like '%@aaa.com'

    retrieves the same result.

        select email,PATINDEX('%aaa.com',email) as occurance
        from emailtable where PATINDEX('%aaa.com',email)>0

    these returns same. what is the use of pat index in this situation ?

  • This is free. It it were not free, I would not mind paying $50 or so to take a class from you. I follow a long and I understand it.

  • I enjoyed this video.
    Friends if you want to answer what is the diff bet CHAR and PAT INDEXS in the interview then this is the best video.
    Thanks a bunch

  • Hi, Very soon as soon as I am done with sql server. If you can subscribe to my channel, you will be getting updates when I upload new videos. Thank You.

Leave a Reply

Your email address will not be published. Required fields are marked *