CSE 385 Lecture Notes - Lecture 4: Stored Procedure, Web Service
23 Feb 2019
School
Department
Course
Professor
Document Summary
Cse 385 - lecture 4 - finishing single table queries & creating stored procedures. Nvarchar does not work with casting to varbinary to check case of password. Use this to check case on nvarchar. Can use select distinct to get combinations only once so there are no repeats. Can also use group by and then the columns you don"t want to repeat. It will work until we get to stored procedures. With ties must have orderby so it knows which top 5 to take. Easier for some people to see and write. Use in(2, 55, 123) in where to select 1+ match. Just functions like getx() { return } Rest of website can call this to get information without writing sql statements. Only put on web service functions that you want user to be able to use. This also allows you to verify permissions. Right click on stored procedures and click create new stored procedure.
