- DECLARE @PW_MPID NVARCHAR(max)
- set @PW_MPID='1555|2555|35|'
- DECLARE @PW_MPIDPostion Varchar(max) = CHARINDEX('|',@PW_MPID)
- rint @PW_MPIDPostion
- DECLARE @TempPW_MPID Varchar(max)
- WHILE(@PW_MPIDPostion > 0)
- BEGIN
- SET @TempPW_MPID = SUBSTRING(@PW_MPID ,1,@PW_MPIDPostion-1)
- print @TempPW_MPID
- SET @PW_MPID =SUBSTRING(@PW_MPID,@PW_MPIDPostion +1,LEN(@PW_MPID))
- print @PW_MPID
- SET @PW_MPIDPostion = CHARINDEX('|',@PW_MPID)
- print @PW_MPIDPostion
- END
Wednesday, 31 January 2018
SQL CharIndex Example
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
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
}
}
}
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.
Tuesday, 9 January 2018
How to Kill all the Blocked Processes of a Database
- DECLARE @DatabaseName nvarchar(50)
- --Set the Database Name
- SET @DatabaseName = N'TESTDB'
- --Select the current Daatbase
- SET @DatabaseName = DB_NAME()
- DECLARE @SQL varchar(max)
- SET @SQL = ''
- SELECT @SQL = @SQL + 'Kill ' + Convert(varchar, SPId) + ';'
- FROM MASTER..SysProcesses
- WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId
- and spid IN (SELECT blocked FROM master.dbo.sysprocesses)
- 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!
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
|
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
|
|
|
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+
|
|
|
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+
|
|
|
67
|
Display Final Doc
|
|
|
Show Markup
|
68
|
Display Original Doc
|
|
|
Show Markup
|
69
|
Display Shared Workspace Pane
|
|
|
Tools
|
70
|
Distribute
|
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
|
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
|
Ctrl+
|
J
|
|
135
|
Language
|
|
|
Language
|
136
|
Left
|
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
|
|
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
|
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
|
|
Ctrl+
|
Down
|
|
212
|
|
Ctrl+Shift+
|
Down
|
|
213
|
|
Ctrl+
|
Up
|
|
214
|
|
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
|
Ctrl+
|
Q
|
|
252
|
Revision Marks Toggle
|
Ctrl+Shift+
|
E
|
|
253
|
Right
|
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
|
|
|
|
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
|
|
Subscribe to:
Posts (Atom)
Upload valid file in C#
protected bool CheckFileExtandLength(HttpPostedFile HtmlDocFile) { try { Dictionary<string, byte[]...
-
Setting Header Programatically You can also set the cache headers programmatically. This can be useful for generated content and allows m...
-
CREATE TABLE dbo.M_Bank ( ID INT IDENTITY NOT NULL, MB_NAME NVARCHAR (50), MB_SNAME NVARCHAR (20), MB_ADDUSER ...
-
SELECT distinct(volume_mount_point), total_bytes/1048576 as Size_in_MB, total_bytes/1048576/1024 as Size_in_GB, available_bytes/1048576 ...