Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. The Express edition is free and ideal for learning, developing, powering desktop, web & small server applications. The SQL Server 2014 Express release includes the full version of SQL Server 2014 Management
Temp Table or Table variable or CTE are commonly used for storing data temporarily in SQL Server. In this article, you will learn the differences among these three.
Many times, you required to show information of each transaction and also keep a Running Total and Final Total like GridView in Asp.Net. In this article, I am going to explain, how can you achieve this using SQL Query in simple and easy way.
Sometimes, you required to fetch or modify the records based on some conditions. In this case, you may use cursor or loop for modify your records. In this situation Case expression is best alternative for Cursor/looping and also provides better performance.
Identity field is usually used as a primary key. When you insert a new record into your table, this field automatically assign an incremented value from the previous entry. Usually, you can't insert your own value to this field.
SQL join clause is used to to retrieve data from two or more database tables. In previous article, I have explained the Different Types of SQL Joins. In this article, I would explain the difference among inner join, equi join and natural join.
In programming, we have many naming conventions like camelCase, PascalCase, under_scores etc. But each and every organization has its own naming conventions. In this article, I would like to share some common and useful naming conventions and standards that you should use while programming with SQL Server.
While working with SQL Server, we connect to the different-different data server. As a result of this SSMS has a list of diffrenet SQL Server which we have used. Sometimes this list create confusion and we can try to make the connection to SQL Server which does not exist or we does not have access to it. To resolve this issue, we should clear this server list from SSMS.
By default, SQL Server 2000, 2005, 2008 and 2008R2 doesn't provide intellisense like Visual Studio. While writing T-SQL statements, we need to recall the database table structure (including columns, their data types, size) and other database objects structure like stored procedure, view and functions again and again. Sometimes it becomes tedious task.
Do you have fun with SQL Server?. Let's start fun with SQL Server. Suppose you want to swap the values of two columns of a table in SQL Server, how could you achieve this tricky task?. Actually, it is simple and so funny.
SQL Server 2012 has a powerful set of fetures to increase productivity of developers and database administrators. SQL Server 2012 has a new SSMS that is built on Visual Studio 2010 and support various productivity features of Visual Studio 2010 like multi monitor support and pull out the tabs from main work area to different monitor or out side the IDE.
Sometimes, there is a case, when we need to remove all tables, stored procedure, views and triggers completely from the database. If you have around 100 tables, stored procedure and views in your database, to remove these, completely from database became a tedious task. In this article, I would like to share the script
In SQL Server, there are two keys - primary key and foreign key which seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and foreign key.
In SQL Server, we have two keys - primary key and unique key which distinctively or uniquely identify a record in the database. Both the keys seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and unique key.
There are Inserted and Deleted logical tables in SQL Server. These tables are automatically created and managed by SQL Server internally to hold recently inserted, deleted and updated values during DML operations (Insert,Update,Delete) on a database table.
Real time project based training of “DotNetTricks” is exceptional because their explanation and implementation on project helped me lot to work on company projects. Because their real-time exposer is really practical and same as development of projects. They have cleared all my concepts and cleared my doubts. By doing the project based training, I have increased my confidence now I can develop something from scratch using NODEJS, AngularJS and Express.Js. I will suggest professions to go with them once you will remain with them.Kiran Kumar Mohanty (Senior Software Engineer at VeriFone India) MEAN Stack Development
"DotNetTricks" is truly great E-Learning Organisation which provides real time project based training for professionals .They relates the concepts with real time scenarios that really helps us to correlate with our project work. Because of their efforts, I am stronger and more flexible in my technology and thanks to "Mr.Shailendra Sir" for his excellent efforts and developments exposure, I recommend them without reservation."Bhawna Gunwani (Corporate Trainer) NodeJS Development
My experience with DotNetTricks has been nothing short of Amazing! The training they offer is real time and Mr.Shailendra is always patient enough to answer all the candidate queries and even goes one step further to demo any special scenarios requested by the candidates. The best thing I found about DotNetTricks is that, they allow you to attend sessions in a different batch if you want to repeat a particular session or if you have missed any particular session. I don't think there is any other training organization that provides this flexibility. Overall, a very informational session and definitely look forward to doing more trainings with DotNetTricks. Will absolutely recommend to anyone looking for real time, hands on technical training!Lakshmi Goyal (CEO, Archwings Global (IT Services)) ASP.NET MVC with AngularJS Development
I glad to say Thanks to dot net tricks!! dot net tricks is an unique Development training company, which only provide real time development training. while i was preparing to change my job I have reached dot net tricks website, I followed their blog and books & it was very fruitful for me since then i am big fan of dot net tricks. I have been following their books and blogs to improve my technical skills. Now after two year I again looking for change the job then I realize that in every email which I receive every recruiter looking for AngularJS and Node. So for learning Angular and node module I have looked for many trainers in the market and attended their demos session but finally I have attended Shailendra demo class and i realize that he is the best among all. Now few words about Shailendra Chauhan, he is very experienced and technically strong, he is providing the best project based training after discussing the concepts and real word examples after that all concepts he implements that’s in live project. I think this is best training company, Guys if you are looking for any training. I would highly recommend Dot Net Tricks!!Satish Kr Verma (Sr. Software Engineer) AngularJS Development
I believe that Dot Net Tricks is the best place for learning and updating ourselves moreover overcome from all issues that are face during development ...!! I come to know about Dot Net Tricks innovative way of providing real time project based training in 2014 through one of my friend who have taken class from Dot Net Tricks, during that time I started my career as a UI developer, my friend who have taken training in Angular JS working with HCL technology. Now after one and half year I have been looking for changing my job profile so that I have joined Dot Net Tricks again for updating MEAN Stack Developer. Few words to Shailendra Sir, Thank you very much sir for giving me a precious guidance by explaining through various real world scenario.Kuldeep Kr. Shakya (Sr. Project Executive) AngularJS Development
Dot Net Tricks has brought a new revolution in e-learning which reform the way of learning. Dot Net Tricks training best ever training i have gone through. It's compliantly changed my programming approach while developing software application. i'm feeling proud while writhing this testimonial.Rajat Sharma (Sr. Software Engineer) ASP.NET MVC with AngularJS Development
It was very good experience getting AngularJS Development Training with Dot Net Tricks. Dot net tricks a unique training institute for new updated technology in MVC and AngularJS. Mr. Shailendra always teaches latest technologies. Thanks Dot Net Tricks for teaching me in depth practical concept.Basant Badwal Kumar (Web Developer ) AngularJS Development
Thanks a lot for arranging such Technical training's and would like to join more such training's with Dot Net tricks. Training is lead by a great teacher "Shailendra" . Training has been great learning curve for me and I am still learning and going through the shared videos to capture things which I have missed.Nikhil adhikary (Module Lead at Mindtree) ASP.NET MVC with AngularJS Development
Thanks for providing me training on NodeJS technology, i want to request Dot Net Tricks management to host this kind of training for me. because i have got best value for my money which they have provided me advance training on real time project.Mohit Tyagi ( Software Engineer) NodeJS Development
Learning with the latest technology makes each person up-to-date, which plays a great role to compete with any situation. I am very thankful to Honorable Mr. Shailendra Sir, who encourages me to go with MEAN Stack Development. Being an author, Dot Net Tricks MEAN Stack Development Training is career turning point. I have learnt superior assistance from Sir in terms of Skill Development and Success Mantra. Always believe in Learning is Earning. Thank You Sir!Sanjay Kumar (Sr. Software Developer) MEAN Stack Development