Interview Question of the Week – What are the Limitations of User Defined Functions (UDF) ? Let us learn about that in today’s blog post.
Interview Question of the Week #058 – What is the Difference Among DECIMAL, FLOAT and NUMERIC Datatype?
What is the difference among DECIMAL, FLOAT and NUMERIC? DECIMAL and NUMERIC are the same datatype, while FLOAT is approximate. Here is when to use each.
Interview Question of the Week #057 – What is GO Statement in SQL SERVER?
Learn what the GO statement really does in SQL Server, why a variable vanishes after it, and the simple rules every script writer should know.
Interview Question of the Week #056 – How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server
An interview practical: fix a SQL Server installation failure when the rule Setup account privileges failed. Here is the answer.
Interview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?
Interview question: how do you convert ASCII to DECIMAL or DECIMAL to ASCII in SQL Server? The answer uses two simple built-in functions.
Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects
A favorite interview script: how to retrieve user defined object details from sys.objects in SQL Server, with the query to run.
Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?
What is the difference between deterministic functions and nondeterministic functions in SQL Server? A short interview answer with examples.