Viewing 15 posts - 37,531 through 37,545 (of 39,456 total)
I like that. I think you should have some xx experience before you even take the test, like 1yr documented experience.
Steve Jones
April 25, 2002 at 12:39 pm
Do you have a service names MSSQL$SQL2000?
Might try re-running setup, also, I hate names like this because there might be something reserved. Can you makeup some other instance name?
Steve Jones
April 25, 2002 at 12:38 pm
I'm slightly confused as to why you need to know if the strings are longer, but that's besides the point.
If you are worried about imports, I'd make an import table...
April 25, 2002 at 12:36 pm
update mytable
set myvalue =
case
when mv_dummy = 1
then "a"
when mv_dummy = 2
...
April 25, 2002 at 12:32 pm
Are you having performance issues? Are there unexplained slow times? Jobs might help, but if not, then might not be a benefit.
Of course, it won't hurt, but then your window...
April 25, 2002 at 12:28 pm
April 25, 2002 at 11:46 am
A trigger fires once for the transaction, not for each row. So if you insert multiple rows you will have problems.
This trigger also appears that you will always get the...
April 25, 2002 at 11:44 am
Be easy to write something. You could query systables and syscolumns to get the data.
Or you could use sp_OACreate to create a DMP object and use that.
Steve Jones
April 25, 2002 at 11:37 am
This is actually very cool. So nice to work a query in one window and something else in another.
This was run on W98 as well (and XP). I did this...
April 25, 2002 at 11:34 am
April 25, 2002 at 11:19 am
You need some other key from Oracle. Otherwise there is no way to know what the PK will be. I've run into this before, trying to move data from SQL->SQL....
April 23, 2002 at 10:41 am
monthname(date) will give you the current month as an activeX item. If you need SQL, then select datename( m, getdate()).
If this is SQL 2000, you can use a dynamic properties...
April 23, 2002 at 10:39 am
Can you provide the table schem (DDL) as well as what changes you want to make. May be 2-3 lines of sample before and after data.
We can then help.
Steve Jones
April 23, 2002 at 10:30 am
In here are some books we have listed. There are reviews for a few with some comments.
http://www.sqlservercentral.com/books/books.asp?categoryid=5&categorynm=T-SQL
Celko's book probably has more theory, but it's written kind of high handed.
Steve Jones
April 22, 2002 at 12:27 pm
April 22, 2002 at 12:24 pm
Viewing 15 posts - 37,531 through 37,545 (of 39,456 total)