Viewing 15 posts - 37,591 through 37,605 (of 39,509 total)
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
Since you are case insensitive, the check is correct. 'abc' = 'ABC' in this case.
I've run into this and started working on a char by char check that compares the...
April 19, 2002 at 1:33 pm
Viewing 15 posts - 37,591 through 37,605 (of 39,509 total)