Viewing 15 posts - 13,396 through 13,410 (of 13,419 total)
If you are using the IMPORT or EXPORT functionality from Enterprise Manager,it might be because you are using the default options:
If you used Right click>>All Tasks>>Import Data (or Export data)
Then...
August 17, 2004 at 6:33 am
Thanks for the reply Hans;
This has been kinda educational for me.Here's what I had assumed:
a database is open or closed depending on the autoclose option of the database....so on a...
May 11, 2004 at 6:51 am
you just concatenate the fields with the hardcoded stuff;
update tablename
set email = fname + '.'+ lname + '@domain.com'
here's a substring example in case you wanted first initial + lastname:
update...
May 10, 2004 at 11:18 am
I'm not sure if this will work, but what about this:
--edited to add an inner join to get the staff id's last tip
CREATE PROCEDURE [dbo].[prc001GetTipOfTheDay]
(@intStaffID int)
AS
Select Top 1...
February 25, 2004 at 11:09 am
Here's my answer ot the second half of your question:
a text column is used when you have data that is going to be really big; a varchar has a max...
February 25, 2004 at 10:51 am
I believe I picked this up as one of the scripts submitted to the site;
there's an export and inport function below; i never tested this myself:
--**************************************
--
-- Name: Procedure to...
January 14, 2004 at 6:59 am
I guess I should clarify; The Process in VB takes 30 seconds; the process runs hundreds/thousands of similar queries,one for each transaction it tries to post to the accounting tables,...
December 30, 2003 at 7:34 am
unfortunately, the db is in another state, and administered by a dba there; I was trying to diagnose issues by remote;
both Auto Update Statistics and Auto create Statistics are turned...
December 29, 2003 at 10:05 am
To expand on this issue I was hoping to read more specifics, and followed up on this myself:
If I was creating a new database, what collation would I use to...
November 14, 2003 at 7:41 am
I'm certainly no expert on the issue, but from what I gather, this program "clusters" two SQL servers, but they do not need to share the same storage location...it allows...
September 30, 2003 at 1:43 pm
I received my book the same time that SQLBill did; thanks everyone.
It's time to beat your own drum though... i noticed that on the site that covers books and reviews,...
September 19, 2003 at 9:24 am
I think you'll have to use more than just the customers first and last names to cull duplications out.
I would think that it would be very easy to have...
August 27, 2003 at 2:23 pm
You might want to check your backup strategy.
I bet it started at 4am and your database was locked because of it.
That might be the root cause of your failure.
Lowell
August 13, 2003 at 7:51 am
Thanks Allen That's good to know; maybe Brian Knight could update his article to mention something about how it is not possible to rename SQL server Instances;
It would make...
July 29, 2003 at 6:19 am
This does what you wanted; the select at the end shows how you can find the # days before /number of days until the users next birthday:
CREATE VIEW UserBirthDay
AS...
July 23, 2003 at 2:22 pm
Viewing 15 posts - 13,396 through 13,410 (of 13,419 total)