How to create custom formatting, conversion or validation using scalar functions

Problem: How to create a custom conversion or validation check of an input value. Solution: Scalar - Valued Functions. CREATE FUNCTION User-defined scalar functions return a single data value of the type defined in the RETURNS clause....

Read More

How to create and use a table valued function.

Problem:  How to create a table result set Object in the FROM Clause based on a parameter passed. Solution:  Table Valued Function, CREATE FUNCTION Functions are generally used for calculating business logic, encapsulate...

Read More

How to check foreign key constraints columns on a table using a query.

Problem:  How to query foreign key constraints on a given table. Solution:  sp_fkeys, sp_foreignkeys, sys.foreign_keys, sys.foreign_key_columns There are procedures which can through the output and also views which can...

Read More

How to create a view and use options to protect the view.

Problem: How to create a view or a read only version of a table data. Solution: Views, Views. Views are virtual tables having metadata based on the query inside the view definition, views have rows and columns just like any tables...

Read More

How to use JOINS in SQL Server

Problem: How to get values from two different tables based on common values and logical operators. Solution:   JOIN There are different types of joins in SQL Server. Inner Join INNER JOIN Operation (Microsoft Access...

Read More