Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

login procedure for ms sql

Home
Forums
SQL

login procedure for ms sql

Madhu G

4yAsked Feb 18, 2022, 10:29 AM943SQL

1.use of login procedure for ms sql

2, how create login procedure in ms msql..?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Gajendra Jangid4y ago
try this link

https://www.c-sharpcorner.com/blogs/login-page-using-stored-procedure1
Muhammad Imran Ansari4y ago
Check the following repository to create, add and authenticate user.

https://gist.github.com/doobry/1106727
Jignesh Kumar4y ago
Hi Madhu,

Please refer this link which will help you,
https://www.c-sharpcorner.com/blogs/login-page-using-stored-procedure1
CREATE procedure Usp_logincheck
(
   @UserName varchar(50),
   @Password varchar(50)
)
as
declare @status int

if exists(select  UserName from Login where UserName=@UserName and Password=@Password)
       set @status=1
else
       set @status=0
select @status