Check Constraint Help

[Sherin Mathew]

Can i create Custom check constraint in SQL Server?

I have a table 'City' having columns as 'ID' , 'Name' and 'Number'.
If Name is 'AA' then Number column shouldn't accept null values. If name is other than 'AA' Number column can be null

[Arjay]

I believe a constraint can call a function, but I'm on my phone so I really can't look into it fully. However, doing a google search for, "sql constraint calls function" seemed to look promising. Hopefully, this will help.

[VictorN]

Can i create Custom check constraint in SQL Server?

I have a table 'City' having columns as 'ID' , 'Name' and 'Number'.
If Name is 'AA' then Number column shouldn't accept null values. If name is other than 'AA' Number column can be null

You could implement an "Instead ff" Trigger like:

CREATE TRIGGER dbo.OnInsertCity 
   ON  dbo.City 
   INSTEAD OF INSERT
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    DECLARE @city varchar(50),@number int
    SELECT @city=[name] ,@number=[number] from inserted
    IF (@number IS NULL and @city ='AA')
    BEGIN
        RAISERROR ('You are not allowed to Add These Data.', 10, 11)
    END
    ELSE
        INSERT INTO City ([name] ,[number]) values (@city,@number)

END
GO

[ishan_shah]

Hello,
You can call a UDF in check constraint which will work as per your requirement. Hope this will work as per your requirement.

[VictorN]

Hello,
You can call a UDF in check constraint which will work as per your requirement. Hope this will work as per your requirement.

Could you post an example for the OP's case