What are you using now?  If you've never taken any certification exams, then your first one should be on material with which you are most comfortable.

The 2005 certification exams cover...

For an effective source control solution, it helps to go through and uninstall Enterprise Manager from anyone who will be touching your systems.  Otherwise, you get folks who use it...

Have you tried loading up a SqlTypes.SqlXml variable with your document and passing that as a parameter to a stored procedure? 

The procedure:

CREATE PROC...

I see you're using the templates.  Note that they are just samples, and there's plenty of room for you to modify them for your needs.  This stored procedure template sets...

Red Gate's SQL Data Compare can reduce that pain:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

(If you buy, tell them an MCT sent you )

As for any aspiring developers reading...

SQL Server has no hand in the management of connection pooling.

Connection pooling is similar to a bank of phones used by a research department.  One guy calls the library (dials...

This sounds like a homework problem.

What have you tried?

I'm guessing you're running this in Query Analyzer.

Your actual output is the full length, but QA is cutting it off.  From the menu, choose Tools -> Options and look for...

> then do I still need two SQL Server licences or just the one as I'm not going to need SQL Server installed on the box in the DMZ?

http://www.microsoft.com/sql/howtobuy/default.mspx

There's...

> is this the right way to implement the reporting services ?

Blocking anonymous access is the correct part, yes.

Remember there are three steps to running reports from an application:

1. ...

UNPIVOT is the key, here:

DECLARE @test table(id int, math int, bio  

Place parentheses around @n:

SELECT TOP (@n) notrans, NOTARJETA, NOCLIENTE

-Eddie

Robert:  the [1] is required, the Pragmatics would call it RTFM.

The xquery.value() function requires a singleton result.  Even though, in this case, leaving...

Japanese time does not have AM and PM; it's a 24-hour clock. 

Instead of 5:27pm, use 17:27.

12:00 am = 0:00

6:00 am = 6:00

12:00 pm = 12:00

6:00 pm = 18:00

-Eddie

For the second question, the CONVERT function can format dates.  See BOL for all the different options.

To format a date as yyyy/mm/dd, use CONVERT(char(10), DateToFormat, 111)