I switched jobs in May 2000 from a good size stable company to a dot com called bigdough.com. At the time people at my previous job were concerned that...

To avoid the issue of people executing their own code you can use this code for each variable that is non numeric:

SET @txtLastName = REPLACE(@txtLastName,'''','''''')

Robert Marda

SQL Server will deliver its...

I agree with you. SQL Server doesn't always choose the right execution plan and when I can't find a way to get it to choose the correct one then...

The clustered index only has one column.

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL Programmer enough developing time.

That fixed it. Thanks!

Now, does anyone know why that would fix this problem?

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL...

Is this what you are looking for?

CREATE PROCEDURE BuildDynamic

(

@cboGender char(1),

@txtFirstName varchar(10) = '',

@txtLastName varchar(10) = ''

) AS

DECLARE

@strSQL varchar(2000),

@strINSERT varchar(1000),

@strSELECT varchar(1000)

SET @strINSERT = 'INSERT INTO tblPerson ('

SET @strSELECT =...

Another option is to place the step name below or near each description name in the DTS package. This is what I do. It takes time to put...

Try this:

DECLARE @datetime datetime

SET @datetime = getdate()

SELECT @datetime, LEFT(CONVERT(varchar(10), @datetime, 103),5), CONVERT(varchar(10), @datetime, 108)

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL...

Use something like this:

ALTER TABLE tablename ALTER COLUMN columnname datatype

GO

simply replace the word datatype with the datatype you want to change the column datatype to.

An example would be to change...

I spoke with our DBA and he said that what they did was to uninstall SQL Server 7.0 and then install SQL Server 2000. He said this was done...

To make this work using the CASE function you can only have a column name or variable after the key word THEN. You can't have a complete comparison.

One example...

We did this recently (about a month and a half ago). What we did was add two more clusters so we transfered all our databases to those and then...

I live by the concept that no matter how good your security (or password) is there will always be someone that can find a way to break it. Nothing...

Play computer games!

and delete junk mail such as chain letters and virus alerts!

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL Programmer...

I prefer using the numbers across the top of the key board. I know where they are and can find them easily, whereas I have little experience with the...