category
home / developersection / category
CURSOR in SQL Server
A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.
Stored Procedure in SQL Server
Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.
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