Difference between Function and Stored Procedure in SQL SERVER
SQL Server functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use.
Clustered – Non Clustered Indexing In Sql Server
Indexes in general increase performance by reducing I/O. Without indexes, SQL Server would always have to read all of the rows in a table to find the subset of rows that have the values specified in joins or WHERE clauses
Difference between TRUNCATE & DELETE statement in SQL Server
Truncate and Delete both is used to delete data from the table. Both these commands will only delete the data of the specified table; they cannot remo
JOIN in SQL Server
SQL JOIN's are used to query data from two or more tables, based on a relationship between certain columns in these tables.SQL joins are used to combi
CASE statement in SQL Server
The SQL Server CASE statement is a conditional statement that returns a single value based on the evaluation of a statement. CASE expressions can be u
Wildcards Operators in SQL
SQL wildcards can substitute for one or more characters when searching for data in a database. SQL wildcards must be used with the SQL LIKE operator w
Difference between Stored Procedure and Function
In this blog I am going to explain the basic difference between Stored Procedure and Function.Stored procedures:Have to use EXEC or EXECUTE. Return
How to configuring SQL Server memory settings
Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) in the buffer pool used
Restoring MySQL Database
For restoring MySql databse you should follow two steps:Create an appropriately named database on the target machineLoad the file using the mysql comm
Back up MySql Database with Compress
If your mysql database is very big and you want to compress the output of mysqldump. Just use below command..$ mysqldump -u [username] -p[password] [d
How to Back Up and Restore a MySQL Database
If you have shell or telnet access to your web server, you can backup your MySQL data by using the mysqldump command. This command connects to the MyS
Stored Procedure in SQL Server
Stored procedure is an important concept which is used for access or modifies data into database. A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.