tag
home / developersection / tag
Drop Column in SQL Server
In this blog, I have described how to drop the column from existing table. For demonstration, I have used a table that given below. CREATE TABLE [dbo
Add New Column in Table in SQL Server
In this blog I have described how to add new column in existing table. For demonstration I have used a table that given below.CREATE TABLE [dbo].[EmpI
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
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.