I really feel with you, to have entirely undocumented code in a DB is a pain in the... you know where. Well, for the start you can comment 3 UDFs (this one...

Hello,

the function has no comments? That "someone else" should learn to put comments in permanent code always - even if it seems to be easy to understand.

OK, I can see more...

Yes, Sergiy, it is very similar in Czech - the counted unit is changing, too.

Jeff, I think I know a bit more about languages and grammatics than the average people,...

That's right, it is spelled differently and it is not a typo. Czech language uses declination, which is a thing that complicates it a lot for foreigners. Latin has 6 , German...

Lucky you, if you only have to work with such a simple language as English. In Czech language, the words like "hundred" or "thousand" have different forms depending on whether...

Look up CONVERT (item "CAST and CONVERT") in BOL. With CONVERT, you will receive the output as varchar, and there is a possibility to choose style. There is a nice table...

Thanks, that really means the dates after upgrade are entered incorrectly (9th February as 2nd September). As soon as you will try to insert DateCreated with day greater than 12,...

Most probably it would be to your advantage to index this column. There are even circumstances when it is a good idea to put a clustered (though possibly non-unique) index...

Good, that should help... Please run the same query again and include third column, which will contain CONVERT(varchar(20), dateCreated,113), so that we can see what is really stored in the DB.

So...

Sorry, I probably didn't make myself clear enough... If your column is Datetime, and you enter the date in format '20060211', it is neither stored nor displayed in this format. It...

To further explain the previous answers, you put the code that updates your data in a stored procedure. Then you can create a job (SQL Server Agent) that starts this...

DECLARE @new Table TABLE creates a variable of type table. All variables are created only in the current scope - that means, as soon as the procedure or batch is...

If you want to put the result of a select (multiple rows) into a variable, you have to declare that variable as TABLE variable. Otherwise, the variable can have only...

Hi Stephen,

datetime column data are not stored the way you see them (neither in SQLS 2000 nor 2005). In both cases, a code is stored instead.

From BOL to SQLS 2000:

Values...

Hello,

as I understand it, you have table Orders (order header, 1 for each order) and OrderDetail (order lines, can be several per order), and table Aristo, which stores info about...