Create User Login in SQL Server 2008 R2
Create user with the query CREATE LOGIN [Login_Name] WITH PASSWORD='password' MUST_CHANGED, DEFAULT_DATABASE=[
Retrieve SQL Server Installation Date Time
Question: How do I retrieve SQL Server Installation date? Answer: Run the following query and it will give you the date of SQL Server Installation.
Insert Multiple Rows into Single Table
Here we describe how to insert records into table in multiple ways. Currently when developers have to insert any value into the table they have to write multiple insert statements.
Distinct Data in SQL Server
How do I display only unique records from my table? For demonstration first we create a table--USE DATABASE USE AVI --CREATE TABLE CREATE TABLE Pr
SQL Keys
A key is a single or combination of multiple fields in a table. It is used to fetch or retrieve records/data-rows from data table according to the condition/requirement.
Check Case Sensitive Password in SQL Server Using Collate Clause
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 to apply a collation cast.
Usage of $ROWGUID and $IDENTITY in SQL Server
$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 use $ROWGUID for access ROWGUIDCOL from table if ROWGUIDCOL is used.
Top with Index and Order of Result set in SQL Server
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 values.
Linking Tables and Views between Access and SQL Server
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 in your Access database without creating and maintaining a copy of the data in Access.
How to Recover from a Corrupted Database in SQL Server 2000
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 restore a database from an SP4 to a non-SP4 database server.
Checking IF…ELSE condition in Stored Procedure SQL Server
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 Trigger.
SQL Server Security Tips
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 to some types of server more than others. They do however apply to all versions of SQL Server.