Or else you can try this

declare @a varchar(50)

declare @b-2 varchar(20)

set @b-2='M'

set @a=@b + convert(varchar(50),'24/08/2010',101)

select @a

Adding the user to database only grants conncet access, to specify any read/write or any other role sql has inbuild roles defined "Database Role" you can leverage this or else...

I think you should first go through the NORMALIZATION concepts.

http://support.microsoft.com/kb/283878

Ok let me ask you in this way,

Say you have 1 table having 10 columns out of which Col1 is unique and Col 3 to Col9 can be nullable...

Thanks GM for clarification :-).

Thanks Steve appreciate your views

You are absolutely correct Steve, I agree with you. and this is the reason I am looking for some appraoch to handle this. One of the approach we found is...

as I mentioned you can think of Adventureworks database

. Customer

. Order

. Order Details

. Product

. Subcategory

- Product is defined by subcategory (FK in Product SubcategoryCode)

- Customers place the Orders

- Orders...

Here is the structure information only for product table.

CREATE TABLE [dbo].[Product](

[ProductID] [int] IDENTITY(1,1) NOT NULL,

[Name] [nvarchar](20) NULL,

[ProductStatusCode] [nchar](5) NOT NULL,

[CategoryCode] [nchar](5) NULL,

[ApplicationName] [nvarchar](50) NOT NULL,

[ChangeReason] [nvarchar](100) NULL,

[ModifiedBy] [nvarchar](20) NOT...

thanks man! i think i got the answer what i was looking for. I do understand the index part.

As mohit suggested the database snapshot will help you to achive your target but, at database level i.e. Database Snapshot works for whole database and not for specific object of...

you can use cast function to covnert it.

DECLARE @LineDate varchar(40), @Date varchar(40)

SET @LineDate = '4/15/2005'

SET @Date = '4/29/2005 12:00:00 PM'

SELECT CAST(@LineDate AS DATETIME), CAST(@Date AS DATETIME)

Yes, delete statement uses index column i.e. ScheduleRId in where clause.

I have fragmented the indices in the morning (i.e. 8 hour before). current the table hold few records(50), and seems...

Here is the DDL for which m working on...

CREATE TABLE [dbo].[Tier](

[TierRId] [int] IDENTITY(1,1) NOT NULL,

[ScheduleRId] [int] NOT NULL,

[Duration] [float] NULL,

[ModifiedReason] [nvarchar](100) NULL,

[ModifiedBy] [nvarchar](20) NOT NULL,

[ModifiedDateTime] [datetime] NOT NULL

CONSTRAINT [Tier_PK] PRIMARY...

Okay, i agree with you both of you but though I tried with equal clause it shows me Reads. logically it should not show any reads in profiler. please correct...