tag
home / developersection / tag
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.
System Databases in SQL Server
When you installed SQL Server several system databases are created automatically and these databases are master, model, msdb, tempdb and resource. The
Service Broker in Sql Server 2005, 2008
Service Broker in Sql Server 2005, 2008Service Broker is a message-queuing technology which allows developers to integrate SQL Server into distributed
HTTP Endpoints in SQL Server 2005, 2008
HTTP Endpoints in SQL Server 2005, 2008A HTTP Endpoint is a Sql Server object which is use by Sql Server to communicate over the network. It includes
Primary key
In this blog I will explain you that how to work with primary key in sql server. I will show some examples in whic you see different mechanism to create primary key.
Keys in database.
As we know that database uses tables to organize information. To maintain data integrity (that is data should be correct and in well formed) we use concept of keys.