Lars,

An even better way to declare the cursor would be to use a local variable.

DECLARE @c1 CURSOR

SET @c1 = CURSOR FOR...

Everything else is the same but you have now limited...

Steve, this is actually in SQL Books Online under Alter Table. It is as follows...

Syntax

ALTER TABLE table

<SNIP>

< table_constraint > ::=

    [ CONSTRAINT constraint_name ]

    { [ {...

As Bill stated it looks like the problem is with creating the view in a different database than your current database. So what you need to do is shell out to...

Use a simple Insert statement that selects the old record and puts the new values in as variables...

INSERT INTO Foo(fldlist)

SELECT @var1, @var2, fldlist FROM Foo WHERE ....

Cynthia,

Since you are coming from an Access ADP I would think what you really need to do is create a stored procedure to do this and then call it from...

We actually have a field where we store formatted XML. This usually has quite a few tabs in it. I was handed the db design when I got here. But...

Sheetal,

Can you post some samples that we might be able to see what you are having problems with?

Basically what I have found is that if your default database collation...

The simple answer is NO. The more detailed answer is that it can be done if you place the table in it's own file group and then just backup the...

Matt,

If you open SQL Server Books Online (IE: Sql servers version of help) and put "system stored procedures, listed" in the Index you will get all the publically listed system...

Greg another way would be to use the COLLATE clause on your field.

SELECT I_use COLLATE Latin1_General_Bin

    , COUNT(I_use COLLATE Latin1_General_Bin)

FROM #t

OR Better yet when you create your temp table just...

I typically cheat a bit and use the ISNULL to replace the nulls with all Z's

SELECT fld

FROM Foo

ORDER BY ISNULL(fld,'zzzzzzzz')

Since the uniqueidentifiers always have the same format you should be able to use that to quickly look up those values.

IF EXISTS(SELECT * FROM tempdb..sysobjects WHERE id = object_id('tempdb..#Test'))

    DROP...

I chose not to use replace as there may be other places that have valid tabs. Replace is certainly good if you know the data only has the tab as...

Basically what I would do in this situation is to create a JobRequest table that holds the information needed to call the SP that does the bulk insert. Then in...

Is the last character of the string always what you want at the beginning? If so try something like the following.

UPDATE Foo

SET fld = RIGHT(fld,1) + LEFT(REPLACE(fld,'-',''), LEN(REPLACE(fld,'-',''))-1)

I don't have...