Do you really have double quotes around each part of the query you intend to build? I never use double qoutes with dynamic SQL as it can give problems...

I have done this with SQL Server 7.0. So I know it can be done. However it has been a while and so I don't remember all the...

I ran a test on a table with various objects you named and discovered the following:

The index stays with the column even though you rename it.

SQL Server won't let you...

Here is a query that will identify differences:

SELECT *

FROM table1 t1

INNER JOIN table2 t2 ON t1.[ID] = t2.[ID]

WHERE t1.column1 <> t2.column1

Here is a query that will update the differences:

UPDATE t2...

I believe a certification could help you get a job and in fact I think the one I hold helped me start my career in the technology sector (I have...

Forgive the delayed response.

I think you were looking at my article called Dynamic SQL vs Static SQL part 2. That one has code in the 2nd case that uses...

To be able to accurately separate first names and last names when there are more than one first name and more than one last name you would need some kind...

When we upgraded from SQL Server 7.0 SP3 to SQL Server 2000 we had some stored procedures or some queries in stored procedures that ran much slower than they did...

I think the max number of rows a table can have is only limited by how much hard drive space you have.

BOL says this about the max number of databases...

I recently submitted a stored procedure that will script tables. If you go to the script section here and look at the most recent ones you will find one...

All your responses against placing user-defined stored procedures in the master database got me curious as to whether Microsoft has said if it was a bad idea or not.

I searched...

I have never seen a reason not to put a stored procedure in the master database, it is after all just a stored procedure and if you have tested it...

One way to handle the modified data is to keep track of when you first moved it and when it was last modified. Then you can move only the...

I have been an SQL developer for about two years now. When I was first introduced to dynamic SQL I thought it was the coolest thing that you could...

We have also run into this problem. We have more than 400 or 500 stored procedures that use the NOLOCK hint on every table.

We used to see these errors...