Forum Replies Created

Viewing 15 posts - 13,246 through 13,260 (of 13,460 total)

  • RE: PDA to manage databases?

    if it's web enabled, it'd be a piece fo cake to make a mobile web page that allows you to do whatever functions you feel can be done by remote...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 23, 2005 at 1:21 pm

    #592736

  • RE: help needed with xp_cmdshell

    two issues here. first, you forgot to quote the url, so if you tested the vbs file from a command prompt to see if it works, you'd see it errors...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 23, 2005 at 12:24 pm

    #592711

  • RE: Removing blank space

    what happens to countries that have two part names, ie "United Kingdom", "United States", or "Federated States of Micronesia"?

    woudn't you compact them and turn them to wrong values?

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 23, 2005 at 12:04 pm

    #592702

  • RE: Sounds Like

    i though soundex didn't work if the value started with a number? so an address like 123 main street vs 321 main St was ineffective?

    select soundex('123 main street') = 0000

    select...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 21, 2005 at 8:07 am

    #591778

  • RE: Convert RTF data

    ok i just found an example on another forum that might help:

    create function dbo.RTF2TXT(@in varchar(8000)) RETURNS  varchar(8000) AS

    BEGIN

    DECLARE @object int

    DECLARE @hr int

    DECLARE @out varchar(8000)

    -- Create an...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 20, 2005 at 7:17 am

    #591300

  • RE: Convert RTF data

    i've used a quick and dirty vb app that has a RichTextBox control on it. it has a single function; I pass it an ADODB.Field, which it places int eh...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 20, 2005 at 7:08 am

    #591291

  • RE: transform hand written data

    sounds like yet another outsourcing to India to save money

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 20, 2005 at 6:56 am

    #591282

  • RE: Data type for Gender

    i typically use a char(1) with a check constraint to allow only two values:

    ie ALTER TABLE BLAH ADD GENDER CHAR(1) NULL CHECK (GENDER='M' OR GENDER='F')

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 16, 2005 at 6:21 am

    #590522

  • RE: SQL ERROR

    I've seen this error in ADO when you stick a string into a varchar that is smaller than the string...ie sticka  30 character string into a varchar(20), and the ADO...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 16, 2005 at 6:10 am

    #590516

  • RE: Magic Table

    The magic tables are the virtual tables available in a trigger:

    ie the [INSERTED] and [DELETED] tables, which can be referenced within a trigger so that you can add additional logic...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 14, 2005 at 8:06 am

    #589720

  • RE: Design question (subclassing)

    i would do this with three tables: as new/differet items are added, if they cannot use an existing attribute to describe them, it is added to the lookup table.

    A similar...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 13, 2005 at 2:09 pm

    #589506

  • RE: Surprising Problem

    could you have an uncommitted transaction that was created during testing, but never committed or rolled back?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 13, 2005 at 12:05 pm

    #589467

  • RE: Is it possible to dynamically change Database properties?

    in a nutshell, yes; you can change anything dynamically.

    see sp_dboption in the BOL; also look in master and look at any of the stored frocs that start with sp_db or...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 13, 2005 at 10:01 am

    #589436

  • RE: Local variable as seed in an identity column

    while the table definition doesn't allow variables, the DBCC command to change the starting value does:

    declare @C1 int

    set @c1=99

    create table #sometable(id1 int IDENTITY(1, 1))

    DBCC CHECKIDENT( [#sometable],RESEED,@c1)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 13, 2005 at 9:50 am

    #589428

  • RE: Continuous SQL SERVER Errors

    this might help: i believe that error  Operating system error 21(The device is not ready.) encountered. means that the path to the device(in this case a log file) does not...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 13, 2005 at 6:22 am

    #589317

Viewing 15 posts - 13,246 through 13,260 (of 13,460 total)