That link is actually for businesses not for developers, the developer link includes management studio.  That said I don't understand what a SQL Server person is doing with Express when...

JOIN and WHERE clause cannot be compared because the WHERE clause is a filter while JOIN is used to generate resultset from one or more tables.   JOIN is compared to...

In SQL Server 2000 and above you can do column level collation, and there are six Chinese in SQL Server so using both Unicode and ASCII is asking for character...

It means that one of the Rows is bigger than a SQL Server page, the text below is from the link below and it includes more restrictions.  The reasons and...

Try the link below to get started.  Hope this helps.

http://www.mssqlserver.com/tsql/

Kind regards,

Gift Peddie

You are getting Character conversion in Oracle because you have not done Unicode collation in Oracle.  I have not done it in Oracle so check Oracle docs and the try...

It is actually easy to increase the Transaction Log size open the database and then open the Taskpad and you should be able to increase it.  The Taskpad is context...

If that is the case you may want to start the person with the two Ken Henderson books, they are the best in T-SQL for SQL Server 7.0/2000.  The reason...

The best training for SQL Server is install the product and use the BOL(books online).  But try the link below for free T-SQL training.  Hope this helps.

http://www.mssqlserver.com/tsql/

Kind regards,

Gift Peddie

In SQL Server 2000 it is a simple ALTER DB or Table, the definition is covered in the link below for SQL Server 2005 but it should work for SQL...

If your Excel is XP/2003 it is actually very easy because you just save the Excel as XML.  Try the link below for the Excel XML Toolbox.  Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/Office_Excel_XML_Toolbox.asp

Kind...

The link below from Microsoft covers all you need to do a clean migration, I have used both in one shop and I don't think you will run into issues...

 Apostrophes are covered under ANSI SQL 92 delimited identifiers so I think you shoud use that if you data does not include ascent sensitive language because all the ascent...

That is because the binary collation is case sensitive by default.  Hope this helps.

Kind regards,

Gift Peddie

Yes we are talking foreign keys but this foreign key is used for Cascade on delete and Cascade on update, I think you should check the BOL (books online) for...