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.
It was a great learning experience at dot net tricks from Shailendra Sir. I started the basics and went on to build a complete system, using some best practices in the project, I got all recorded sessions for the same for revision. Again, it was Awesome learning from DNT for ANGULAR JS.Navdeep Singh (Software Engineer) Angular2 and Angular1 Development
"DotNetTricks drew me in and rekindled my passion for MVC including various other technologies like AngularJs, Web API, LINQ and Bootstrap too. If you want to expand your career and focus and learn about all these technologies to the cutting edge, DotNetTricks embodies all these in their online program. I strongly recommend DotNetTricks..!!!"Preeti Jain (Technical Analyst ) ASP.NET MVC with Angular4 Development
"It has been a great learning experience at Dotnettrics. Shailendra is very professional and focuses on concepts until we gain the confidence. All the materials shared are good sources for any level of professionals. Recorded videos do help us to thoroughly understand.Thank your, team, for being supportive and enhancing the teaching concepts based on feedback."NagaDeepti Amirineni (Sr. Net developer/Lead 3M) ASP.NET MVC with Angular4 Development
Amazing Experience with Dot Net Tricks. I have attended the ASP.NET MVC with AngularJS Development course with Project (online training). In my 14 years of my software career I have attended various technical training but the training I got from Mr. Shailendra Chauhan is Superb and Excellent. I can assure that Dot Net Tricks provides the Top Quality Training both in Teaching and Course Material or Content. The teaching techniques of Mr. Shailendra is very Simple, Easy and Unique. Highly recommended to all who are looking for training from Dot Net Tricks.Joydeep Deb ( Co-Founder & Project Manager Izensys Technologies) ASP.NET MVC with Angular4 Development
After attending the "DotNetTricks" training for ASP.NET MVC with AngularJS, I gained much more knowledge in the topic of study, design, and architecture; implemented a project as well. Mr.Shailendra is an excellent trainer; he patiently listens to our queries and answers them well. Also, the topics are arranged in the proper manner; even if you are not that experienced, you can learn it quickly. Most important, they are not chasing you to join the course; they provide a demo class and you can decide. Definitely, I recommend every developer in Microsoft stream to undergo this training.Nebil Rasheed (Sr. Systems Analyst) ASP.NET MVC with Angular4 Development
"DotNetTricks" is truly great E-Learning Organization which provides real time project-based training for professionals. They provide best in-depth knowledge theoretical and practical as well as interview aspect, this training with help to learning new technology and switching new job, improve self-Confidence. 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.Ranveer Singh Godara (Technical Director ) ASP.NET MVC with Angular4 Development
Dot net Tricks is best training Organization for real time software development in new technologies. I visited this Organization and had a demo session and decided that this is a content. Always Shailendra sir answer all the candidate queries and even goes one step further to demo any special scenario requested by the candidates. If you want to repeat a particular session or if you have missed any particular session, Staff of DNT always allow to attend sessions in a different batch. DNT deliver training, which match with industry requirement and real time project development. It was very good experience getting AngularJS Development Training with Dot Net Tricks.Balaindu Pandey (Sr. Software Developer ) ASP.NET MVC with Angular4 Development
As my experience included only on windows side, I wanted to learn and quickly upgrade to web technologies and joined dotnettricks. It was amazing experience with Mr.Shailendra as he covers all the topics in depth and classes are flexible. Even if we miss, we can either take another batch classes or go through recording. In a month and half, I was able to reach proficient level at web technologies (MVC, AngualrJs, Angular 2, WebAPI and many more).Will absolutely recommend to anyone looking for real time, hands on technical training! Also I have joined MEAN now since the training quality is too good and you can learn many things in a month time.Raghavendra SK (Technical Anchor at Prime Focus Technologies) MEAN Stack 2 Development
I was on zero level when I have started my training with DotNetTricks, Today I can say with my confidence that I am an expert on NodeJS and AngularJS technologies. I truly want to say thanks to DotNetTricks for taking me on this Hight in development, I have not been only developing my company project but also, I am capable to help my team to do the same. Especially I want to say Thanks to Mr. Shailendra Chauhan for his technique of teaching and combining concepts with example that the great things about his teaching pedagogy.Shailendra Singh (Software Consultant ) MEAN Stack 2 Development
Shilendera sir given me best opportunity to improve my skills for NodeJS, WCF and MVC.I have learnt real time software development skills on these technologies Dotnettricks provide better environment for improving latest technologies for better career prospect, especially programmer updates their skills to crack interview for next higher level of job.Sarvesh kumar (Sr. software developer) NodeJS Development