SQL Server Functions are useful objects in SQL Server databases. A SQL Server function is a code snippet that can be executed on a SQL Server.These are the database objects consist of code block of code that can be executed indecently and can be used again and again. Functions in T -PL/SQL always returns a […]
Read MoreIn this article we will learn about the view and cursors in PL SQL using SQL server. What is View? In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from […]
Read MoreProcedural language SQL provides you small programming constructs using which we can write small small code blocks will help you to manipulate data from database. PL/SQL is a combination of SQL along with the procedural features of programming languages. It is being develop to provide the programming enhancements and capabilities to SQL. In case of […]
Read MoreWhat is joins? Joins enables us to fetch data from multiple tables, in lot of situations you need to combine the multiple table data in a single select query, that we can do using sql joins. If you want to implement join between two or more tables in general those table should have some common […]
Read MoreWhile creating tables you can apply constrains/rules to column – SQL constraints are used to specify rules for the data in a table. Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation […]
Read MoreHow to create table using SQL? To create any thing in database SQL provides you create query or command. To create table in database we need to use Create Table query as follows – create table tablename ( fieldname datatype([size]), fieldname datatype([size]) ….) where field name is name of column from table and data type […]
Read MoreWhat is Database? Database is nothing but the collection of information about a particular topic or data stored in way that it can be manipulated easily. In general we store the database in tabular format. Storing data in tabular format makes it easy to manipulate and use. e.g. Buses Database, Flight Database , Student Database. […]
Read More