Hi

Which version of SQL Server are you using?

Greets

Flo

Hi Christopher

Sounds that some of your servers will not trim the spaces. I thought this would be a build-in functionality in SQL Server. I just googled a bit. After some...

For the first question:

What is the specification for the Serial No? Any incremental ID? Should it contain any information? Should it be a NVE or a Code39?

For the second question:

declare...

Hi

"Flo OR SQL Guru" is absolutely correct :hehe:

Lowell already posted the correct answer in the other thread:

http://www.sqlservercentral.com/Forums/Topic680417-338-2.aspx

Greets

Flo

Glad to help you! 🙂

Hi

An example for the names would be grate 😉

Well, assumed the file group name would be "FILE_GROUP_YYYY_M" where "YYYY" identifies the year and "M" identifies the month.

DECLARE @date datetime

SET @date...

How to identify the current month? By index creation date? Is it part of the file group name?

Hi

Do you mean something like this?

SELECT st.name table_name,

si.name index_name,

sd.name data_space_name,

'DBCC DBREINDEX("' +...

No cross posts please: http://www.sqlservercentral.com/Forums/Topic680328-149-1.aspx

Hi

What do you mean with display?

If you want to select DATETIME values in specified format:

It is possible, but you should not do it. You should format your output format within...

Grant Fritchey (3/20/2009)

---

I'm really not aware of "excercises" that you can do with any of the sample databases.

If it helps at all, and I doubt it does, both my books...

Hi Jai

No direct answer to your question, but...

If you are using SSE 2k5 I would advice you to use the AdventureWorks database for learning. Pubs and Northwind are a little...

Thanks Barry! For review and feedback. 🙂

Pleased to help you. 🙂

Flo

If you want to encrypt it and know how to do that with VARCHAR maybe just convert it:

DECLARE @t TABLE (img IMAGE)

INSERT INTO @t

SELECT 0x48656c6c6f20576f726c64

SELECT CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX),...