People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |
| -------------------SQL Server------------------------------------------- | |
| select | |
| tags, | |
| charindex('technology', tags) as char_position_tech, | |
| patindex('technology', tags) as pat_position_tech, | |
| patindex('%technology%', tags) as pat_position_tech_2, | |
| charindex('Technology', tags) as char_position_Tech, |
| /* MySQL */ | |
| select | |
| tags, | |
| instr(tags, 'TED'), | |
| locate('TED', tags), | |
| locate('TED', tags, 5), | |
| instr(tags, 'ted'), | |
| locate('ted', tags), |
| -------------------------------PostgreSQL----------------------------------------- | |
| select | |
| tags, | |
| position('technology' in tags) as position_tech, | |
| strpos(tags, 'technology') as strpos_tech | |
| position('Technology' in tags) as position_Tech, | |
| strpos(tags, 'Technology') as strpos_Tech, |
| ---------------------SQL Server---------------------------------------------------------------- | |
| select | |
| title, | |
| lower(title) as lowercase_string, | |
| upper(title) as uppercase_string | |
| from datageeking.dbo.films |
| --*********************************************************************************************************************** | |
| ------------------------SQL Server------------------------------------------------------------------------------------- | |
| ----1) Get the first letter of the string & capitalize it | |
| upper(left(ltrim(title),1)) as first_letter_first_word, | |
| ----2) Get the remaining string | |
| right(lower(ltrim(title)), len(lower(ltrim(title)))-1) as remaining_string, | |
| ----3) Find the position of the first blank space----------------- |
| Sub ExportFSCSlides() | |
| '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | |
| 'written by Angelina Teneva, 2015 | |
| '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | |
| Dim PPApp As PowerPoint.Application | |
| Dim PPpres As PowerPoint.Presentation | |
| Dim pptx As String | |
| pptx = ActiveWorkbook.Worksheets("calculated fields").Range("F2") |
| Sub Display_SlideIDs() | |
| Dim i As Integer | |
| Dim PPS As Slide | |
| Dim p As Presentation | |
| Set p = ActivePresentation | |
| '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | |
| For Each PPS In p.Slides |
| Sub ShowSlideID() | |
| Dim p As Presentation | |
| Set p = ActivePresentation | |
| Dim No As Integer | |
| Dim i As Integer | |
| '*************************** | |
| i = InputBox("Enter Slide number") |
| Sub Count_shapes_on_slide() | |
| Dim p As Presentation | |
| Set p = ActivePresentation | |
| Dim No As Integer | |
| Dim i As Integer | |
| Dim PPS As Slide | |
| Dim Sh As Shape | |
| '*************************** |