Search 9525 Results
Collate is a clause that can be applied to a database definition or a column definition to define the collation, or to a character string expression t
Mobile devices are becoming extremely common in today's world. Most users can easily consume all the content on small mobile devices. This eliminates
$ROWGUID The point of setting the ROWGUIDCOL property is to enable you to use $ROWGUID instead of the column name in a SELECT list. That means we can
Here we used TOP keyword for selecting records from table in SQL server using Index and Order By statement. First we create a table and insert some
Linking lets you connect to data without importing that information, so that you can view and edit the latest data both in the SQL Server database and
Make sure that the database being restored is from the same Product level as the server you are restoring to. I once faced an issue when trying to res
SQL IF...ELSE Statement used to test a condition. IF...ELSE Statement using in execution of a Transact-SQL statement (Store Procedure or T-SQL) and Tr
Some of these tips are quick and easy, others with take longer to implement. Not all of them will apply to your particular environment, and some apply
This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very
You might have heard many times that one should not use SELECT * as there are many disadvantages to the usage of the SELECT *. I also believe that the
The focus of the article is the Export to Excel functionality - the Gridview and its data binding are only for demonstrating the Export functionality.
In .NET environment we can define transaction boundary by Transaction object. 1. If you are using SqlClient (namespace System.Data.SqlClient) Managed
You need to log in or register to vote on answers or questions.