thanks michael.

I agree.. 🙂

thank u very much coldcoffee:-)

hi Kingston Dhasian, Hope you are not compiled this..

One more help guys.

Is it possible to specify seed increment dynamically for identity column.

I tried as follow but still getting error. Can u plz hav a look.

create table #t1(ID numeric...

thanks joe

Sashi I asked to remove column identity property completely.. however thanks u too..

Grant Fritchey (3/3/2010)

---

Personally, I've put PowerShell to work on this problem. Generating scripts from within TSQL can be a bit problematic. Using SMO, which is how the Management Studio works,...

Thank u.. vidya_pande

Yes it is a particular table.

Could you tell me, how we can generate the particular table structure including the constraints through T_SQL.

cheers,

Asan

it may one of solution:

DECLARE @data NVARCHAR(MAX),

@delimiter NVARCHAR(5)

SELECT @data = '1,2,3,6,7,8,R,a,n,g,a,n,a,t,h',@delimiter = ','

DECLARE @textXML XML;

SELECT @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>'...

much of thanks Fazalul Haque n all..

nice effort..

got a solution..

thanks Derek..

plz look in to above comments too..

I forgot to mention I need root path as well..

For example:

Take 'H' since it is least node. I need output like this A-B-F-H

I'd like to thank bdba n coldcoffe for their support 😛

thanks COldCoffee ..

how come we know the language .. which has been configured.?

I got it in msdn..

DBCC USEROPTIONS

for the above requirements.

hi,

Assume that TableA contain ID,name,score

ID '5' is having multiple records with same name but...

Hi,

--Chris

Your solution will eliminate duplicates, only if all the columns are contain the same value..

--Bergeron

your solution is fulfilling my requirement.

Thanking you both for giving such valuable solution..