quote:

---

There is an application built in java env and it has a SQL query in it. The back-end here is DB2. Below...

quote:

---

We've considered at times branching out a little, but our core competency is SQL so we've been sticking to what we know/do....

Hi,

some points in here http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17226 might be of interest to you.

In short, there is no ordering in a table.

However, you can use a clustered index to store in a...

quote:

---

As you know when you show the properties of a database from within

Enterprise Manager one of the values its shows is...

Hi there,

I thought I'd throw in some oil in the fire and post a reply from the great Joe Celko on the MS newsgroups that (might) say it all. Anyway,...

To piggy-back on Guarddata normally I would say keep it in one table, dessign and index it properly and you'll be fine.

But without knowing what kind of application (maybe...

A basic script could look like this

SET NOCOUNT ON

USE Northwind

GO

DECLARE @newname VARCHAR(50)

SET @newname = CAST(DATEPART(yyyy,GETDATE()) AS CHAR(4))

EXEC sp_rename 'customers',@newname

GO

SELECT * FROM [2003]

EXEC sp_rename '2003', 'customers'

SELECT *...

Basically, this is nice

http://www.aspfaq.com/show.asp?id=2120

Frank

http://www.insidesql.de

Hi vangogh,

you might want to look at this one.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=633&lngWId=5

Haven't tried it though, because I think this is more presentational stuff of the application

Frank

http://www.insidesql.de

Writing the script shouldn't be difficult, but as Ray mentioned, the even better question is why?

Frank

http://www.insidesql.de