Wednesday, 31 January 2018

SQL CharIndex Example

  1. DECLARE @PW_MPID NVARCHAR(max)  
  2. set @PW_MPID='1555|2555|35|'  
  3.   
  4. DECLARE @PW_MPIDPostion Varchar(max) = CHARINDEX('|',@PW_MPID)                                                                                      
  5. rint @PW_MPIDPostion                                                       
  6. DECLARE @TempPW_MPID Varchar(max)                                                                                          
  7. WHILE(@PW_MPIDPostion > 0)                                                   
  8.          BEGIN                          
  9.                SET @TempPW_MPID = SUBSTRING(@PW_MPID ,1,@PW_MPIDPostion-1)       
  10.                print @TempPW_MPID  
  11.                  
  12.                 SET @PW_MPID =SUBSTRING(@PW_MPID,@PW_MPIDPostion +1,LEN(@PW_MPID))                                                     
  13.                       print @PW_MPID                                                                     
  14.    SET @PW_MPIDPostion  = CHARINDEX('|',@PW_MPID)     
  15.    print @PW_MPIDPostion                                        
  16.  END   

Tuesday, 30 January 2018

ROLES AND RESPONSIBILITIES

Sr .Net Developer Responsibilities and Duties

If you are considering a job as Sr .Net Developer here is a list of the most standard responsibilities and duties for the Sr .Net Developer position.

Design, develop, test, support and deploy desktop, custom web, and mobile applications.

Gather customer software requirements and develop related software applications and programs.

Research and evaluate software related technologies and products.

Design and develop testing and maintenance procedures and activities.

Develop and write high quality coding that meets customer requirements.

Create software documentation and update existing documentation.

Design, develop and implement critical applications in a .Net environment.

Assist and support other team members on multiple projects.

Drive team members to keep up with projects deadlines and within the clients’ budgets.

Implement best practices, standards and procedures including quality and delivery methodologies.

Ensure compliance with the documented software processes and procedures throughout the life cycle of software products.

Senior Developer Responsibilities and Duties

If you are considering a job as Senior Developer here is a list of the most standard responsibilities and duties for the Senior Developer position.

Develop and document design, source base and architecture.

Maintain and manage existing source bases.

Design, develop and implement solutions to users’ needs and requirements.

Review and improvise code.

Run tests and fix bugs.

Coordinate with architects and business analysts to determine functionalities.

Develop technical solutions to complex business problems.

Design and develop technical solutions for enterprise-level projects.

Design and develop data analysis solutions.

Design and develop logical and physical data models that meet application requirements.

Senior Programmer Responsibilities and Duties

If you are considering a job as Senior Programmer here is a list of the most standard responsibilities and duties for the Senior Programmer position.

Architect, develop and implement software programs to meet business requirements.

Develop application code and modules for business and technical requirements.

Tune up design for maintainability, scalability and efficiency.

Develop and implement programs, designs and codes.

Design and develop systems, sub-systems and programs.

Coordinate and support technical staff, operations and vendors.

Interact with clients to determine their requirements and needs.

Resolve and troubleshoot problems and complex issues.

Perform unit tests and fix bugs.

Integrate best qualitative practices in design and development aspects of programs

Senior Software Engineer Roles & Responsibilities…

If you are considering a job as Senior Software Engineer here is a list of the most standard responsibilities and duties for the Senior Software Engineer position.

Design, develop and implement applications that support day-to-day operations.

Provide innovative solutions to complex business problems.

Plan, develop and implement large-scale projects from conception to completion.

Develop and architect lifecycle of projects working on different technologies and platforms.

Interface with clients and gather business requirements and objectives.

Translate clients’ business requirements and objectives into technical applications and solutions.

Understand and evaluate complex data models.

Design, develop and implement new integration.

Execute system development and maintenance activities.

Develop solutions to improvise performance and scalability of systems.

Software Developer Responsibilities and Duties

If you are considering a job as Software Developer here is a list of the most standard responsibilities and duties for the Software Developer position.

Evaluate, assess and recommend software and hardware solutions.

Develop software, architecture, specifications and technical interfaces.

Develop user interfaces and client displays.

Design, initiate and handle technical designs and complex application features.

Develop, deliver and test software prototypes.

Assist software personnel in handling ongoing tasks as required.

Build flexible data models and seamless integration points.

Innovate and develop high-value technology solutions to streamline processes.

Initiate and drive major changes in programs, procedures and methodology.

Coordinate with other developers and software professionals.

