SQL SERVER – Four Basic SQL Statements – SQL Operations

There are four basic SQL Operations or SQL Statements. SELECT – This statement selects data from database tables. UPDATE – This statement updates existing data into database tables. INSERT – This statement inserts new data into database tables. DELETE – This statement deletes existing data from database tables. If you…
Read More

SQL SERVER – Function Property – Deterministic or Non-Deterministic

I recently received question through email that how to determine if any user defined function is deterministic or non-deterministic? First go through two articles I have written about deterministic and non-deterministic function. SQL SERVER – Deterministic Functions and Nondeterministic Functions SQL SERVER – 2005 – Use of Non-deterministic Function in…
Read More