SQL Server Views

How to create a SQL Server view?

How to create a SQL Server view to display specific columns from an existing table? Consider a view as a virtual table defined by a SQL query. It’s a set of columns and rows from a table. A user defined view is a view created by a SQL Server developer.

MS BI Abbreviations

XMLA – Extensible Markup Language for Analysis

XMLA stands for Extensible Markup Language for Analysis. It’s a language built on top of XML language. It allows data access from standard multidimensional data sources. Client applications accesses Microsoft SSAS cubes and tabular models using the XMLA language and the HTTP protocol. XMLA stands for Extensible Markup Language for

SQL Server Views

How to delete a SQL Server view?

How to delete a SQL Server view from the database? For a SQL developer it’s a good practice to have a clean database and remove the unused or useless code. Unlike the tables, the views can be deleted from the database using a SQL command. How to delete a SQL

DAX functions

How to calculate year to date value in DAX?

How to calculate the year to date value of the sales in DAX? To calculate the year-to-date value with a DAX formula, use the built-in function called TOTALYTD. In this example, simply copy paste the code and adjust it to your needs. How to calculate the year to date value

No Picture
SQL Server Functions

How to delete a SQL Server function?

How to delete a SQL Server function? This SQL command delete the SQL Server function. However, it does not check if the function exists. How to delete a SQL Server function? Use this T-SQL code to delete the function from the database, the function will be permanently deleted. To avoid errors in

SQL Server Functions

How to call a SQL Server function?

How to call a SQL Server user defined function? The SQL syntax to call a function is different from the call to a stored procedure. Use SQL Server function the same way you select data from a table. How to call a SQL Server function? A SQL Server user-defined function

SQL Server Tables

How to delete a SQL Server table?

How to delete a SQL Server table? How to drop a table without checking if the table exists? Assume the object is already in the database. How to delete a SQL Server table from the database with a query? Here is a SQL script to create a SQL Server table.

SQL Server Errors

SQL Server Truncate Table Error Cannot find the object

In SQL Server, to clear the full content of a table, the fastest way is to run a Truncate Table query. The Truncate is different from the Delete From query because it empties all the lines in the table without a Where clause, it’s a DDL SQL operation (Database Definition