And how to move day to day data ? should i go with differantial backup on daily basis ???

hellosir,

Thanks for ur valuable time and comment......

I m more clear now...... thanks a lot for the clarification......

I checked by using select * from tab1 where qty>0... and the result was...

In Unique Key consraint only one null value is allowed......

Hello Friends,

Infront of u biggiesss i m too small to write antyhing but ,,, still i tried and i got some ansewer....... here is the code .....

I have considered in...

i think this the group by was left by mistake ...

if we over look that group by then the option 3 is the right answer and thats pretty much fineee...

Mithun

Dear friend,

you can use excel's feature of import data from data section.

there u can write selecte satement s and can retrive the data.

Mithun

HEY DUDE,,'

TRY THIS

DECLARE @MITHUN varCHAR (40)

SELECT @MITHUN = ''

SELECT @MITHUN = @MITHUN + name FROM Table_1

SELECT top 1 replace (@MITHUN,' ',',') FROM...

dude,

if u really want the reply then provide us the complete tabel structure and some more sample data then only we can help u out ...

Mithun

hi,

is is as simple as ur create the primary key.

ALTER TABLE dbo.Table_1 ADD CONSTRAINT PK_Table_1 PRIMARY KEY (id, name)

replace table name and column names as per ur comfort...

mithun

HI,

U CAN NOT USE NEWID FUNCTION WITHIN THE FUNCTION LIKE THAT.

U HAVE TO USE VIEW TO WORK UR FUNCTION. SEE CRETAE ONE VIEW LIKE

CREATE VIEW A

AS

SELECT Name,NEWID()...

Dear Friend,

I think U need to do the practical more carefully

see, just copy paste the below part and the result is what u looking for dear.....

CREATE TABLE Results

(Username VARCHAR(100),

Correct INT,

TotalTime...

Dear All,

Its Really Nice of u guysssssss for replying me some fruitful solutions...

First i tried with Varchar(max) but giving same problem as it can store upto 8060 bytes and finally...

Dear Sir,

thanks for the prompt reply,,,,

I got all my answers thanks a lot and a very happy new year to u.

thanks

Mithun

sir

i got my first question answer but still my two questions pending

2) is it really true that we cant create two text column on single table?

3) and please tell...

hi,

as i have said in my first post i have already used two paramateters and its working fine with it , but i want to knwo if any good solution...