Database

IF Exists (SELECT MessageID FROM Message
  WHERE MessageTitle = @Title)
BEGIN
  UPDATE Message SET MessageText = @MessageText WHERE MessageTitle = @Title
END
ELSE
BEGIN
  INSERT INTO Message (MessageTitle, MessageText) VALUES
  (@Title, @MessageText)
END

Msg 201, Level 16, State 4, Procedure sp_altermessage, Line 0<br />
Procedure or Function 'sp_altermessage' expects parameter '@message_id', which was not supplied.<br />

CREATE PROCEDURE dbo.PostMessage
  @Title NVARCHAR(50),
  @MessageText NVARCHAR(200),
  @message_id INT OUT
AS
SET NOCOUNT ON

IF Exists (SELECT @message_id = MessageID FROM Message  WHERE MessageTitle = @Title)
BEGIN
  UPDATE Message SET MessageText = @MessageText 
  WHERE MessageTitle = @Title
END
ELSE
BEGIN
  INSERT INTO Message (MessageTitle, MessageText) VALUES  (@Title, @MessageText)
  SET @message_id = SCOPE_IDENTITY()
END

select
convert(char(11),DateEntered) as 'Date Entered',
browser,
platform,
MajorVersion,
MinorVersion
from
visitors
where
visitorID =  @visitorID

<br />
SELECT TABLEA.* FROM TABLEA<br />
WHERE EXISTS<br />
           (SELECT * FROM TABLEB   WHERE TABLEA.ID = TABLEB.ID)<br />
UNION <br />
SELECT TABLEB.* FROM TABLEB<br />
WHERE EXISTS <br />
   (SELECT * FROM TABLEA WHERE TABLEA.ID = TABLEB.ID)<br />

Rate this message. Thank you. Harini

NanaAM wrote:

Is it possible to run a .sql file on sql server through .net code?

NanaAM wrote:

But I wanted to ask whether we can run the script file, the .sql file direclty?
For this I need to store the file contents in string and pass it to commandText