Your Technical Consultant
Hello Everybody! In this article, we want to discuss how to update a table from another table in SQL Server. Before we get started, if you want to know about format DateTime, please go through the following article: How to […]
Continue reading How to Update a Table from Another Table in SQL Server (With Examples)
Primary key and Unique key are two important concept in relational database, and used to uniquely identify a row in a table. Both primary key and unique key can identify a row uniquely but there are some subtle difference between them which we will see in this article. In fact primary key vs unique is a popular SQL interview questions along with classics like truncate vs delete and How to manage transaction in database, mostly asked to fresher and 2 to 3 years experience guys in any programming language. SQL is not just limited to any DBA or PLSQL developer but its an important skill even for Java programmer and you can expect SQL interview question even in many Java interviews. Some time programmer also confuse between foreign key and unique key, which is primary key of other table in relation.
Continue reading What is difference between Primary Key and Unique Key
In the following lesson, you can learn how to implement each group calculation as Subtotal and Grand Total for all groups in ASP.NET GridView. I have used Microsoft’s Pubs database for sample data. A Subtotal is the total of the […]
Continue reading How to Calculate Subtotal and Grand Total in GridView
I encountered the situation recently where I needed to find the size of the log file, file location. Here is the script, if you remove the WHERE condition you will find the result for all the databases.
Continue reading Check Database Physical File Paths and Sizes in SQL Server – DBA Guide
Sometimes we browse web applications and due to some reason, it takes more time to load the page. At the time of the loading page, it shows a blank (white page) in browse to the user. Some users seeing a […]
Continue reading Request Processing / Loading effect with C# and jQuery
The SIMPLE recovery model is the simplest among the available models. It supports full, differential, and file-level backups. Transaction log backups are not supported. The log space is reused whenever the SQL Server background process checkpoint operation occurs. The inactive […]
Continue reading How to Enable Simple Recovery Model at SQL Server
In this article, we want to discuss HTTP, HTTPS, Similarities, and Differences between HTTP vs HTTPS. Before we get started, if you want to know about Store Procedure in SQL Server, please go through the following article: Why do we […]
Continue reading HTTP vs HTTPS: Why You Should Switch to HTTPS for Better Website Security
Remote work has evolved from a fringe benefit into a mainstream standard—one that tech professionals across the globe are embracing. Whether you’re a developer, designer, project manager, or content strategist, the opportunities to work remotely are vast and growing. In […]
Continue reading The Future is Remote: Why, How, and Where to Begin Your Remote Work Journey
In this article, we will learn how to create a dynamic form in ASP.NET. Here, dynamic means that we will create the controls at run time. Suppose someone asks you to create a form in ASP.NET. Naturally, your first response […]
Continue reading How to Create Dynamic Form in ASP.NET and Retrieve Input Values
In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target based on the results of that join
Continue reading Create MERGE statement with variable in SQL Server
