Viewing 15 posts - 37,801 through 37,815 (of 39,720 total)
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
April 22, 2002 at 12:23 pm
I'm not sold on log shipping, mainly because I've seen too many errors with MS tools like this. I prefer to do it myself.
Total DB size (3 dbs) was about...
April 22, 2002 at 10:23 am
I'm not sure who is running instances, but this is an interesting idea.
Couple things. By default the services share resources. So if a query in one instance runs amok, it...
April 22, 2002 at 10:20 am
Since SQL Server doesn't track physical order, you need someway to order the rows. As Ansy said, you can use a cursor, but you still need ordering.
Steve Jones
April 21, 2002 at 4:16 pm
select b.firstname, b.lastname, b.middlename, a.dob, count(*)
from emp a
inner join emp b
on a.emp_id = b.emp_id
group by b.firstname, b.lastname, b.middlename,...
April 21, 2002 at 4:10 pm
April 19, 2002 at 1:36 pm
Viewing 15 posts - 37,801 through 37,815 (of 39,720 total)