Introduction How to find the Datatype and Properties of a Variable and Columns of a Table? The Simple and Easy Answer for this Question is, using SQL_VARIANT_PROPERTY Function. ..
Introduction The Questions are, what is ISNUMERIC Function in SQL server and what are those interesting result set behaviors that it has and what are the other ..
Introduction Yup, many of us would guess and say ‘*’ (Asterisk) . Yes, of course it’s right and it will be our first answer. But What ..
Introduction In any scenario, if we need to explicitly list out all the column names of a table in the SELECT statement instead of using ‘*’, ..