NET Programming Standards and Naming Conventions
Common .NET Naming Conventions
These are the industry-accepted standard naming conventions for J#, C# and VB.NET programs. For additional information, please see the MSDN help documentation and FX Cop. While individual naming conventions at organizations may vary (Microsoft only suggests conventions for public and protected items), the list below is quickly becoming the de-facto standard in the industry. Please note the absence of Hungarian Notation except in visual controls. These naming standards should find their way into all of your .NET development, including ASP.NET Web applications and .NET Windows Forms applications.
Note that while this document predates the online and printed standards documentation from Microsoft, everything below which indicates it is based on .NET library standards is consistent with that documentation. In areas where Microsoft has not provided guidance (Microsoft generally doesn't care what you do in private/non-exposed code. In fact, they aren't even consistant in their internal code in the .NET framework), de facto standards have emerged, and I have captured them here.
The "ux" naming convention for controls is something I have added and found to be helpful. It is not based on any official standards, but instead based upon a multitude of projects by my teams and others, as well as on-line discussions on the topic. While I strongly recommend that you follow Microsoft guidelines when present, I encourage you to try out the items marked as extensions below and see how they work for you before committing to them.
| Type | Standard / Convention | Example |
| Namespaces | Standard Based Upon Microsoft .NET Library Standards Pascal Case, no underscores. Use CompanyName.TechnologyName as root. If you don't have a company, use your domain name or your own initials. Note that any acronyms of three or more letters should be pascal case (Xml instead of XML) instead of all caps. Why: This convention is consistent with the .NET Framework and is easy to read. | AppliedIS.TimeCard.BusinessRules IrritatedVowel.Controllers PeteBrown.DotNetTraining.InheritanceDemoPeteBrown.DotNetTraining.Xml |
| Assemblies | Standard Based Upon Microsoft .NET Library Standards If the assembly contains a single name space, or has an entire self-contained root namespace, name the assembly the same name as the namespace. Why: This convention is consistent with the .NET Framework and is easy to read. More importantly, however, it keeps your assembly names and namespaces lined up, making it really easy to figure out what is any particular assembly, and what assembly you need to reference for any given class. | AppliedIS.TimeCard.BusinessRules.dll |
| Classes and Structs | Standard Based Upon Microsoft .NET Library Standards Pascal Case, no underscores or leading "C" or "cls". Classes may begin with an "I" only if the letter following the I is not capitalized, otherwise it looks like an Interface. Classes should not have the same name as the namespace in which they reside. Any acronyms of three or more letters should be pascal case, not all caps. Try to avoid abbreviations, and try to always use nouns. Why: This convention is consistent with the .NET Framework and is easy to read. | Widget |
| Collection Classes | Standard Based Upon Microsoft .NET Library Standards Follow class naming conventions, but add Collection to the end of the name Why: This convention is consistent with the .NET Framework and is easy to read. | WidgetCollection |
| Delegate Classes | Standard Based Upon Microsoft .NET Library Standards Follow class naming conventions, but add Delegate to the end of the name Why: This convention is consistent with the .NET Framework and is easy to read. | WidgetCallbackDelegate |
| Exception Classes | Standard Based Upon Microsoft .NET Library Standards Follow class naming conventions, but add Exception to the end of the name Why: This convention is consistent with the .NET Framework and is easy to read. | InvalidTransactionException |
| Attribute Classes | Standard Based Upon Microsoft .NET Library Standards Follow class naming conventions, but add Attribute to the end of the name Why: This convention is consistent with the .NET Framework and is easy to read. | WebServiceAttribute |
| Interfaces | Standard Based Upon Microsoft .NET Library Standards Follow class naming conventions, but start the name with "I" and capitalize the letter following the "I" Why: This convention is consistent with the .NET Framework and is easy to read. It also distinguishes classes from interfaces, where (unlike in VB6) are truly different beings. This avoid name collisions as well, as it is quite common to have IFoo and a class named Foo that implements IFoo. | IWidget |
| Enumerations | Standard Based Upon Microsoft .NET Library Standards Follow class naming conventions. Do not add "Enum" to the end of the enumeration name. If the enumeration represents a set of bitwise flags, end the name with a plural. Why: This convention is consistent with the .NET Framework and is easy to read. | SearchOptions (bitwise flags) AcceptRejectRule (normal enum) |
| Functions and Subs | Standard Based Upon Microsoft .NET Library Standards Pascal Case, no underscores except in the event handlers. Try to avoid abbreviations. Many programmers have a nasty habit of overly abbreviating everything. This should be discouraged. Functions and subs must differ by more than case to be usable from case-insensitive languages like Visual Basic .NET Why: This convention is consistent with the .NET Framework and is easy to read. | VB: Public Sub DoSomething(...) C#: public void DoSomething(...) |
| Properties and Public * Member Variables | Standard Based Upon Microsoft .NET Library Standards Pascal Case, no underscores. Try to avoid abbreviations. Members must differ by more than case to be usable from case-insensitive languages like Visual Basic .NET. Why: This convention is consistent with the .NET Framework and is easy to read. | VB: Public Property RecordID As Integer C#: public int RecordID |
| Parameters | Standard Based Upon Microsoft .NET Library Standards Camel Case. Try to avoid abbreviations. Parameters must differ by more than case to be usable from case-insensitive languages like Visual Basic .NET. Why: This convention is consistent with the .NET Framework and is easy to read. | VB: ByRef recordID As Integer C#: ref int recordID |
| Procedure-Level Variables | Standard Based Upon De facto Industry-Accepted Practices Camel Case Why: This convention is consistent with the .NET Framework and is easy to read. It also avoids naming collisions with class-level variables (see below) | VB: Dim recordID As Integer C#: int recordID ; |
| Class-Level Private and Protected Variables | Standard Based Upon De facto Industry-Accepted Practices Camel Case with Leading Underscore. In VB.NET, always indicate "Protected" or "Private", do not use "Dim". Use of "m_" is discouraged, as is use of a variable name that differs from the property by only case, especially with protected variables as that violates compliance, and will make your life a pain if you program in VB.NET, as you would have to name your members something different from the accessor/mutator properties. Of all the items here, the leading underscore is really the only controversial one. I personally prefer it over straight underscore-less camel case for my private variables so that I don't have to qualify variable names with "this." to distinguish from parameters in constructors or elsewhere where I likely will have a naming collision. With VB.NET's case insensitivity, this is even more important as your accessor properties will usually have the same name as your private member variables except for the underscore. As far as m_ goes, it is really just about aesthetics. I (and many others) find m_ ugly, as it looks like there is a hole in the variable name. It's almost offensive. I used to use it in VB6 all the time, but that was only because variables could not have a leading underscore. I couldn't be happier to see it go away. Microsoft recommends against the m_ (and the straight _) even though they did both in their code. Also, prefixing with a straight "m" is right out. Of course, since they code mainly in C#, they can have private members that differ only in case from the properties. VB folks have to do something else. Rather than try and come up with language-by-language special cases, I recommend the leading underscore for all languages that will support it. If I want my class to be fully CLS-compliant, I could leave off the prefix on any C# protected member variables. In practice, however, I never worry about this as I keep all potentially protected member variables private, and supply protected accessors and mutators instead. Why: In a nutshell, this convention is simple (one character), easy to read (your eye is not distracted by other leading characters), and successfully avoids naming collisions with procedure-level variables and class-level properties. | VB: Private _recordID As Integer C#: private int _recordID ; |
| Controls on Forms | An Extension to the Standards In recent projects (since 2002 or so), I have taken to a single prefix for all my UI controls. I typically use "ux" (I used to use "ui", but it wasn't set apart well in intellisense). "ux" comes from my usual design abbreviations where it means "User eXperience", which has also since become a popular acronym. I have found this to be extremely helpful in that I get the desired grouping in the intellisense even better than if I use "txt", "lbl" etc. It also allows you to change combo boxes to text boxes etc. without having to change the names - something that happens often during initial prototyping, or when programming using highly iterative agile/xp methodologies. Why: This convention avoids problems with changing control types (textboxes to drop-down lists, or simple text box to some uber textbox, or text box to date picker, for example), and groups the items together in intellisense. It is also much shorter than most Hungarian conventions, and definitely shorter and less type-dependent than appending the control type to the end of the variable name. I will use generic suffixes which allow me enough freedom to change them around. | "ux" prefix uxUserID, uxHeader, uxPatientDateOfBirth, uxSubmit |
| Constants | Standard Based Upon Microsoft .NET Library Standards Same naming conventions as public/private member variables or procedure variables of the same scope. If exposed publicly from a class, use PascalCase. If private to a function/sub, use camelCase.. Do not use SCREAMING_CAPS Why: This convention is consistent with the .NET Framework and is easy to read. A sizable section of the Framework Design Guidelines is dedicated to why they chose not to go the SCREAMING_CAPS route. Using SCREAMING_CAPS also exposes more of the implementation than is necessary. Why should a consumer need to know if you have an enum, or (perhaps because they are strings) a class exposing public constants? In the end, you often want to treat them the same way, and black-box the implementation. This convention satisfies that criteria. | SomeClass.SomePublicConstant localConstant _privateClassScopedConstant |
* Public class-level variables are universally frowned upon. It is considered to be a much better practice to use property procedures (accessors and mutators) to provide read and/or write access to a private member variable. If you must expose a member variable to other classes using "Public", follow the property naming conventions, but don't complain if your guilty conscience keeps you up at night ;-).
Please don't copy and paste these conventions on your own site. Feel free instead to link directly to this page. That way you get the ability to automatically get updates when I make them, as well as get that warm fuzzy you get by not copying someone else's work. Schools and accredited educational institutions can paste these conventions on their own sites if and only if they include a direct link to this page an an attribution for the source of the information from "Pete Brown's irritatedVowel.com". Thank you for respecting my wishes on this.
You Can find the standards for publicly exposed classes/properties etc at MSDN . If you want to run a tool to validate your code for public standards and required practices, download FXCop or use the analysis tools in Visual Studio 2005+.
.NET Programming Links
Links
| Good Mailing Lists | |
| VISBAS-L | http://peach.ease.lsoft.com/archives/visbas-l.html |
| Developmentor .Net Lists | http://discuss.develop.com/ |
| Useful Search Sites | |
| CodeHound - Programmer's Search Engine | http://www.CodeHound.com |
| Google Newsgroup Search | http://www.deja.com/ |
| .NET and Other Resource Sites | |
| .NET articles and Links | http://www.yoda.arachsys.com/csharp/ |
| GotDotNet.com | http://www.GotDotNet.com |
| WindowsForms.Net | http://www.windowsforms.net/Default.aspx |
| Asp.Net | http://www.asp.net/Default.aspx |
| Microsoft Patterns and Practices | http://www.microsoft.com/resources/practices |
| C#.net | http://www.csharp.net |
| CodeProject C# Site | http://www.codeproject.com/csharp/ |
| .NET Spider | http://www.dotnetspider.com |
| IIS FAQs | http://www.iisfaq.com/ |
| UDDI Resources | http://www.uddi.org/solutions.html |
| Microsoft VS.Net Home | http://msdn.microsoft.com/vstudio/ |
| .Net Hosting | http://www.brinkster.com |
| OpenWave SDK (Phone Emulator) | http://www.openwave.com/products/developer_products/ |
| .NET Rocks Talk Show | http://www.dotnetrocks.com/ |
| A site with tons of connection strings (nice!) | http://www.connectionstrings.com |
| MSDN TV | http://msdn.microsoft.com/msdntv/ |
| Specific Articles of Interest | |
| Older Web Services vs. Remoting Performance Comparison | http://msdn.microsoft.com/webservices/building/default.aspx?pull=/library/en-us/dnbda/html/bdadotnetarch14.asp |
| Death of the Browser - Why you should use Windows Forms | http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadvnet/html/vbnet10142001.asp |
| Gang of Four (GoF) Patterns for .Net/C# | http://www.dofactory.com/Patterns/Patterns.aspx |
| Article on Creating HttpHandlers and HttpModules in .Net | http://www.15seconds.com/issue/020417.htm |
| Installation and Deployment | |
| .NET Framework Bootstrap Installer | http://microsoft.com/downloads/details.aspx?FamilyId=66350891-D15B-446B-BD69-F7F849224A00&displaylang=en |
| Windows Updater Application Block | http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/updater.asp?frame=true |
| How to Distribute Config Files to Smart Clients (Windows Forms Apps) via the Web | http://www.ondotnet.com/pub/a/dotnet/2003/01/27/ztd.html |
| Windows Forms Deployment Options | http://www.windowsforms.net/Default.aspx?tabindex=3&tabid=40#Deployment |
| Standards and Specifications | |
| C# ECMA Spec | http://www.ecma-international.org/publications/standards/ECMA-334.HTM |
| C# 2.0 Spec | http://msdn.microsoft.com/vcsharp/team/language/default.aspx |
| WSDL Spec | http://www.w3.org/TR/wsdl |
| For programming standards and naming conventions, see the link on the left menu. | |
| Whidbey (VS .NET 2005) Information | |
| MSDN Whidbey Site (VS .NET 2005) | http://msdn.microsoft.com/vstudio/whidbey/default.aspx |
| The Whidbey Chronicles - IDE Enhancements for C# Developers | http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20040219CSHARPDF/manifest.xml |
| ASP.NET 2.0 | http://www.asp.net/whidbey/ |
| Examples and Components | |
| Terrarium (Better than Pong.Net!) ;-) | http://www.gotdotnet.com/terrarium/whatis/ |
| Google Web Service | http://www.google.com/apis/ |
| Microsoft Exception Handling Application Block | http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/emab-rm.asp |
| VS.Net Power Toys and other Stuff | http://www.gotdotnet.com/team/ide/ |
| Additional Tools, Test-Driven Development, and Interesting Stuff | |
| NUnit Unit Testing Framework | http://www.nunit.org/ |
| XML Acceleration Appliance (Good for Web Services) | http://www.datapower.com/ |
| .NET Managed Data Providers | |
| CoreLab MySQL Direct Managed Provider | http://crlab.com/mysqlnet/ |
| MySqlNet MySQL and Postgres Managed Provider | http://sourceforge.net/projects/mysqlnet/ |
| CoreLab Oracle Direct Managed Provider | http://crlab.com/oranet/ |
| Corelab Postgres Direct Managed Provider | http://crlab.com/pgsqlnet/ |
| Microsoft Oracle Managed Provider | http://www.microsoft.com/downloads/details.aspx?FamilyId=4F55D429-17DC-45EA-BFB3-076D1C052524&displaylang=en |
| Oracle ODP Managed Provider | http://otn.oracle.com/tech/windows/odpnet/content.html |
| .NET Ports to Other Platforms and Enhancements/Research/Languages | |
| Mono on Linux | http://www.go-mono.com/ |
| Microsoft Shared Source CLI - Rotor (Free BSD, OS X, Win XP) | http://msdn.microsoft.com/net/sscli |
| On the Death of Microsoft Shared Source CLI Community Site | http://weblogs.cs.cornell.edu/AllThingsDistributed/archives/000525.html |
| Old Generics Support in C# (SSCLI Gyro) | http://research.microsoft.com/projects/clrgen/ |
| Microsoft F# | http://research.microsoft.com/projects/ilx/fsharp.aspx |
jQuery showing or hiding effects
In this article I explain some simple effects showing or hiding some elements on the page using jQuery.
In jQuery the two function show() and hide() simply work this.
Let's take example for show and hide div tag.
For that first takes two link for Show and Hide and div with some text.
<a href="#" id="btnShow">Show</a>
<a href="#" id="btnHide">Hide</a>
<div>Hello Demo for showing & hiding div using jQuery.</div>
In jQuery put script for showing or hiding elements insode $(document).ready() function.
<script src="http://code.jquery.com/jquery-latest.js" ></script>
<script>
$(document).ready(function(){
$('#btnShow').click(function(){
$('div').show("fast"); });
$('#btnHide').click(function(){
$("div").hide(1000); });
});
</script>
In above code simply show/hide <div> tag when btnShow click it show <div> tag and when btnHide click it hide <div> tag.
In above code you can see dollar sign"$" is nothing but a shorthand notation for find method in JQuery.
How to use Selector?
If you want to select any element in the page then you can use dollar sign "$" to get that element.
- Element Selector : for selecting all matching tag or elements use $('tagname') like $('div').
- ID Selector : for selecting element with the given id attribute use $('#id') like $('#btnShow').so,(#) used for access the element with id.
- CSS selector: for find all element with a CSS class use $('.ClassName') select all element with ClassName CSS class..
In jQuery one more event toggle( ) which handle both events show() and hide().If they are shown, toggle makes them hidden (using the hide method). If they are hidden, toggle makes them shown (using the show method).
<a href="#" id="btnToggle">Toggle</a>
$('#btnToggle').click(function () {
$('div').toggle("slow"); });
In above all events show(speed),hide(speed),toggle(speed) use can specify speed for showing and hiding elements.Speed may be "slow","normal","fast" or the number of milliseconds to run the animation (e.g. 1000).
jQuery IntroductionjQuery is a new kind of JavaScript Library or FrameWork,created by John Resig in 2006.jQuery is most powerfull JavaScript Library. jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development.jQuery is designed to change the way that you write JavaScript.
How to use jQuery? First download jQuery latest version (v.1.3.1) from jQuery.com and add javascript to your page.
<html> </head> In above code $(document).ready event is work same as window.onload method of javascript.And executed when entire page and resources have been loaded in the DOM.All the events which you want in jQuery must call inside the $(document).ready() function. So,The events in Jquery are bound to elements inside the $(document).ready() method.The elements get bound when document.ready is fired. Also,you can add as many $(document).ready events on your page as you like but they are executed in the order they are added. |
Find Nth highest record from tableIn interview you can faced question like to give solution(query) for find Nth highest Record/number/salary from given employee table. TO find out 3rd highest salary from table --Find 3rd highest salary SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 3 salary FROM tblSalary ORDER BY salary DESC) S ORDER BY salary General form to find to Nth highest salary from table --Find Nth highest salary SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP N salary FROM tblSalary ORDER BY salary DESC) S ORDER BY salary There are many solution to solve to this but above solution is easiest. Take other possible solution, SELECT MIN(salary) FROM tblSalary WHERE salary IN (SELECT DISTINCT TOP 3 salary FROM tblSalary ORDER BY salary DESC) --or-- SELECT MIN(salary) FROM (SELECT DISTINCT TOP 3 salary FROM tblSalary ORDER BY salary DESC) S |
SQL Server String FunctionsString functions are mainly used to change the case of strings,concatenate strings,reverse strings,extract various part of strings and perform many other types of string manipulation. In SQL Server there is a Several built-in string functions to perform string manipulations.All below functions takes string input value and return a string or numeric value. ASCII : Returns the ASCII code value of a character(leftmost character of string).
UNICODE : UNICODE function works just like ASCII function,except returns Unicode standard integer value. UNICODE could be useful if you are working with international character sets.
LOWER : Convert character strings data into lowercase.
UPPER : Convert character strings data into Uppercase.
LEN : Returns the length of the character string.
REPLACE : Replaces all occurrences of the second string(string2) in the first string(string1) with a third string(string3).
LEFT : Returns left part of a string with the specified number of characters counting from left.LEFT function is used to retrieve portions of the string.
RIGHT : Returns right part of a string with the specified number of characters counting from right.RIGHT function is used to retrieve portions of the string.
LTRIM : Returns a string after removing leading blanks on Left side.(Remove left side space or blanks)
RTRIM : Returns a string after removing leading blanks on Right side.(Remove right side space or blanks)
REVERSE : Returns reverse of a input string.
REPLICATE : Repeats a input string for a specified number of times.
SPACE : Returns a string of repeated spaces.The SPACE function is an equivalent of using REPLICATE function to repeat spaces.
SUBSTRING : Returns part of a given string. SUBSTRING function retrieves a portion of the given string starting at the specified character(startindex) to the number of characters specified(length).
STUFF : Deletes a specified length of characters and inserts another set of characters at a specified starting point. STUFF function is useful to inserts a set of characters(string2) into a given string(string1) at a given position.
CHARINDEX : Returns the starting position of the specified string(string1) in a character string(string2).
PATINDEX : PATINDEX function works very similar to CHARINDEX function.PATINDEX function returns the starting position of the first occurrence of a pattern in a specified string, or zeros if the pttern is not found. Using PATINDEX function you can search pattern in given string using Wildcard characters(%).The % character must come before and after pattern.
|
SQL Server Date Time Format
In SQL Server used Cast or Convert function to Format Date Time value or column into a specific date format.Both function are used to convert datetime to varchar or string.
CAST function Syntax: CAST(expression as data_type)
Let's convert current date time to varchar
select cast(getdate() as varchar)
CONVERT function is used to change or convert the DateTime formats.By using convert function you can get only Date part or only Time part from the datetime.
CONVERT Function Syntax: CONVERT(data_type,expression,date Format style)
Let's take Sql Server DateTtime styles example:
Format | Query |
USA mm/dd/yy | select convert(varchar, getdate(), 1) |
ANSI yy.mm.dd | select convert(varchar, getdate(), 2) |
British/French dd/mm/yy | select convert(varchar, getdate(), 3) |
German dd.mm.yy | select convert(varchar, getdate(), 4) |
Italian dd-mm-yy | select convert(varchar, getdate(), 5) |
dd mon yy | select convert(varchar, getdate(), 6) |
Mon dd, yy | select convert(varchar, getdate(), 7) |
USA mm-dd-yy | select convert(varchar, getdate(), 10) |
JAPAN yy/mm/dd | select convert(varchar, getdate(), 11) |
ISO yymmdd | select convert(varchar, getdate(), 12) |
mon dd yyyy hh:miAM (or PM) | select convert(varchar, getdate(), 100) |
mm/dd/yyyy | select convert(varchar, getdate(), 101) |
yyyy.mm.dd | select convert(varchar, getdate(), 102) |
dd/mm/yyyy | select convert(varchar, getdate(), 103) |
dd.mm.yyyy | select convert(varchar, getdate(), 104) |
dd-mm-yyyy | select convert(varchar, getdate(), 105) |
dd mon yyyy | select convert(varchar, getdate(), 106) |
Mon dd, yyyy | select convert(varchar, getdate(), 107) |
hh:mm:ss | select convert(varchar, getdate(), 108) |
Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM) | select convert(varchar, getdate(), 109) |
mm-dd-yyyy | select convert(varchar, getdate(), 110) |
yyyy/mm/dd | select convert(varchar, getdate(), 111) |
yyyymmdd | select convert(varchar, getdate(), 112) |
Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h) | select convert(varchar, getdate(), 113) or select convert(varchar, getdate(), 13) |
hh:mi:ss:mmm(24h) | select convert(varchar, getdate(), 114) |
SQL server Date Time Function
Date time functions allow manipulating columns with DATETIME/SMALLDATETIME data types. SQL server Date Time Function:
GETDATE and GETUTCDATE Functions
GETDATE and GETUTCDATE Functions are Nondeterministic function. Both functions returns the current date and time. GETDATE returns current system date and time of the computer where SQL Server is running.
GETUTCDATE returns current UTC time (Universal Time Coordinate or Greenwich Mean Time). The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer on which the instance of Microsoft SQL Server is running.
DATEADD Functions
DATEADD function is Deterministic function. DATEADD Function adds a certain interval of time to the specified date and time value.
Syntax: DATEADD (datepart , number, date )
DATEADD returns a new date time value based on adding an interval to the specified date and time value.
DATEDIFF Function
DATEDIFF function is Deterministic function. DATEDIFF () gives the difference between the two date values.
Syntax: DATEDIFF ( datepart , startdate , enddate )
DATEDIFF returns number of date and time boundaries crossed between two specified dates. In DATEDIFF function start date is subtracted from end date. If start date is later than end date, a negative value is returned.
DATEPART Function
To retrieve any part of date and time use DATEPART function.
Syntax: DATEPART ( datepart , date )
DATEPART function takes two arguments 1)part of the date that you want to retrieve and 2)date itself. The DATEPART function returns an integer that represents date part of specified date.
| DATEPART | Output |
| SELECT DATEPART(year, '2009-02-13 18:35:06.523') | 2009 |
| SELECT DATEPART(quarter, '2009-02-13 18:35:06.523') | 1 |
| SELECT DATEPART(month, '2009-02-13 18:35:06.523') | 2 |
| SELECT DATEPART(dayofyear, '2009-02-13 18:35:06.523') | 44 |
| SELECT DATEPART(day, '2009-02-13 18:35:06.523') | 13 |
| SELECT DATEPART(week, '2009-02-13 18:35:06.523') | 7 |
| SELECT DATEPART(weekday, '2009-02-13 18:35:06.523') | 6 |
| SELECT DATEPART(hour, '2009-02-13 18:35:06.523') | 18 |
| SELECT DATEPART(minute, '2009-02-13 18:35:06.523') | 35 |
| SELECT DATEPART(second, '2009-02-1 18:35:06.523') | 6 |
| SELECT DATEPART(millisecond, '2009-02-1 18:35:06.523') | 523 |
DATENAME Function
DATENAME Function returns a character string that represents date part of the specified date.
Syntax: DATENAME ( datepart , date )
DATENAME function takes two arguments same as DATEPART function 1) part of the date that you want to retrieve and 2) date itself.
If you want the name of month
SELECT DATENAME (month, '2009-02-13 18:35:06.523') => Output : February
If you want the name of week day
SELECT DATENAME (weekday, '2009-02-13 18:35:06.523') => Output : Friday
DAY, MONTH, and YEAR Functions
All of this DAY, MONTH, and YEAR functions takes a single date value as a argument. Each of this function returns an integer that represents respective portions of the date.
SELECT DAY('2009-02-1 18:35:06.523') as 'Day', MONTH('2009-02-1 18:35:06.523') as 'Month', YEAR('2009-02-1 18:35:06.523') as 'Year'
Each of this functions equivalent to DATEPART function. Like DAY is equivalent to DATEPART (dd, date), MONTH is equivalent to DATEPART (mm, date) and YEAR is equivalent to DATEPART (yy, date).
SQL Server 2005 Query Analyzer shortcuts.
Some important shortcuts list for query execute.Using this shortcuts you can save lots of time.
- CTRL+E : Execute Query
- F5 : Execute Query
- ALT+BREAK : Cancel Query
- CTRL+D : Display results in grid format
- ALT+F1 : Database object info
- CTRL+F5 : Parse query and check syntax
- CTRL+K : Display/hide execution plan
- CTRL+L : Display execution plan
- CTRL+N : New Query window
- CTRL+SHIFT+F : Save results to file
- CTRL+Delete : Delete through the end of the line
.Net Shortcut Keys
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | Dotnet Shortcut Keys | ||
| 3 | |||
| 4 | S.No | Shortcut Key | Function |
| 5 | |||
| 6 | 1 | Ctrl + Shift + N | Create New Project |
| 7 | 2 | Ctrl + N | Create New File |
| 8 | 3 | Ctrl + Shift + O | Open Project |
| 9 | 4 | Ctrl + O | Open File |
| 10 | 5 | Ctrl + S | Save File |
| 11 | 6 | Ctrl + Shift + S | Save All File |
| 12 | 7 | Alt + F + X | Close All |
| 13 | 8 | Ctrl + Z | Undo |
| 14 | 9 | Ctrl + Y | Redo |
| 15 | 10 | Ctrl + X | Cut |
| 16 | 11 | Ctrl + C | Copy |
| 17 | 12 | Ctrl + V | Paste |
| 18 | 13 | Ctrl + A | Select All |
| 19 | 14 | Ctrl + F | Quick Find |
| 20 | 15 | Ctrl + H | Quick Replace |
| 21 | 16 | Ctrl + Shift + F | Find in Files |
| 22 | 17 | Ctrl + Shift + H | Replace in Files |
| 23 | 18 | Alt + F12 | Find Symbol |
| 24 | 19 | Ctrl + G | Go To Line No. |
| 25 | 20 | Ctrl + P | |
| 26 | 21 | Ctrl + K, Ctrl + D | Format Document |
| 27 | 22 | Ctrl + K, Ctrl + F | Format Selection |
| 28 | 23 | Ctrl + Shift + U | Make Upper Case |
| 29 | 24 | Ctrl + U | Make Lower Case |
| 30 | 25 | Ctrl + K, Ctrl + \ | Delete Horizontal White Space |
| 31 | 26 | Ctrl + R, Ctrl + W | View White Space |
| 32 | 27 | Ctrl + E, Ctrl + W | Word Wrap |
| 33 | 28 | Ctrl + I | Incremental Search |
| 34 | 29 | Ctrl + K, Ctrl + C | Comment Selection |
| 35 | 30 | Ctrl + K, Ctrl + U | Uncomment Selection |
| 36 | 31 | Ctrl + K, Ctrl + K | Toggel Book Mark |
| 37 | 32 | Ctrl + K, Ctrl + P | Previous Book Mark |
| 38 | 33 | Ctrl + K, Ctrl + N | New Book Mark |
| 39 | 34 | Ctrl + K, Ctrl + L | Clear Book Marks |
| 40 | 35 | Ctrl + Shift + K, Ctrl + Shift + P | Previous Book Mark in Folder |
| 41 | 36 | Ctrl + Shift + K, Ctrl + Shift + N | Next Book Mark in Folder |
| 42 | 37 | Ctrl + K, Ctrl + H | Remove Task List Shortcut |
| 43 | 38 | Ctrl + M, Ctrl + M | Toggel Out Lining Expansion |
| 44 | 39 | Ctrl + M, Ctrl + L | Toggel All Out Lining |
| 45 | 40 | Ctrl + M, Ctrl + P | Stop Out Lining |
| 46 | 41 | Ctrl + M, Ctrl + O | Collapse to Definitions |
| 47 | 42 | Ctrl + K, Ctrl + M | Generate Method Stub |
| 48 | 43 | Ctrl + J | List Members |
| 49 | 44 | Ctrl + Shift + Space | Parameter Info |
| 50 | 45 | Ctrl + K, Ctrl + I | Quick Info |
| 51 | 46 | Alt + Right Arrow | Complete Word |
| 52 | 47 | Ctrl + K, Ctrl + X | Insert Snippet |
| 53 | 48 | Ctrl + K, Ctrl + S | Surround With |
| 54 | 49 | Ctrl + Alt + S | Open Server Explorer |
| 55 | 50 | Ctrl + Alt + L | Open Solution Explorer |
| 56 | 51 | Ctrl + K, Ctrl + W | Bookmark Window |
| 57 | 52 | Ctrl + Shift + C | Class View |
| 58 | 53 | Ctrl + \ , Ctrl + D | Code Definition Window |
| 59 | 54 | Ctrl + Alt + J | Object Browser |
| 60 | 55 | Ctrl + \ , Ctrl + E | Error List |
| 61 | 56 | Ctrl + Alt + O | Output |
| 62 | 57 | F4 | Properties window |
| 63 | 58 | Ctrl + \ , Ctrl + T | Task List |
| 64 | 59 | Ctrl + Alt + X | Tool Box |
| 65 | 60 | Ctrl + Alt + A | Command Window |
| 66 | 61 | Ctrl + Alt + T | Document Outline |
| 67 | 62 | Ctrl + Shift + E | Resource View |
| 68 | 63 | Alt + F8 | Macro Explorer |
| 69 | 64 | Ctrl + Alt + R | Web Browser |
| 70 | 65 | Shift + Alt + Enter | Full Screen |
| 71 | 66 | Ctrl + Shift + A | Add New Item |
| 72 | 67 | Shift + Alt + A | Add Existing Item |
| 73 | 68 | Ctrl + Shift + B | Build Solution |
| 74 | 69 | Ctrl + Alt + B | Break Points |
| 75 | 70 | F5 | Start Debugging |
| 76 | 71 | Ctrl + F5 | Start without Debugging |
| 77 | 72 | F10 | Step Over |
| 78 | 73 | F11 | Step In |
| 79 | 74 | F9 | Toggel Breakpoint |
| 80 | 75 | Ctrl + Shift + F9 | Delete All Break points |
| 81 | 76 | Ctrl + F1 | How Do I Help |
| 82 | 77 | Ctlr + Alt + F3 | Search |
| 83 | 78 | Ctrl + Alt + F1 | Contents |
| 84 | 79 | Ctrl + Alt + F2 | Index |
| 85 | 80 | Ctrl + Page Up | View Designer |
| 86 | 81 | Ctrl + Page Down | View Source |
| 87 |
Subscribe to:
Posts (Atom)