Belahanajima - Tin tức nóng nhất trong ngày đa dạng chủ đề
  • Home
  • Phong Thủy
  • Học Tiếng Anh
  • Công Nghệ
No Result
View All Result
Thursday, December 16, 2021
  • Home
  • Phong Thủy
  • Học Tiếng Anh
  • Công Nghệ
No Result
View All Result
Belahanajima - Tin tức nóng nhất trong ngày đa dạng chủ đề
No Result
View All Result

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

admin by admin
June 28, 2020
in Công Nghệ
37
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/

Xem thêm Bài Viết:

  • Đánh giá AMD Ryzen 9 5950X và Ryzen 7 5800X: từ làm việc tới chơi game đều đỉnh, không chừa đất sống cho đối thủ
  • Hiển thị Repair Your Computer trong Advanced Boot Options trên Windows 7
  • How to repair windows 7 and fix corrupt CD/DVD (tutorial)
  • How To Repair Windows 10
  • Windows Repair (All In One) FREE Repair Program
Previous Post

Terraria - Part 2 - I LOVE this Game!!

Next Post

30 Ngày Tự Học Tiếng Anh Giao Tiếp Cơ Bản Cho Người Mới Bắt Đầu [TUẦN 01] BÀI 1 - 5

Next Post
30 Ngày Tự Học Tiếng Anh Giao Tiếp Cơ Bản Cho Người Mới Bắt Đầu [TUẦN 01] BÀI 1 – 5

30 Ngày Tự Học Tiếng Anh Giao Tiếp Cơ Bản Cho Người Mới Bắt Đầu [TUẦN 01] BÀI 1 - 5

Comments 37

  1. Royel Islam says:
    1 year ago

    Enjoying this lecture .

    Reply
  2. saraswathi c says:
    1 year ago

    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??

    Reply
  3. Learn Tech with Ashish says:
    1 year ago

    Super explanation love to learn from you

    Reply
  4. SQL Server Tutorials says:
    1 year ago

    Loved watching this

    Reply
  5. Ott Miller says:
    1 year ago

    Lucid and concise. Thank you.

    Reply
  6. Gregory M says:
    1 year ago

    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

    Reply
  7. Arish Hurbans says:
    1 year ago

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

    Reply
  8. Raj Kum says:
    1 year ago

    Please tell me how to extract 20-40 from column and will get output like 20*1000/40*1000

    Reply
  9. Wol Verine says:
    1 year ago

    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.

    Reply
  10. Seshubabu Dabbakuti says:
    1 year ago

    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]

    Reply
  11. alireza nikoughadam says:
    1 year ago

    Perfect

    Reply
  12. Abhishek Vigg says:
    1 year ago

    How can I get the data you are working on? I would like to practice all the functions

    Reply
  13. anchal gupta says:
    1 year ago

    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).

    Reply
  14. Nilesh Wakchaure says:
    1 year ago

    I want to split comma separated string e.q '1,2,3' as IN parameter to query

    Reply
  15. Programme Seekho says:
    1 year ago

    Thank You Sir
    Very helpful Video..Very Nice Sir

    Reply
  16. BINGOVIDS says:
    1 year ago

    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;

    Reply
  17. Arto Kilponen says:
    1 year ago

    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?

    Reply
  18. suiram uisicoc says:
    1 year ago

    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.

    Reply
  19. mhd says:
    1 year ago

    Hi Venkat ,your videcs are awesome and easily understandable,thanks a lot for making it

    Reply
  20. Krzysztof S says:
    1 year ago

    So almost all STRING functions you have described. Thank U a lot ! You are amazing!

    Reply
  21. priyanka kommidi says:
    1 year ago

    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…..

    Reply
  22. ravi kumar says:
    1 year ago

    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

    Reply
  23. Salman Shaikh says:
    1 year ago

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

    Reply
  24. Salman Shaikh says:
    1 year ago

    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.

    Reply
  25. Roger Santos says:
    1 year ago

    Thanks, simple and the best explanation.

    Reply
  26. archrodney says:
    1 year ago

    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

    Reply
  27. CJAM16 says:
    1 year ago

    thanks venkat, this is quite easy to grasp

    Reply
  28. #Stuti# #Tehri# says:
    1 year ago

    nice explanation

    Reply
  29. christ x says:
    1 year ago

    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 ?

    Reply
  30. Stephen Essel says:
    1 year ago

    The Best, Simply the Best…

    Reply
  31. Jane McCoy says:
    1 year ago

    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.

    Reply
  32. Jane McCoy says:
    1 year ago

    Thank you. I have found out that most of the videos on Youtube are better taking classes at school.

    Reply
  33. krismaly says:
    1 year ago

    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

    Reply
  34. madhuri j says:
    1 year ago

    thanks .. these videos helped me alot

    Reply
  35. Anurag Vashishtha says:
    1 year ago

    Nice video. Helped me in learning new functions in almost no time. Thank you Venkat.

    Reply
  36. kudvenkat says:
    1 year ago

    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.

    Reply
  37. Prasanta Sharma says:
    1 year ago

    Venkat, Are you planning to upload tutorials for ASP.NET as well? If so when would that happen?

    Reply

Leave a Reply Cancel reply

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

Xem Thêm

☔ TƯ VẤN MẬU NGỌ 1978 CHỌN HƯỚNG NHÀ, LÀM NHÀ, LÀM BẾP P3 – Phong Thủy XUÂN THỨ

☔ TƯ VẤN MẬU NGỌ 1978 CHỌN HƯỚNG NHÀ, LÀM NHÀ, LÀM BẾP P3 – Phong Thủy XUÂN THỨ

July 3, 2020
☕ CANH TUẤT 1970 CHỌN HƯỚNG Như Thế Nào – Phong Thủy XUÂN THỨ

☕ CANH TUẤT 1970 CHỌN HƯỚNG Như Thế Nào – Phong Thủy XUÂN THỨ

June 30, 2020
☕TÂN HỢI 1971 CHỌN HƯỚNG – Phong Thủy XUÂN THỨ

☕TÂN HỢI 1971 CHỌN HƯỚNG – Phong Thủy XUÂN THỨ

July 6, 2020
☯ NHÂM TUẤT 1982 CHỌN HƯỚNG Kinh Doanh Như Thế Nào – Phong Thủy – Xuân Thứ

☯ NHÂM TUẤT 1982 CHỌN HƯỚNG Kinh Doanh Như Thế Nào – Phong Thủy – Xuân Thứ

June 29, 2020
☯ QUÝ HỢI 1983 Làm Nhà Hướng Nào Tốt – Phong Thủy – Xuân Thứ

☯ QUÝ HỢI 1983 Làm Nhà Hướng Nào Tốt – Phong Thủy – Xuân Thứ

July 4, 2020
☯Mệnh Mộc nên KINH DOANH BUÔN BÁN GÌ, LÀM NGHỀ GÌ ĐỂ PHÁT TÀI🔥TỬ VI SỐ MỆNH

☯Mệnh Mộc nên KINH DOANH BUÔN BÁN GÌ, LÀM NGHỀ GÌ ĐỂ PHÁT TÀI🔥TỬ VI SỐ MỆNH

July 4, 2020
  • Chính Sách Bảo Mật
  • Liên Hệ

© 2021 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Phong Thủy
  • Học Tiếng Anh
  • Công Nghệ

© 2021 JNews - Premium WordPress news & magazine theme by Jegtheme.