do these four system databases would always fall under database id 1-4? if so, then i can consider this query too. By mentioning...

Thanks Michael for the clarification. i was scared yesterday of doing something wrong but it was lack of knowledge regarding restoration of databases.

Cheers Mate 🙂

i have few questions

1. How many criterias are there?

2. Is it possible that criteria 1 would come again after row 20 say at row 200?

3. What is the main purpose...

Can you please upload Oracle scripts, can have an idea what...

Satish, can you please elaborate why you want to store the date in this format?

There could be better ways to do it. Try this. I think i tried to cover every situation. 🙂

DECLARE @t TABLE

(RowID Char(16)

...

referring to Shourak's problem, i have a question to all db gurus here.

is it a good policy to make a database with user ownership if though the user is...

even i faced similar problem few weeks back. i am still unable to find why owner field in system catalogues for database was null even though no login was deleted.

i...

Hi Jeff

Thanks for the intelligent and neat solution of this big problem.

I was thinking of a scenario where the number of records in the input file is huge...

sorry RBarry, i mixed both. My apologies

i think this is what you want

select b.*

from sys.objects a inner join sys.columns b on a.object_id = b.object_id

where a.[name] = 'test1'

replace 'test1' with the table name

you can use functions like SOUNDEX() and DIFFERENCE() if you want to know match %

Hi Rob

I am not sure what you are after? Can you please provide the resultset?

Do you want UNION of both statements?

If you can provide more info, that would be...

I agree with Dave's logic. You have to manually write a program to parse this file and then store the required text from file into a table.

i did parsing...

I think you can find a way out by using a trigger. Check the following scenario.

CREATE TABLE [dbo].[test1](

[salesid] [int] NOT NULL,

[price] [int] NULL,

CONSTRAINT [PK_test1] PRIMARY KEY CLUSTERED

(

[salesid]...