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...

???????????????

--for a list of store proc/func/view/etc. and getting the body of proc/func/view/etc. run this query

--copy the resultset and paste it in a new querywindow, then run it.

set nocount on

select 'exec...

-- This proc print a statement to copy data from one table to another with same structure. e.g. transfering data between servers (production to develop)

-- I use it in...