Software Programmer Responsibilities and Duties

If you are considering a job as Software Programmer here is a list of the most standard responsibilities and duties for the Software Programmer position.
Design and develop systems integration, related issues and processes.

Perform analysis, design and develop computer programs and applications.

Perform unit testing and maintain software programs and applications.

Perform coding data acquisition routines and access issues.

Develop custom reports for large data sets.

Assist and support in integration of GIS analysis applications.

Develop and deploy unit testing, load testing and tracking system software support.

Configure, maintain and support production databases.

Develop and implement application to application data feeds.

Configure and maintain multi-site data processes and issues including synchronization.

Software Engineer Responsibilities and Duties 

If you are considering a job as Software Engineer here is a list of the most standard responsibilities and duties for the Software Engineer position.

Design, develop and manage software projects for clients.

Analyze and evaluate user needs and develop software solutions.

Write supporting documents for projects developed and tested.

Develop Microsoft .net based web applications.

Develop MS SQL server applications like views, triggers and stored procedures.

Design and develop web user interfaces with back-end databases and other tools.

Recommend technical feasibilities and solutions.

Evaluate new technologies in the light of emerging trends and technologies.

Modify and update existing technologies improvise performances.

Troubleshoot and resolve difficult problems relating to software applications and programs.

Software Analyst Responsibilities and Duties

If you are considering a job as Software Analyst here is a list of the most standard responsibilities and duties for the Software Analyst position.

Perform complex analysis, designing and programming to meet business requirements.

Maintain, manage and modify all software systems and applications.

Define specifications for complex software programming applications.

Interface with end-users and software consultants.

Develop, maintain and manage systems, software tools and applications.

Resolve complex issues relating to business requirements and objectives.

Coordinate and support software professionals in installing and analyzing applications and tools.

Analyze, develop and implement testing procedures, programming and documentation.

Train and develop other software analysts.

Analyze, design and develop modifications and changes to existing systems to enhance performance.

Software Architect Responsibilities and Duties

If you are considering a job as Software Architect here is a list of the most standard responsibilities and duties for the Software Architect position.

Develop, leverage and architect technical solutions to scale business initiatives.

Develop roadmaps for subsystems in accordance with product related technologies.

Execute product related technologies, technology platforms, architects and design principles and advancements.

Design, develop and architect evolution applications across multi-generation product releases.

Generate business requirements, verify, validate and implement.

Architect all software development lifecycle including requirements gathering, designing, implementing, testing, and releasing.

Architect and implement appropriate technologies according to business requirements.

Assess and evaluate technology tradeoffs.

Select technologies to architect product roadmaps.

Develop and implement appropriate technologies to troubleshoot functional issues and risks.

Software Consultant Responsibilities and Duties

If you are considering a job as Software Consultant here is a list of the most standard responsibilities and duties for the Software Consultant position.

Analyze and understand detailed business requirements.

Provide mapping requirements and software solutions.

Provide recommendations for software developments and implementations.

Document business requirements, gatherings and issues and updated business process flows.

Document results of software research tools and applications.

Execute program modifications and changes.

Interface with clients, software professionals and consultants to develop solutions applications.

Review and evaluate technical design and technical quality issues and processes.

Coordinate and collaborate workflow processes and issues in designing, programming and testing.

Develop highly functional qualitative modifications and system changes.

Software Designer Responsibilities and Duties

If you are considering a job as Software Designer here is a list of the most standard responsibilities and duties for the Software Designer position.

Design, develop and execute unit test plans, test designs, test cases and test strategies.

Design, develop and execute subsystem test plans, procedures and processes.

Document all test plans, test cases and strategies procedures and issues.

Design and implement test scripts on test tools and scripting languages.

Coordinate and collaborate with outside test partners.

Design, develop and implement program and process improvements.

Design and develop coding, code reviews, unit testing and release management.

Develop design specifications in accordance with business requirements and issues.

Recommend strategic improvements to optimize performances.

Perform analyses and interpretations of strategies and software applications.

Monday, 15 January 2018

SQL Server: Make all UPPER case to Proper Case/Title Case

CREATE FUNCTION [dbo].[fnConvert_TitleCase] (@InputString VARCHAR(4000) )
RETURNS VARCHAR(4000)
AS
BEGIN
DECLARE @Index INT
DECLARE @Char CHAR(1)
DECLARE @OutputString VARCHAR(255)

