Insert Into Employee (Role_ID, FirstName, LastName, DateOfBirth,
Active)
Select @Role_ID, @FirstName, @LastName, @DateOfBirth,
@Active
Where not exists (
select 1 from Employee where FirstName =
@FirstName
and LastName = @LastName
and DateOfBirth =
@DateOfBirth
)
If @@rowcount=0 select 'User already exists!'
Subscribe to:
Post Comments (Atom)
-
<html> <body> <table> <tr><td>Text to Save:</td></tr> <tr> <td colspan="3...
-
Many developers don't know about how to remove un-used code and block. Visual Studio giving facility to resolve this. The followin... -
/****** [dbo].[Split] Script ******/ CREATE FUNCTION [dbo].[Split] ( @RowData NVARCHAR(MAX), @Delimeter NVARCHAR(MAX) ) RETURNS @RtnVal...
No comments:
Post a Comment