I have used a hybrid approach: Write a procedure that generates the code to create static stored procedures. I have done exactly this for cases where we need to...

I won’t hash over the reasons for using identity surrogate keys; that has already been well expressed in this thread.

The real reason I don’t use natural primary keys is simple:...

Both methods are using an implicit cast of an integer to a datetime.

If the implicit cast of the integer to datetime stops working, then this will also stop working:

select DATEADD(dd,DATEDIFF(dd,0,Mydate),0)

It...

toniupstny (2/11/2008)

---

You could partition the tables so that Query Optimizer can pick which table to go against depending on the value of the year. For each year, create...

Do you have a question?

I guess your organization, unlike where I work, has developers that never make mistakes.

If you truncate the table before you start the load, the starting seed value of the identity column will reset to 1.

You cannot restore a SQL 2005 backup onto a SQL 2000 server.

This works in all versions of SQL Server with all regional settings, all settings of language, and all settings of datefirst.

select convert(datetime,'20080208')

If you are getting an error, if must be...

If you are running with mixed authtentication enabled, just switch the job to run as SA.

This also prevents you from having issues with domain authentication.

The format YYYYMMDD is the ideal way to format a date to insert into a SQL server datetime column, provided is is a string and not an integer.

select t1 = 10/100, t2 = 100/100, t3 = 10./100., t4 = 100./100.

Results:

t1 t2 ...

alter database [My.DB] modify name = [My.New.DB.Name]

J Sitz (2/3/2008)

---

Michael, thanks for the reply.

Whey they cut the material, it is always cut in right angels. So I believe I will have everything that I will need...

To describe an arbitrary polygon, you will also need to include information about the angles between the sides in order to exactly define the shape.

There can be polygons with the...