Viewing 15 posts - 121 through 135 (of 141 total)
when you say it is returning 0 as your count verify that you are updating the correct thing. How are you verifying that it is 0?
Something I noticed is you...
July 2, 2007 at 7:04 am
So far I have only looked at a few new things.
The ability to pass a table valued parameter to a stored procedure by declaring a type. I am not...
July 2, 2007 at 6:52 am
A restart might clear it, but it could also just begin the recovery / rollback process right back up, or worse case scenario make your database suspect.
The rollback operation typically...
June 18, 2007 at 2:58 pm
The simple answer is yes they will affect query performance, but without knowing more specifically the data model, indexes, what type of local variable (table, scalar) etc I can not...
June 14, 2007 at 5:49 am
As ALZDBA stated insert the procedure results to a temp table.
CREATE TABLE #TEMP (....)
INSERT INTO #TEMP
EXEC ProcedureName
Then join on the tables.
June 12, 2007 at 10:01 am
Not sure exactly what you are asking.
To configure sql go into surface area configuration manager > database engine > remote connections
Also you might have to go into SQL Server Configuration...
June 7, 2007 at 6:14 am
you could do an insert,update trigger that fails if your check from the other table is not valid.
A check constraint could also potentially be used.
June 6, 2007 at 10:51 am
within access you can do the database upgrade wizard.
from within sql you can do an import data (and select all the objects you want)
May 24, 2007 at 5:48 am
if you have tables with large number of records it may be a good idea to just script out all your creates and recreate the db.
May 22, 2007 at 5:54 am
This is typically restore the database as a different name.
recreate your table in DB you dropped it from.
insert the records from the backup database to the recreated table.
You may have...
May 15, 2007 at 10:56 am
Modifying your first select with SQL ORACLEs reccomendations should do the trick for you.
April 5, 2007 at 6:51 am
This should handle a few more rules. Such as the apartment rule you are using. Obviously your address line 2 could still be over 25 characters if the address to...
March 21, 2007 at 7:44 am
The only places I think xml might be useful is if you need to produce something like project specific surveys etc and the questions / answers could be different and...
February 20, 2007 at 7:41 am
Viewing 15 posts - 121 through 135 (of 141 total)