Viewing 15 posts - 3,451 through 3,465 (of 7,429 total)
You may want to use a more descriptive value instead of idx, something like TimeID may be better so that you associate with your table. You will need this to...
January 31, 2003 at 11:05 am
For CAST and CONVERT won't change anything. We are just talking the difference between explicit conversion verses implicit.
As for compile time there seems to be a point here that I...
January 31, 2003 at 5:21 am
quote:
Compile errors, such as syntax errors, are not affected by SET XACT_ABORT.
Verification of datatypes occurrs...
January 31, 2003 at 4:54 am
Normally I would handle application side. But as a safety you might want to use a Check Constraint to be sure an unforseen issue doesn't allow around the app. Here...
January 31, 2003 at 4:40 am
Yes that is correct. The temp table lives in the scope. You could build the rest of you code into the String to run thru the execute statement thou so...
January 31, 2003 at 3:13 am
To do a backup of files in position SQL has to be turned off. The files are locked otherwise. However the way I consider best to backup a local machine...
January 30, 2003 at 5:56 pm
Just to add. I had thought it was my firewall which apparently the cache had been an issue in the morning getting to sites. I noted recently though that I...
January 30, 2003 at 5:22 pm
Might help if we understood the principal for the choice of a temp table. You could use subqueries or derived tables instead. What specifically is the temp table for and...
January 30, 2003 at 4:04 am
When you say title case though do you mean proper or book title type? Just want to be sure what you are after.
January 30, 2003 at 4:00 am
Cosidering the statement on gap if an insert fails I too wondered how to deal with that. The only thing I can think of is do a Table Lock during...
January 29, 2003 at 2:55 pm
quote:
Well I'll take the lazy hit, but we really have just begun installing SQL2k.I had verified that 1434 was blocked,...
January 29, 2003 at 2:50 pm
Ok I make some assumptions here if you have the source code for the app that inserts this.
I have an app where I used to log all activity with...
January 29, 2003 at 2:44 pm
If never more than 8000 characters, instead of using a text column use VARCHAR if an option. Might mean makin a table just for the text and tie with PK...
January 29, 2003 at 2:32 pm
Just to show the sp_msforeachdb way as you tried initially.
Exec sp_msforeachdb @command1= 'select db_name() as
DB_name, count(*) as objectcount from ?..sysobjects'
Note don't worry with use in statement as you just...
January 29, 2003 at 2:25 pm
I would think it better to grab from within the app code and add a column to store the tid istead of trying to do an after the fact type...
January 29, 2003 at 2:19 pm
Viewing 15 posts - 3,451 through 3,465 (of 7,429 total)