Viewing 15 posts - 511 through 525 (of 575 total)
Do you get an error when you attempt to apply the permission?
What happens when you try to apply permissions to the newly added Column?
March 4, 2004 at 9:00 pm
Depending on how you wish to calculate ie;Hours, Minutes or seconds. The following query should get you on the right track!
DECLARE @StartDate DATETIME, @EndDate DATETIME
SELECT DATEDIFF(mi, @StartDate, @EndDate) AS 'Time...
March 1, 2004 at 6:07 pm
One way to do this is to BULK INSERT from the csv into a temporary table, then from the temporary table insert into the real table using your programmatic logic...
February 26, 2004 at 6:28 pm
You need to implement Merge Replication. Have a look in BOL and make sure you test frist in a test environment as Merge Replication is not for the faint hearted!
February 26, 2004 at 6:07 pm
Do yourself a favor and convince your manager that Sybase sucks a big fat one! Also tell him that Microsoft SQL Server has gone leaps and bounds and that they...
February 26, 2004 at 6:05 pm
mharr,
I'm using MSDE on my desktop. I 'm trying to emulate a remote server by specifying the local hard drive as oppossed to specifying a device that knows where it...
February 25, 2004 at 7:30 pm
Your problem is indeed with Replication! When an insert takes place on a Table that is replicated that also has a trigger defined on it, 2 transactions will take place!
What...
February 25, 2004 at 6:57 pm
I agreewith Frank kalis. A single Database approach is the place to start.
I don't know why you are even contemplating multiple Database at this stage! The fist stage is to...
February 23, 2004 at 9:39 pm
You can't ALTER a Text Column!
You will haveto create a new Column of DataType NText and copy the data in that new Column.
February 23, 2004 at 9:11 pm
So if it takes 3 minutes to Update 1000000 Records, then it would take 69 Minutes to Update 23000000 records if you were to do it 1000000 records at a...
February 22, 2004 at 10:14 pm
I apologise!
What is the Primary Key for the table?
The best way to do this is to use a BETWEEN Clause. For example we will use say WHERE PK BETWEEN 1...
February 22, 2004 at 9:33 pm
How on earth can this be done with CHARINDEX?
CHARINDEX will only Return the starting position of the specified expression in a character string, which will be a number!
February 22, 2004 at 9:21 pm
FORGET about the loop!
Just do it the way I showed you!
February 22, 2004 at 8:56 pm
I'm assuming jeffwe is talking about using the BCP Process I have mentioned in a DTS Package!
February 22, 2004 at 7:02 pm
Try this. Do this at every 1000 records!
SET ROWCOUNT 1000
update sde.conman.navtechQ4_2003 set
stfips = t1.stfips
from sde.conman.navtechq4_2003 t
inner join sde.conman.navtech t1 on (t1.link_id = t.link_id)
February 22, 2004 at 6:37 pm
Viewing 15 posts - 511 through 525 (of 575 total)