http://www.sommarskog.se/arrays-in-sql.html

To extend on Steve, here's a code snippet that might give you some ideas

set nocount on

declare @ip varchar(255), @cmd varchar(100)

set @cmd = 'ping ' + HOST_NAME()

create table #temptb...

I think it is documented behaviour that SQL Server will stop when there is no more log space available. See if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;307487

No, I don't think any question here is a waste at all !!!

Sure, my site is German since I am from Germany.

As for...

No, you can't stop them from being logged. They are necessary to ensure the system's ACID properties. However, you change can your recovery model to simple, as you already did...

Read this:

http://www.sommarskog.se/arrays-in-sql.html

and this:

http://www.sommarskog.se/dynamic_sql.html

See if this helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;319701

http://support.microsoft.com/default.aspx?scid=kb;en-us;198572

No, none that I'm aware of.

Could you give an example?

I'm not sure what exactly you want to do.

AFAIK has nocache something to do with generating sequences. So my best bet would be, there is no direct equivalent. However, something like the IDENTITY function might prove useful at...

Glad I could help

A code snippet would be of some help.

AFAIK, no!

You might want to try this in EM:

Create a new table. Save it. Change a column to have the IDENTITY property defined on it. Click on Generate Change script....

Okay, if it's for an interview, I would say the difference is that you should avoid UDF's whereever you can, while you should use stored procedures whereever you can. Exceptions...

If you can,you might want to read "Inside SQL Server 2000" on that topic. Might be a more reliable reference than the ones you've quoted.

While it is true that almost...