The following script demonstrates how to declare variables and initialized values in one statement in SQL Server 2008. More

This example demonstrates how to check multiple values using Linq to find out the required result... More

This example demonstrates how to rename the store procedure using Transact-SQL... More

This example demonstrates how to modify a store procedure in the current database... More

This example demonstrates how to delete a store procedure from your database.... More

SQL Server 2008 R2 Service Pack 1 has released, SQL Server 2008 R2 issues has been fixed in this released. More

In this example, you will see how to get the length of a string in T-SQL. Len function returns the numeric. Len function is used to get the length. Len function can be used in SELECT query. Len function takes only one argument More

In this example, you will see how to find the size of table from a database. SQL server gives you build in system store procedure named SP_SPACEUSED. More

In this tutorial, you will get to know about how to create a SSAS cube using wizard upon a data warehouse in visual studio 2008.... More

A unique identity in each row in a table is called Primary key... More