Database

admoore77 wrote:

With that being said, am I still at risk?

Saira Tanwir wrote:

what i want to know is that does the data types of the primary keys have to be the same to create relationship between the tables???

Priya_2007 wrote:

It should be same datatypes while creating a relationship between two tables

Saira Tanwir wrote:

a One to One relatonship between two tables 'boys' and 'sports'

Saira Tanwir wrote:

column sports_type does not exist in the target table. Couldnot create constraint see previous errors

can u plz explain the meaning of this, too???

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