Database

Colin Angus Mackay wrote:

And that makes it legal, does it?

create trigger MyTableInsertCheck
on MyView
instead of insert
as
begin
select @count = count(1) from mytable m inner join inserted i on m.keyfield = i.keyfield
if @count = 0
begin
  insert name, keyfield into mytable
  select name, keyfield from myview
end
end

Amit Kumar G wrote:

Is there any Before trigger in SQL 2005.....

WITH DateIncrement (PreviousDate) AS
(
  SELECT CAST('2007-09-01' AS DATETIME)
  UNION ALL
  SELECT DATEADD(d, 1, PreviousDate)
  FROM DateIncrement
  WHERE PreviousDate < '2007-10-01'
)

SELECT * FROM DateIncrement p

WITH DateIncrement (PreviousDate) AS(  <br />
SELECT CAST('2007-09-01' AS DATETIME)  <br />
UNION ALL  <br />
SELECT DATEADD(d, 1, PreviousDate)  <br />
FROM DateIncrement  <br />
WHERE PreviousDate < '2007-10-01')<br />
<br />
SELECT * FROM DateIncrement p

Senthil S wrote:

Can u tell the exact position where its.

Otherwise tell the type is enough??????