Everybody always should use the RIGHT type.

varchar(1) and char(1) are not similar nor...

This a question for very beginner!

"Elementary, my dear Watson" .

Good morning!

I answered varchar(1), because I like to use varchar. I hate CHAR cause of big problem that can lead, and NCHAR NVARCHAR cause of waste of space.

Old style to write the WHERE condition.

I prefer to build a string ONLY with the true condition; it's more performing.

In a complex WHERE with useless condition may lead to a...

c:\ and C:\mssql\ should exists and sql account should have permissions to write.

I agreed with you. I do not like unneeded parenthesis.

I disagree! See the question of yesterday.

this question is the same of "predict output".

Also the second answer is correct, cause of lack of ORDER BY.

I...

It does nothing! 😎

Correct answer is 1-25:

exec sp_helptext sp_addmessage

in the output search for @severity and you'll find this piece of code that is the law.

--...

Bah?

-- try to use this for replication:

set identity_insert my_table on

-- what about IDENTITY??

SET NOCOUNT ON

-- Just a simple test table

IF (OBJECT_ID('tempdb..#my_tab') IS NOT NULL)

DROP TABLE #my_tab

CREATE TABLE #my_tab (id INT NOT NULL IDENTITY(1000,1), any_date DATETIME)

-- Create...