Reading Time: < 1 minute“If I have a query that I run frequently, why should I save it as a View in the database instead of just simply saving it as a .SQL script file and running the query when I need it?” There are two main benefits to saving your query as a Continue Reading
Views
How to see the definition of a View in SQL Server
Reading Time: 4 minutesMicrosoft SQL Server makes it very easy to create and use Views within SQL Server Management Studio. In this very brief tutorial, we’ll discuss how easy it is to see the definition of a View after it has been created and saved in your database. If you need a full Continue Reading
How to change a table name in SQL Server
Reading Time: 6 minutesChanging a table name in Microsoft SQL Server is a very easy task. Microsoft has a great built-in stored procedure we can use to easily change a table name. The stored procedure is called SP_RENAME. In this very brief tutorial, we’ll discuss how to use the SP_RENAME stored procedure and Continue Reading
Updatable View in SQL Server: A How-To Guide
Reading Time: 10 minutesA proper understanding of Views in SQL Server will definitely help you become a better database developer. Views allow us to basically save a query as an object in the database, and make it very easy to run the query with simple commands. But what if we want to make Continue Reading
How to change a column name in SQL Server: Explained for Beginners
Reading Time: 6 minutesSo you need to change a column name in your database. Maybe you messed up the name from the start, or your team decided the name needs to change for business reasons. Either way, it’s got to change. Luckily, the process to change a column name is not too difficult Continue Reading
Top 6 tools you should know for writing AWESOME Select statements
Reading Time: 13 minutesAs a database professional, you will be asked to come up with SELECT statements to pull needed information in a meaningful and accurate way. Sometimes you will need to review other SELECT statements written by other people, too. Maybe those queries have a problem which is causing it to pull Continue Reading
Derived Table in SQL Server: Everything you need to know
Reading Time: 9 minutesWhen learning about table expressions, the first and most simple table expressions you can learn is the Derived Table. They can help you gather the information you want quickly without needing to write much code. Derived Tables are just one type of table expression we have available to us in Continue Reading
SQL Server Table Expressions: The Ultimate Guide for Beginners
Reading Time: 10 minutesThere are several different kinds of table expressions you need to be aware of when learning to query and develop SQL Server databases. Each kind of table expression has it’s own strengths and weaknesses, and it is important for you to understand those strengths and weaknesses so you know which Continue Reading
Multi Statement Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 12 minutesOne of the most powerful tools available to us in Microsoft SQL Server is Multi Statement Table Valued Functions. These are user-defined functions similar to Scalar functions and Inline Table Valued functions. We use functions in SQL Server to run repeatable code very easily. Are you struggling to understand how Continue Reading
Inline Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 9 minutesIn this tutorial on SQL Server user defined functions, we will discuss Inline Table Valued Functions. User defined functions are an extremely common thing in Microsoft SQL Server. A solid understanding of user defined functions is crucial for anyone who is in the position of querying and developing SQL Server Continue Reading