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!'
Here you will find about .net technology. also can get example about MVC.net and jquery.
Subscribe to:
Post Comments (Atom)
📱Build WhatsApp Bot using .NET + OpenAI
In this article, you will learn how to build a real-world WhatsApp chatbot using ASP.NET Core and OpenAI. This bot can automatically repl...
-
exec xp_cmdshell 'net use Z: \\192.01.01.10\FileStorage [Password] /user: 192.01.01.10 \Administrator'(Username) --exec xp_c...
-
<html> <body> <table> <tr><td>Text to Save:</td></tr> <tr> <td colspan="3...
-
MaxDepth – A positive integer that specifies the maximum nested node depth per read. The default value is 32. Maximum is 2147483647. Ma...
No comments:
Post a Comment