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.
Dot Net Tricks is certainly a good platform to develop & strengthen your knowledge that's crucial to excelling in your professional. course are well structured to meet the current IT industry requirements. and as per my experience DNT is leader in latest technology training, especially for a working professional like me, and the way of teaching is superb of trainers, they clear all our doubts and make us understand complex course in a simple way.Rajendra Singh (Developer at IAP Company Pvt. Ltd) Xamarin Forms : Build Cross-platform Apps
Before joining the dot net tricks,i was wander what to do, all i groom just because of DNT staff, he gave me good suggestion on personal level and professional level as well, comes on teaching his great knowledge and experience give me good job as well as right way to write a code. Shailender sir gives some really simple examples to explain the complicated scenario with projects, you are excellent and motivating people to enjoy the class.Aditya Sharma (Sr. Software Developer ) Angular2 and Angular4 Development
Thanks to the Dotnettricks for all the support provided MVC And AngularJS training process, Course was covered extensively and all interview question were answered. there was the intense focus on the implementation of the concepts, sharing real life experience along with covering the course material. especially like the fact that the arguments are explained in details so that participants who are interested in the understanding can get an important contribution to their knowledge enhancement. I have completed my course with learned a new technology.DINESH PAGADALA (SOFTWERE ENGINEER ) ASP.NET MVC with Angular4 Development
Course offered by Dot Net Tricks very helpful in keeping myself updated with the best practices in the IT industry. This course helped me to boost my career and the course covered majorly important topics and help in building up application very quickly with clear understanding. i salute to staff of DNT always stand with support. This course content is very informative and the trainer's expertise helped me learn about the challenges involved in implementation.Puneet Jain (Software Engineer) ASP.NET MVC with Angular4 Development
I am so glad after join to dot net trick, It was a really nice training. Helped me a lot to enhance my skills. Our professor is not only a good tutor but also a true guide for student bright future. dot net trick to gain true knowledge with great guidance and helped me so much specially in cracking interview.Sulabh Kaushik (Software Developer) ASP.NET MVC with Angular4 Development
DNT training is really professional, and Services provided by them on installation & technical issues are mind blowing. This training was really helpful for me in understanding the mobile apps Technologies in Xamarin. In one word, I have received "Outstanding support" from DotNetTricks and its staff. trainers is very supportive. DNT is very well organized and structured organization. In DNT, you will find each bit of information scratch to In-depth. Training materials, Interview blogs, Assignment, Quiz and etc. are organized in proper way. Finally, I will recommend DotNetTricks to anybody, looking for instructor led live session to keep oneself up to date with the latest trends & technology.Hardeep Singh (Team Lead) Xamarin Forms : Build Cross-platform Apps
First of all thank you Shailendra sir for your great knowledge, amazing energy, good style of teaching and hard effort you put into MVC and angular JS class. This was the best class i joined, it helped me to enhance my skills. I think you are excellent at motivating people to enjoy the class and do their best. It's just incredible to see how different your approach is from others. It was great learning experience with you. You and this class will be remembered for long time. Thanks Dot Net Tricks...Vipul Kaushik (Associate Technical Lead ) ASP.NET MVC with Angular4 Development
It's a great experience to be part of dotnet tricks. this Training really helps me for improving my enhancements skills professionally also. If I talk about interview purpose it's really a great great opportunity because in training class this was my personal experience that Sir won't leave a single scenario that Interviewer going to ask you. He covers all the concepts theoretical as more focused on practical. If you really want to beat Interview and get good job and hike join dot net tricks.Deepali Panwar (Software Engineer ) ASP.NET MVC with Angular4 Development
First of all I would like to thank DNT for everything. Here is my experience in Dot Net Tricks - "When I came to know about DNT, honestly I didn't have much idea about Xamarin Forms and was looking for job. So I thought it would be a better option to join here and get some knowledge about real time project and few interviews, which would be a big thing for me. Then I was assured by the staff from the DNT and joined. From day one I felt a different energetic atmosphere in the class room. And about the staff all are well educated, trained and also very much friendly to everyone, as a student which helped me a lot, they never shown any irritation even though I was asking same things repeatedly. The main thing is that all the syllabus covered up in a proper manner, so that a student can understand each things about the training. And thanks for providing some important seminar which helped me a lot to crack a interview. Thank you DNT for making my career". I have ever taken so far in my life time, and day by day it’s getting better for me.I have got confidence facing Xamarin interviews and learned lot of new real time scenario. Shailendra Sir is a passionate trainer he give some really simple examples to explain the complicated scenarios. he always make us think and also answer our questions smartly. Keep rocking DotNetTricks, your team is doing great job.. Way to Go..Rajkishore Yadav (Sr. Software Developer) Xamarin Forms : Build Cross-platform Apps
I just completed my Xamarin Training in Dot Net Tricks with Great experience, I learned much more than expected. The course was good and very helpful. After this course I gained the my confidence and technical knowledge. if you want to learned training of Xamarin, I would definitely recommend you the DOT NET TRICKS is one of the best company. Thank you for DNT team and specially Shailendra Sir to enhance my technical knowledge in Mobiles apps background.Inder Negi ( Software Developer ) Xamarin Forms : Build Cross-platform Apps