SQL Arithmetic OperatorsOperatorDescriptionExample+AddTry it-SubtractTry it*MultiplyTry it/DivideTry it%ModuloTry itSQL Bitwise OperatorsOperatorDescription&Bitwise AND|Bitwise OR^Bitwise exclusive ORSQL Comparison OperatorsOperatorDescriptionExample=Equal toTry it>Greater thanTry it<Less thanTry it>=Greater than or equal toTry it<=Less...
Showing posts with label SQL Tutorial. Show all posts
Showing posts with label SQL Tutorial. Show all posts
26 December, 2020
SQL Operators
SQL Arithmetic OperatorsOperatorDescriptionExample+AddTry it-SubtractTry it*MultiplyTry it/DivideTry it%ModuloTry itSQL Bitwise OperatorsOperatorDescription&Bitwise AND|Bitwise OR^Bitwise exclusive ORSQL Comparison OperatorsOperatorDescriptionExample=Equal toTry it>Greater thanTry it<Less thanTry it>=Greater than or equal toTry it<=Less...
SQL Comments
SQL CommentsComments are used to explain sections of SQL statements, or to prevent execution of SQL statements.Note: The examples in this chapter will not work in Firefox and Microsoft Edge!Comments are not supported in Microsoft Access databases. Firefox and Microsoft Edge are using Microsoft Access database in our examples.Single Line CommentsSingle...
SQL Comments
SQL CommentsComments are used to explain sections of SQL statements, or to prevent execution of SQL statements.Note: The examples in this chapter will not work in Firefox and Microsoft Edge!Comments are not supported in Microsoft Access databases. Firefox and Microsoft Edge are using Microsoft Access database in our examples.Single Line CommentsSingle...
SQL Stored Procedures for SQL Server
What is a Stored Procedure?A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it.You can also pass parameters to a stored procedure, so that the stored procedure can...