Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
CREATE FUNCTION dbo.ufnCheckIDAndUSERID(@ID varchar) RETURNS bit AS BEGIN --first check if the ID is there in SQL table: IF ((SELECT count(ID) from [mydb].[dbo].[t] where ID = @ID) = 1) AND ((SELECT count(UserID) from [mydb].[dbo].[t] where ID = @ID)=1) RETURN 1 ELSE RETURN 0 END;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Update the value of table B with value of table A tables inner join||6||78|
|T-SQL to copy a database||37||66|
|Finding Where Clause Value in SQL Views and SP||21||40|
|Why do I get an error when executing a stored procedure using SQL Server 2008?||1||7|