In this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table. ...
There are three simple methods in SQL Server that you can use to convert table data into XML format using a simple Query. ...
I am sure you have seen the query editor in SQL Server Management Studio. A Query Editor in SSMS is where you write queries, functions, procedures etc. and execute it. The Query Editor does not ...
Let us assume, I have a table in SQL Server and it has few thousand rows of data. How do I retrieve the top 10 records from the table, randomly? One of the simplest methods in SQL Server to get random ...
It is always important to know how much space a table or any database object is using. This becomes more significant when the tables are on a cloud database and you are paying for the space. In this ...
By default, you can Edit Top 200 rows in a table from SQL Server Management Studio. So, when you right click a table, it shows an option “Edit Top 200 rows”. And, you wonder how do I edit more than ...
Using DATEADD() function. Yes, its an in-built function in SQL Server, which will help you find the employees who have been hired in the last n months. The n in this case can be any number. ...
Unlike the WHERE clause, the HAVING clause in SQL Server is used when you have Aggregate functions in your SQL query. There are different ways you can use the HAVING clause in an SQL query. ...
There a few simple methods (or SQL queries) using which you can get or select the last 3 rows or records in a table in SQL Server. I am sharing 3 different methods here and all are useful in different ...
Let us assume, I have two dates with time like 2021-01-01 13:15PM and 2021-01-05 17:29PM and I want to display the number of days along with Hours and Minutes in this format… Total Days | hh:mm:ss ...