SET @OutputString = LOWER(@InputString)
SET @Index = 2
SET @OutputString = STUFF(@OutputString, 1, 1,UPPER(SUBSTRING(@InputString,1,1)))

WHILE @Index <= LEN(@InputString)
BEGIN
    SET @Char = SUBSTRING(@InputString, @Index, 1)
    IF @Char IN (' ', ';', ':', '!', '?', ',', '.', '_', '-', '/', '&','''','(')
    IF @Index + 1 <= LEN(@InputString)
BEGIN
    IF @Char != ''''
    OR
    UPPER(SUBSTRING(@InputString, @Index + 1, 1)) != 'S'
    SET @OutputString =
    STUFF(@OutputString, @Index + 1, 1,UPPER(SUBSTRING(@InputString, @Index + 1, 1)))
END
    SET @Index = @Index + 1
END

RETURN ISNULL(@OutputString,'')
END

Friday, 12 January 2018

Using WebGet and WebInvoke with example

Using WebGet and WebInvoke
Services can be exposed using the WebHttpBinding binding using either the WebGet or WebInvoke attributes. Each of these attributes specifies the HTTP verb, message format, and body style needed to expose an operation. We will examine each of these attributes and reasons to use each.

WebGet
The WebGet attribute exposes operations using the GET verb. The GET has significant advantages over other HTTP verbs. First, the endpoint is directly accessible via a Web browser by typing the URI to the service into the address bar. Parameters can be sent within the URI either as query string parameters or embedded in the URI. Second, clients and other downstream systems such as proxy servers can easily cache resources based on the cache policy for the service. Because of the caching capability, the WebGet attribute should be used only for retrieval.

WebInvoke
The WebInvoke attribute exposes services using other HTTP verbs such as POST, PUT, and DELETE. The default is to use POST, but it can be changed by setting the Method property of the attribute. These operations are meant to modify resources; therefore, the WebInvoke attribute is used to make modifications to resources.

Shows a service that defines services that are exposed in the WebGet and WebInvoke attributes. The WebGet attribute is used to retrieve customer information. The WebInvoke attribute is used for those operations that modify data such as adding or deleting customers. Last, the UriTemplate property is specified on WebGet and WebInvoke attribute to identify a customer resource using the URI.



  • using System;  
  • using System.ServiceModel;  
  • using System.ServiceModel.Web;  
  •   
  • namespace WCFExample  
  • {  
  •     [ServiceContract]  
  •     public class CustomerService  
  •     {  
  •         [OperationContract]  
  •         [WebGet(UriTemplate="/customer/{id}")]  
  •         public Customer GetCustomer(int id)  
  •         {  
  •             Customer customer = null;  
  •   
  •             // Get customer from database  
  •   
  •             return customer;  
  •         }  
  •   
  •         [OperationContract]  
  •         [WebInvoke(Method = "PUT", UriTemplate = "/customer/{id}")]  
  •         public void PutCustomer(int id, Customer customer)  
  •         {  
  •             // Put customer in database  
  •         }  
  •   
  •         [OperationContract]  
  •         [WebInvoke(Method = "DELETE", UriTemplate = "/customer/{id}")]  
  •         public void DeleteCustomer(int id)  
  •         {  
  •             // Put customer in database  
  •         }  
  •     }  
  • }  
  • Tuesday, 9 January 2018

    How to Kill all the Blocked Processes of a Database

    1. DECLARE @DatabaseName nvarchar(50)  
    2.   
    3. --Set the Database Name  
    4. SET @DatabaseName = N'TESTDB'  
    5.   
    6. --Select the current Daatbase  
    7. SET @DatabaseName = DB_NAME()  
    8.   
    9. DECLARE @SQL varchar(max)  
    10. SET @SQL = ''  
    11.   
    12. SELECT @SQL = @SQL + 'Kill ' + Convert(varchar, SPId) + ';'  
    13. FROM MASTER..SysProcesses  
    14. WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId  
    15. and spid IN (SELECT blocked FROM master.dbo.sysprocesses)  
    16.   
    17. exec @SQL

    Monday, 8 January 2018

    11 Things You Should Never Put On A Resume

    #1 - Unprofessional Email Addresses

    You would be surprised at the types of email addresses that exist on resumes. Things like HotGuy25 or PartyGirl2003. How is a recruiter supposed to take you seriously? If you don't have a professional account, go create one! It will save your image.

    #2 - Objective Statement

    There is never value in you simply telling a recruiter what you want. They already know what job you are applying for. Instead, transform this space. Use it to provide a career summary. Think elevator pitch for your resume. It will sell who you are and what you bring to the table far better than an objective statement.

    #3 - Graduation Dates

    The only dates that should be listed on a resume are dates of employment. No one needs to know when you graduated high school or college. The most important piece is that you graduated. Dates have a way of opening up the possibility the recruiter could guess your age. While there isn't necessarily something wrong with that, age is a protected class. That means it has nothing to do with your ability to do the job so it shouldn't be part of the decision to interview or hire you.

    #4 - Photos

    The only time a photo should be included with a resume is if you are working in modeling or acting. My team used to laugh whenever a resume came in with a photo on it. In reality, it opens a lot of gray area. The recruiter can make assumptions about you based on how they think you look in the picture. All of those assumptions have nothing to do with your quality as a candidate for the job. It's best to only let them evaluate you based on the skills you bring to the table, not how you look.

    #5 - Personal Information

    There are still a lot of people that list personal information on their resume. Things like your marital status, hobbies, how many kids you have, or your social security number have no place on your resume! It would seem these things help paint a picture of your character. However, they really have no bearing on your fit for the job. Plus it opens the door to the possibility of stereotyping to exist. Leave it off entirely. Instead, fill that space with career accomplishments.

    #6 - Every Single Job

    If you have been out of school for 20 years, the recruiter doesn't necessarily care about the first job you held. A good rule of thumb is to only include the last 10 years of your employment. However, you should also think about what experience is most relevant to the job you are applying for. That is what the recruiter needs to see.

    #7 - Salary Information

    The moment you share any salary information you have lost power during the negotiation. Oftentimes recruiters will screen you out if they think you want to make (or have made) more than this job will offer. It's best to withhold salary history until you begin the process of discussing an offer. This ensures you get the opportunity to sell yourself through an interview before you are eliminated from the mix.

    #8 - References (or On Request)

    References are the biggest space wasters, especially if you are trying to achieve a 1-page document. Even simply listing "available on request" is a waste. Leave it off completely and use that space for something else. Recruiters know they can always ask you for references. In fact, their online application likely requested them already.

    #9 - Mistakes

    Double and triple check your resume for grammar mistakes and typos. Have someone else with fresh eyes read it as well. Nothing ruins your chances more than a mistake. Another area to focus on is ensuring your contact information is accurate and valid.

    #10 - Full Sentences

    A resume is not a place for full sentences. It needs to be brief, impactful, and easy to scan. So cut everything down to bullet points. Then rework it using great action verbs to make it succinct and detailed.

    #11 - Multiple Contact Details

    There is no reason to list multiple phone numbers or email addresses on your resume. All it does is cause confusion. Simply list one of each. Let it be exactly where the recruiter can best reach you. Your goal is to be easy to contact!

    Short cut key for computer


    Short cut key for computer

    S.No
    Command Name
    Modifiers
    Key
    Menu
    1
    About


    Help
    2
    Accept All Changes in Doc


    Accept
    3
    Accept All Changes Shown


    Accept
    4
    All Caps
    Ctrl+Shift+
    A

    5
    Annotation
    Alt+Ctrl+
    M

    6
    App Maximize
    Alt+
    F10

    7
    App Restore
    Alt+
    F5

    8
    Apply Heading1
    Alt+Ctrl+
    1

    9
    Apply Heading2
    Alt+Ctrl+
    2

    10
    Apply Heading3
    Alt+Ctrl+
    3

    11
    Apply List Bullet
    Ctrl+Shift+
    L

    12
    Arrange All


    Window
    13
    Auto Correct


    Tools
    14
    Auto Format
    Alt+Ctrl+
    K

    15
    Auto Format Begin


    Format
    16
    Auto Summarize Begin


    Tools
    17
    Auto Text

    F3

    18
    Auto Text
    Alt+Ctrl+
    V

    19
    Background Fill Effect


    Format Background
    20
    Background More Colors


    Format Background
    21
    Background Watermark


    Format Background
    22
    Bold
    Ctrl+
    B

    23
    Bold
    Ctrl+Shift+
    B

    24
    Bookmark
    Ctrl+Shift+
    F5
    Insert
    25
    Bookshelf Lookup Reference


    Tools
    26
    Break


    Insert
    27
    Browse Next
    Ctrl+
    Page Down

    28
    Browse Prev
    Ctrl+
    Page Up

    29
    Browse Sel
    Alt+Ctrl+
    Home

    30
    Cancel

    Esc

    31
    Center Para
    Ctrl+
    E

    32
    Change Case


    Format
    33
    Change Case
    Shift+
    F3

    34
    Char Left

    Left

    35
    Char Left Extend
    Shift+
    Left

    36
    Char Right

    Right

    37
    Char Right Extend
    Shift+
    Right

    38
    Check For Updates


    Help
    39
    Checkin


    File
    40
    Checkout


    File
    41
    Clear

    Del
    Clear
    42
    Clear Formatting


    Clear
    43
    Close or Exit
    Alt+
    F4

    44
    Close Pane
    Alt+Shift+
    C

    45
    Column Break
    Ctrl+Shift+
    Return

    46
    Column Select
    Ctrl+Shift+
    F8

    47
    Contact Us


    Help
    48
    Copy
    Ctrl+
    C

    49
    Copy
    Ctrl+
    Insert

    50
    Copy Format
    Ctrl+Shift+
    C

    51
    Copy Text
    Shift+
    F2

    52
    Create Auto Text
    Alt+
    F3

    53
    Cross Reference


    Reference Menu
    54
    Customize


    Tools
    55
    Customize Add Menu Shortcut
    Alt+Ctrl+
    =

    56
    Customize Keyboard Shortcut
    Alt+Ctrl+
    Num +

    57
    Customize Remove Menu Shortcut
    Alt+Ctrl+
    -

    58
    Cut
    Ctrl+
    X

    59
    Cut
    Shift+
    Del

    60
    Date Field
    Alt+Shift+
    D

    61
    Date Time


    Insert
    62
    Delete All Comments in Doc


    Reject
    63
    Delete All Comments Shown


    Reject
    64
    Delete Back Word
    Ctrl+
    Backspace

    65
    Delete Table


    Toolbar 32780
    66
    Delete Word
    Ctrl+
    Del

    67
    Display Final Doc


    Show Markup
    68
    Display Original Doc


    Show Markup
    69
    Display Shared Workspace Pane


    Tools
    70
    Distribute Para
    Ctrl+Shift+
    J

    71
    Do Field Click
    Alt+Shift+
    F9

    72
    Doc Close
    Ctrl+
    W

    73
    Doc Close
    Ctrl+
    F4

    74
    Doc Maximize
    Ctrl+
    F10

    75
    Doc Move
    Ctrl+
    F7

    76
    Doc Restore
    Ctrl+
    F5

    77
    Doc Size
    Ctrl+
    F8

    78
    Doc Split
    Alt+Ctrl+
    S
    Window
    79
    Double Underline
    Ctrl+Shift+
    D

    80
    Draw Snap to Grid


    Draw
    81
    End of Column
    Alt+
    Page Down

    82
    End of Column
    Alt+Shift+
    Page Down

    83
    End of Doc Extend
    Ctrl+Shift+
    End

    84
    End of Document
    Ctrl+
    End

    85
    End of Line

    End

    86
    End of Line Extend
    Shift+
    End

    87
    End of Row
    Alt+
    End

    88
    End of Row
    Alt+Shift+
    End

    89
    End of Window
    Alt+Ctrl+
    Page Down

    90
    End of Window Extend
    Alt+Ctrl+Shift+
    Page Down

    91
    Endnote Now
    Alt+Ctrl+
    D

    92
    Envelope Wizard


    Letters and Mailings Menu
    93
    Exit


    File
    94
    Extend Selection

    F8

    95
    Fax Service


    Send To
    96
    Field


    Insert
    97
    Field Chars
    Ctrl+
    F9

    98
    Field Codes
    Alt+
    F9

    99
    Find
    Ctrl+
    F

    100
    Fix Broken Text


    Tools
    101
    Fix Me


    Help
    102
    Font
    Ctrl+
    D

    103
    Font
    Ctrl+Shift+
    F

    104
    Font Size Select
    Ctrl+Shift+
    P

    105
    Footnote Now
    Alt+Ctrl+
    F

    106
    Footnotes


    View
    107
    Formatting Properties
    Shift+
    F1
    Format
    108
    Formula


    Table
    109
    Frameset Wizard


    Frames Menu
    110
    Go Back
    Shift+
    F5

    111
    Go Back
    Alt+Ctrl+
    Z

    112
    Go To
    Ctrl+
    G
    Edit
    113
    Go To

    F5
    Edit
    114
    Grow Font
    Ctrl+Shift+
    .

    115
    Grow Font One Point
    Ctrl+
    ]

    116
    Hanging Indent
    Ctrl+
    T

    117
    Header


    View
    118
    Header Footer Link
    Alt+Shift+
    R

    119
    Headings


    Table
    120
    Help

    F1

    121
    HHC
    Alt+Ctrl+
    F7
    Language
    122
    Hidden
    Ctrl+Shift+
    H

    123
    HTMLSource


    View
    124
    Hyperlink
    Ctrl+
    K

    125
    Hyphenation


    Language
    126
    Indent
    Ctrl+
    M

    127
    Index and Tables


    Reference Menu
    128
    Insert Column


    Toolbar 32779
    129
    Insert Column Right


    Toolbar 32779
    130
    Insert Row Above


    Toolbar 32779
    131
    Insert Row Below


    Toolbar 32779
    132
    Italic
    Ctrl+
    I

    133
    Italic
    Ctrl+Shift+
    I

    134
    Justify Para
    Ctrl+
    J

    135
    Language


    Language
    136
    Left Para
    Ctrl+
    L

    137
    Letter Properties


    Letters and Mailings Menu
    138
    Letters Wizard JToolbar


    Letters and Mailings Menu
    139
    License Verification


    Help
    140
    Line Down

    Down

    141
    Line Down Extend
    Shift+
    Down

    142
    Line Up

    Up

    143
    Line Up Extend
    Shift+
    Up

    144
    Links


    Edit
    145
    List Num Field
    Alt+Ctrl+
    L

    146
    Lock Fields
    Ctrl+
    3

    147
    Lock Fields
    Ctrl+
    F11

    148
    Macro
    Alt+
    F8

    149
    Mail Merge Check
    Alt+Shift+
    K

    150
    Mail Merge Edit Data Source
    Alt+Shift+
    E

    151
    Mail Merge to Doc
    Alt+Shift+
    N

    152
    Mail Merge to Printer
    Alt+Shift+
    M

    153
    Mail Merge Toolbar


    Letters and Mailings Menu
    154
    Mail Merge Wizard


    Letters and Mailings Menu
    155
    Mark Citation
    Alt+Shift+
    I

    156
    Mark Index Entry
    Alt+Shift+
    X

    157
    Mark Table of Contents Entry
    Alt+Shift+
    O

    158
    Menu Mode

    F10

    159
    Merge Field
    Alt+Shift+
    F

    160
    Merge Revisions


    Tools
    161
    Microsoft Script Editor
    Alt+Shift+
    F11

    162
    Microsoft System Info
    Alt+Ctrl+
    F1

    163
    Move Text

    F2

    164
    Never Use Balloons


    Balloons
    165
    New


    File
    166
    New Default
    Ctrl+
    N

    167
    New Window


    Window
    168
    Next Cell

    Tab

    169
    Next Field

    F11

    170
    Next Field
    Alt+
    F1

    171
    Next Misspelling
    Alt+
    F7

    172
    Next Object
    Alt+
    Down

    173
    Next Window
    Ctrl+
    F6

    174
    Next Window
    Alt+
    F6

    175
    No Insertion Deletion Balloons


    Balloons
    176
    Normal
    Alt+Ctrl+
    N
    View
    177
    Normal Style
    Ctrl+Shift+
    N

    178
    Normal Style
    Alt+Shift+
    Clear (Num 5)

    179
    Number


    Insert
    180
    Object


    Insert
    181
    Office Clipboard


    Edit
    182
    Office On The Web


    Help
    183
    Online Meeting


    Online Collaboration
    184
    Open
    Ctrl+
    O

    185
    Open
    Ctrl+
    F12

    186
    Open
    Alt+Ctrl+
    F2

    187
    Open or Close Up Para
    Ctrl+
    0

    188
    Options


    Tools
    189
    Other Pane

    F6

    190
    Other Pane
    Shift+
    F6

    191
    Outline
    Alt+Ctrl+
    O

    192
    Outline Collapse
    Alt+Shift+
    -

    193
    Outline Collapse
    Alt+Shift+
    Num -

    194
    Outline Demote
    Alt+Shift+
    Right

    195
    Outline Expand
    Alt+Shift+
    =

    196
    Outline Expand
    Alt+Shift+
    Num +

    197
    Outline Master


    View
    198
    Outline Move Down
    Alt+Shift+
    Down

    199
    Outline Move Up
    Alt+Shift+
    Up

    200
    Outline Promote
    Alt+Shift+
    Left

    201
    Outline Show First Line
    Alt+Shift+
    L

    202
    Overtype

    Insert

    203
    Page
    Alt+Ctrl+
    P
    View
    204
    Page Break
    Ctrl+
    Return

    205
    Page Down

    Page Down

    206
    Page Down Extend
    Shift+
    Page Down

    207
    Page Field
    Alt+Shift+
    P

    208
    Page Numbers


    Insert
    209
    Page Up

    Page Up

    210
    Page Up Extend
    Shift+
    Page Up

    211
    Para Down
    Ctrl+
    Down

    212
    Para Down Extend
    Ctrl+Shift+
    Down

    213
    Para Up
    Ctrl+
    Up

    214
    Para Up Extend
    Ctrl+Shift+
    Up

    215
    Paste
    Ctrl+
    V

    216
    Paste
    Shift+
    Insert

    217
    Paste As Hyperlink


    Edit
    218
    Paste Format
    Ctrl+Shift+
    V

    219
    Paste Special


    Edit
    220
    Permission


    File
    221
    Post


    Send To
    222
    Postcard Wizard


    Letters and Mailings Menu
    223
    Present It


    Send To
    224
    Prev Cell
    Shift+
    Tab

    225
    Prev Field
    Shift+
    F11

    226
    Prev Field
    Alt+Shift+
    F1

    227
    Prev Object
    Alt+
    Up

    228
    Prev Window
    Ctrl+Shift+
    F6

    229
    Prev Window
    Alt+Shift+
    F6

    230
    Print
    Ctrl+
    P

    231
    Print
    Ctrl+Shift+
    F12

    232
    Print Preview
    Ctrl+
    F2

    233
    Print Preview
    Alt+Ctrl+
    I

    234
    Proofing

    F7

    235
    Properties


    File
    236
    Protect


    Tools
    237
    Reading Mode Layout


    View
    238
    Record Macro Toggle


    Macro
    239
    Redo
    Alt+Shift+
    Backspace

    240
    Redo or Repeat
    Ctrl+
    Y
    Edit
    241
    Redo or Repeat

    F4
    Edit
    242
    Redo or Repeat
    Alt+
    Return
    Edit
    243
    Reject All Changes in Doc


    Reject
    244
    Reject All Changes Shown


    Reject
    245
    Repeat Find
    Shift+
    F4

    246
    Repeat Find
    Alt+Ctrl+
    Y

    247
    Replace
    Ctrl+
    H
    Edit
    248
    Research Lookup
    Ctrl+Shift+
    O

    249
    Reset Char
    Ctrl+
    Space

    250
    Reset Char
    Ctrl+Shift+
    Z

    251
    Reset Para
    Ctrl+
    Q

    252
    Revision Marks Toggle
    Ctrl+Shift+
    E

    253
    Right Para
    Ctrl+
    R

    254
    Routing Slip


    Send To
    255
    Save
    Ctrl+
    S

    256
    Save
    Shift+
    F12

    257
    Save
    Alt+Shift+
    F2

    258
    Save As

    F12
    File
    259
    Save As Web Page


    File
    260
    Schedule Meeting


    Online Collaboration
    261
    Search


    File
    262
    Select All
    Ctrl+
    A
    Edit
    263
    Select All
    Ctrl+
    Clear (Num 5)
    Edit
    264
    Select All
    Ctrl+
    Num 5
    Edit
    265
    Select Cell


    Toolbar 32778
    266
    Select Column


    Toolbar 32778
    267
    Select Row


    Toolbar 32778
    268
    Select Table
    Alt+
    Clear (Num 5)
    Toolbar 32778
    269
    Send For Review


    Send To
    270
    Send to Fax


    Send To
    271
    Send to Online Meeting Participants


    Send To
    272
    Show All
    Ctrl+Shift+
    8

    273
    Show All Headings
    Alt+Shift+
    A

    274
    Show All Headings
    Alt+Shift+
    A

    275
    Show Comments


    Show Markup
    276
    Show Formatting


    Show Markup
    277
    Show Heading1
    Alt+Shift+
    1

    278
    Show Heading2
    Alt+Shift+
    2

    279
    Show Heading3
    Alt+Shift+
    3

    280
    Show Heading4
    Alt+Shift+
    4

    281
    Show Heading5
    Alt+Shift+
    5

    282
    Show Heading6
    Alt+Shift+
    6

    283
    Show Heading7
    Alt+Shift+
    7

    284
    Show Heading8
    Alt+Shift+
    8

    285
    Show Heading9
    Alt+Shift+
    9

    286
    Show Hide


    Help
    287
    Show Ink Annotations


    Show Markup
    288
    Show Insertions and Deletions


    Show Markup
    289
    Show Signatures


    Tools
    290
    Shrink Font
    Ctrl+Shift+
    ,

    291
    Shrink Font One Point
    Ctrl+
    [

    292
    Shrink Selection
    Shift+
    F8

    293
    Sign Out of Passport


    File
    294
    Small Caps
    Ctrl+Shift+
    K

    295
    Sort


    Table
    296
    Space Para1
    Ctrl+
    1

    297
    Space Para15
    Ctrl+
    5

    298
    Space Para2
    Ctrl+
    2

    299
    Speech


    Tools
    300
    Spike
    Ctrl+Shift+
    F3

    301
    Spike
    Ctrl+
    F3

    302
    Split


    Table
    303
    Sqm Dialog


    Help
    304
    Start of Column
    Alt+
    Page Up

    305
    Start of Column
    Alt+Shift+
    Page Up

    306
    Start of Doc Extend
    Ctrl+Shift+
    Home

    307
    Start of Document
    Ctrl+
    Home

    308
    Start of Line

    Home

    309
    Start of Line Extend
    Shift+
    Home

    310
    Start of Row
    Alt+
    Home

    311
    Start of Row
    Alt+Shift+
    Home

    312
    Start of Window
    Alt+Ctrl+
    Page Up

    313
    Start of Window Extend
    Alt+Ctrl+Shift+
    Page Up

    314
    Style
    Ctrl+Shift+
    S

    315
    Style Separator
    Alt+Ctrl+
    Return

    316
    Subscript
    Ctrl+
    =

    317
    Superscript
    Ctrl+Shift+
    =

    318
    Symbol


    Insert
    319
    Symbol Font
    Ctrl+Shift+
    Q

    320
    Tabs


    Format
    321
    Task Pane
    Ctrl+
    F1

    322
    Templates


    Tools
    323
    Theme


    Format
    324
    Thesaurus RR
    Shift+
    F7
    Language
    325
    Time Field
    Alt+Shift+
    T

    326
    Toggle Character Code
    Alt+
    X

    327
    Toggle Field Display
    Shift+
    F9

    328
    Toggle Master Subdocs
    Ctrl+
    \

    329
    Toggle XMLTag View
    Ctrl+Shift+
    X

    330
    Toolbars


    View
    331
    Translate Pane
    Alt+Shift+
    F7
    Language
    332
    Un Hang
    Ctrl+Shift+
    T

    333
    Un Indent
    Ctrl+Shift+
    M

    334
    Underline
    Ctrl+
    U

    335
    Underline
    Ctrl+Shift+
    U

    336
    Undo
    Ctrl+
    Z

    337
    Undo
    Alt+
    Backspace

    338
    Unlink Fields
    Ctrl+
    6

    339
    Unlink Fields
    Ctrl+Shift+
    F9

    340
    Unlock Fields
    Ctrl+
    4

    341
    Unlock Fields
    Ctrl+Shift+
    F11

    342
    Update Auto Format
    Alt+Ctrl+
    U

    343
    Update Fields

    F9

    344
    Update Fields
    Alt+Shift+
    U

    345
    Update Source
    Ctrl+Shift+
    F7

    346
    Use Balloons


    Balloons
    347
    VBCode
    Alt+
    F11

    348
    Versions


    File
    349
    Versions Server


    Ve&rsion History
    350
    Web


    View
    351
    Web Component


    Insert
    352
    Web Go Back
    Alt+
    Left

    353
    Web Go Forward
    Alt+
    Right

    354
    Web Page Preview


    File
    355
    Wizard


    Table
    356
    Word Count


    Tools
    357
    Word Count List
    Ctrl+Shift+
    G

    358
    Word Count Recount
    Ctrl+Shift+
    R

    359
    Word Left
    Ctrl+
    Left

    360
    Word Left Extend
    Ctrl+Shift+
    Left

    361
    Word Perfect Help


    Help
    362
    Word Right
    Ctrl+
    Right

    363
    Word Right Extend
    Ctrl+Shift+
    Right

    364
    Word Underline
    Ctrl+Shift+
    W

    SQL CharIndex Example

    DECLARE  @PW_MPID NVARCHAR( max )   set  @PW_MPID= '1555|2555|35|'       DECLARE  @PW_MPIDPostion  Varchar ( max ) = CHARINDEX(...