Shivam Dogra 
In this SQL Server tutorial, we will learn how to create a table from view in SQL Server. Here we will illustrate this implementation using an example. Moreover, we will also cover the following topics. Create table from view in SQL Server In this section, we will learn to create a table using a view in SQL … Read more >>
This SQL Server tutorial will teach us how SQL Server Date Format dd mm yyyy works. Moreover, we will discuss and learn some examples so that you can understand the concept much better. SQL Server Date Format Example Let us discuss all the cases individually with proper examples. SQL Server Date Format mm dd yyyy In … Read more >>
In this SQL Server tutorial, we will understand how to see view definition in SQL Server. Additionally, we will also illustrate the following set of topics. But, before we start this topic, we recommend you learn about the basics of View in SQL Server. How to see view definition in SQL Server In this section, we will illustrate … Read more >>
In this Oracle tutorial, we will learn how to add a column to a table in Oracle 19c and 21c. Moreover, we will also cover these topics. Oracle How To Add A Column To A Table While working on a database you received an email from the client to add a new column in the … Read more >>
In this SQL Server tutorial, we will learn how to resolve the “Error: 40 – could not open a connection to sql server” error. So, in this tutorial, we will discuss the root cause of this error and will also discuss how to solve this error. Error: 40 – could not open a connection to sql server … Read more >>
Last week, I worked on a stored procedure in SQL Server. I got an error while working on the query about adding the values in the table. The error came as “String or Binary Data would be Truncated in SQL Server”. String or Binary Data would be Truncated in SQL This is a common error … Read more >>
In this SQL Server tutorial, I will show you how to create a table in SQL Server Management Studio. As a database developer, you must know how to create a table to store the information in it. Tables are important objects in SQL. Server databases and their design are a base for both DBAs and … Read more >>
In this Oracle tutorial, we will learn how to check database size in Oracle. We are working on the latest version of Oracle, i.e. 21c, but the steps shared will also work on other versions. How To Check Database Size In Oracle Let us discuss all the approaches to check the database size of all … Read more >>
![Cannot find type [microsoft.sqlserver.management.smo.server]](https://databasefaqs.com/wp-content/uploads/2025/01/Cannot-find-type-microsoft.sqlserver.management.smo_.server.jpg)
I was trying to retrieve the SQL edition using a PowerShell script recently. After executing that query, I got this error. In this article, I will discuss the cause and the solution to this error. Cannot find type [microsoft.sqlserver.management.smo.server] I was executing the below query. After executing the above query, I got the error as … Read more >>
In this Oracle tutorial, we will learn how to create a user in the oracle database 21c & 19c. Oracle create user Each organization has a different set of departments handled by professionals. These professionals require access to the Oracle database to perform assigned responsibilities. The username is created for each individual who will be … Read more >>