Search In
Migeration in SQl Server :
There are several options if one wishes to migrate a database from a SQL Server 2005 to SQL 2008 Server. First of all transferring a database from any version of SQL Server 2000 and above to 2008 version. This Wizard can
Below is an example of finding all the user who are stored in db and lies in the given range of Distance on basis of Longitude and Latitude.
CREATE proc [dbo].[SP_UserByDistance]
(
@UserID uniqueidentifier,--UserId
@Date datetime, --Date
@Longitude
Database Normalization
Normalization is a technique of managing records in a database. It is an approach to eliminate data redundancy and anamolies . It also removes data duplicacy in a record. It helps in data update,delete and insert anamolies.Wi
in this program of C language we are not using the any king of loop,we are printing the numbers without loop.
#include
int main(){
int num = 1;
print(num); //it is a function which is calling the value of printnum.
Identity field is typically used as a primary key in database. When a new record is inserted into a table, this field automatically assigns an incremented value to this column.However, inserting our own value into this column is not straightforward.I
Stored Procedures are pre-compile database objects which are compiled for first time and execution plan is saved for further use. However UDF is compiled and executed every time when it is invoked.This article provides a detailed comparison of stored
SQL Server sysobjects Table contains one row for each object created. In other words, it has a row for every constraint, default, log, stored procedure etc in the database.The two columns most useful in this table are sysobjects.name and sysobjects.
In the upcoming version of SQL 2016 a new component of COMPRESS and DECOMPRESS T-SQL functions is added. SQL Server 2016 provides built in functions for compression and decompression.The COMPRESS and DECOMPRESS functions can store and retrieve data u
In the following article we will learn how to insert results of a stored procedure to a table. There are two approaches to do this depending on whether we know the table schema beforehand or not.
We will be using the following stored procedure to ill
Temporary tables in SQL are used for manipulation of data for a short period of time.
It can be used as a accumulator like we have in microprocessor which acts as mediator to store and perform operations into it.
Temporary table in SQL are main
