SQL Wildcards
SQL wildcards are used for searching one or more characters from table in a database. The SQL wildcards substitute one or more character, whenever there is a search for data in a table of the database.
Basic SQL Query
There are lots of SQL commands which are used in database. Here we will try to explore all the SQL commands with help of SQL Query.Data Definition La
Table-Valued Functions in SQL Server
A table-valued function is a user-defined function that can be used where views or table expressions are allowed in T-SQL. A user-defined function c
Transaction in SQL Server
In SQL Server we can implement transaction to ensure data integrity. In a multiuser situation, may be multiple transaction try to accessing the same r
Trigger in SQL Server
A Trigger is a special kind of stored procedure that is invoked whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT, UPDATE OR DELETE or Data Definition Language (DDL).
Stored Procedure in SQL Server
A Stored Procedure is a precompiled object stored in the database. Stored procedures can invoke the Data Definition Language (DDL) and Data Manipulati
Joins in SQL Server
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between columns on table. A JOIN is a means for combining fields from two tables by using values common to each.
Exception handling in SQL Server
In SQL Server TRY..CATCH statement which helps us to handle the errors effectively in the back end. This handling of the exception can provide additio
Copying, Merging and/or Uniting Records In SQL Server
Some time we have a situation to copy a set of rows of a Table 'A' into the Table ‘B’, it means suppose if we have thousand of records in a table ‘A’ and I created another table ‘B’ to maintain data but records is available in table ‘A’
Aggregate function in SQL Server
SQL aggregate functions are used to sum, count, get the average, get the minimum and get the maximum values from a column or from a sub-set of column values. SQL aggregate functions return a single value, calculated from values in a column.
Conjunctions and Dis-junctions in SQL Server
Conjunctions and Disjunctions in SQL ServerThe ConjunctionsBasically the logical conjunction is used to check that two conditions are true, in logic
How to create table in SQL Server
As a user, you need to create tables to store data in database. While creating the tables in database, you have to follow specify certain rules and constraints for columns that specify the kind of data to be stored.