create

How to encrypt a View in SQL Server using the create view statement and the encryption option? How to create a SQL Server view with the encryption option? The WITH ENCRYPTION option allows you to hide the view code. …

Create an index in SQL Server to improve the performance of queries on tables and in clustered views. Two types of indexes exists, the clustered and the nonclustered one. To create a non-clustered index, use this example and adapt …

How to manage SQL Server user defined functions ? SQL Server user-defined functions are very useful when starting T-SQL development. You need to use them very often so you have to learn the right syntaxes and avoid errors. At …