Nope. It's not possible to JOIN an EXECUTE. One more reason why I use table valued functions instead of procedures if possible.

Hi kramaswamy

There should be no difference between "SELECT *" and "SELECT TOP(1) 1" (you should use the braces syntax for SSE2k5 and later versions) if you use them for EXISTS...

Hi Bob! Nice to see you too! I'm quiet busy those...

Hi

If you just need to call the procedure in Oracle without moving any data to SQL Server I wouldn't use a linked server to handle this. I wouldn't even use...

Here are some references:

A referenced tool from sourceforge:

http://www.sqlservercentral.com/scripts/Miscellaneous/31882/

A script from this site

http://www.sqlservercentral.com/scripts/Create+DDL+sql+statements/65863/

Here you see a sample of Barry how to use SMO within VB.NET (can also be done in VB-script)

http://www.sqlservercentral.com/Forums/Topic470115-145-1.aspx

If...

Hi Adi

Good idea! Just tried it. Somebody told me the return code of xp_cmdshell does not work but it works fine.

So I can add the "-o" option and either load...

Hi Craig

Thanks for the feedback!

Could you explain the error and how...

Hi ujjp

500 million rows are too much for one INSERT statement. Try to work in 100,000 or 500,000 row chunks.

If your table has a single column primary key it shouldn't...

Hi

T-SQL does not support any build in feature to script the DDL for a table but there are many custom scripts on this site to generate DDL scripts.

Another option would...

What about storing your images/file-content within a database table? In this case you wouldn't even need an external access. If you need to access them very often you can use...

Hi

Your XML works fine for me:

DECLARE @t TABLE

(

ChanalNo VARCHAR(20),

dpc VARCHAR(150),

epc VARCHAR(150)

)

DECLARE @items xml

SELECT @items = '

501

e01

502

e02

'

INSERT INTO @t

...

Hi

You can use the SharePoint concept and use a web service to provide your documents. The url can be parsed by the web service and return the correct document. The...

Hi

The main difference between LINQ2SQL and EF is the abstraction layer - in my opinion.

LINQ2SQL (or typed DataSets) is a 1:1 look to the database structure. It is possible to...

Hi llloyd

I think there is no way to work with another trust level than UNSAFE. Embedded resources are unmanaged data so SQL Server doesn't allow them in any other trust...

Hi

There seems to be no simpler solution. Copy B(1) to B(2) with another A-key. Copy all C and D relations from B(1) to B(2).

However sounds quiet forward in my opinion....