Could you post the format file you are using and some (anonymiced) sample data?

Hint:

Be careful with UltraEdit configuration. Default configuration is to automatically convert UNIX line-feed to windows carriage-return/line-feed. Have...

Lynn Pettis (3/16/2009)

---

Stay away from TEXT, NTEXT, and IMAGE data types. They have been depreciated in SQL Server 2005 and may not be supported in future versions. For...

Included fields are only a gain for data access. They will not be used for data correctness checs within UNIQUE INDEXES.

I confirm GSquared to use a procedure which enforces the...

Hi Steve

SQL Server does not allocate the maximal possible storage for VARCHAR(MAX) nor for TEXT (this would be 2GB per field 😉 ).

I would even advice to use a TEXT...

Hello

What I understood:

* @orderstatus may be ALL or an specific status

* @orderdate may be NULL or a specific date

* @createdate may be NULL or a specific date, but the time...

Hi Wendy

If you are using Visual Studio you should either create a CLR function or work with SSIS.

Here an example with C# and RegEx (use a form and a button):

...

Hi Wendy

Sure that is possible with SQL, but I would advice to do it with a client application or SSIS. How do you get this string?

If you really want to...

Hi

You can use the REPLICATE function:

DECLARE @t TABLE (txt VARCHAR(100))

INSERT INTO @t VALUES('123')

INSERT INTO @t VALUES('12345')

INSERT INTO @t VALUES('123456')

SELECT txt, REPLICATE('0', 9 - LEN(txt)) + txt

FROM @t

Greets

Flo

Hi

The size difference between the backup and the archive is okay. The SQL Server backup files are not archived and many information are text/int so the compression is quiet good....

Hi

It was just an example with test values. Try this:

DECLARE @t TABLE (map_coords VARCHAR(100))

INSERT INTO @t VALUES ('00123456 01234567')

SELECT map_coords,

SUBSTRING(map_coords, 1, CHARINDEX('...

Hi

Here a little sample:

DECLARE @t TABLE (c1 VARCHAR(100), c2 VARCHAR(100))

INSERT INTO @t VALUES ('00000 11111', '22222 33333')

SELECT SUBSTRING(c1, 1, CHARINDEX(' ', c1)),

SUBSTRING(c1,...

Hi Cathy

If your server is already installed as x64 Server it will be better to install x64 SQL Server. If you are running an x86 application on an x64 OS...

Hello

CREATE PROCEDURE MyProc

@Id int,

@Name varchar(50),

@Fname Varchar(50),

@Deptno int

as

BEGIN TRY

BEGIN TRANSACTION

INSERT INTO t1 values(@Id,@Name)

INSERT INTO t2 values(@Id,@FName)

INSERT...

Hi

No that's not possible via SQL. The SSMS is only a client which transports information between you and your SQL Server. The SQL will not be executed in SSMS; only...

Hello Matt

Some investigations:

1.)

Did you use a named instance?

2.)

Try from command line: "sqlcmd -L" to see which servers are available. Do you see your server name twice? Maybe once with a...