Database

DECLARE @a nvarchar(50)
SET @a = 'select * from tableName where ColumnId in (1,3)'
exec (@a)

DECLARE @a nvarchar(50)
SET @a = '1,3'

declare @tsql as nvarchar(max)
set @tsql = 'select * 
from tableName 
where CAST(ColumnId as nvarchar(50)) in ('+@a+')'

exec (@tsql)

SELECT *
  FROM tableName
 WHERE ColumnId = 1 OR ColumnId = 2

Bastard Programmer from Hell

SELECT * FROM illness_symptoms AS is1 
INNER JOIN illness_symptoms AS is2 ON is1.cod_i=is2.cod_i
WHERE is1.cod_s=s_1 AND is2.cod_s=s_2

SELECT * FROM illness_symptoms AS is1 
INNER JOIN illness_symptoms AS is2 ON is1.cod_i=is2.cod_i
INNER JOIN symptoms AS sy1 ON is1.cod_s=sy1.cod_s
INNER JOIN symptoms AS sy2 ON is2.cod_s=sy2.cod_s
WHERE sy1.symptom=symptom1 AND sy2.symptom=symptom2

obarahmeh wrote:

Is this option (Transactional Replication) the most useful and best solution for mu purpose?

INSERT INTO rentals VALUES (1, 7782, TO_DATE('02/02/2010 09:45:00'), 'PQ07JHG');

khurram_shahzad wrote:

..were crashed due to low harddisk space issue...SO WHY THIS HAPPENS