Forum Replies Created

Viewing 15 posts - 12,451 through 12,465 (of 13,460 total)

  • RE: Extended ascii to HTML when using select ... for XML

    ha!

    once again, stealing/borrowing Jeff Modens example and running with it, here's a TSQL function:

    --===== Create and populate a 100,000 row test table.    

    -- Column RowNum has a range of 1...

    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 12, 2007 at 7:12 am

    #733089

  • RE: Extended ascii to HTML when using select ... for XML

    obviously you can do this on the application side, but not natively in TSQL...looks like you'd need a function.

    I bet the .NET  HTMLEncode and HTMLDecode functions would be perfect for...

    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 12, 2007 at 6:43 am

    #733077

  • RE: How to prevent copying?

    As you suspect, no there's no surefire way to prevent anyone from connecting to a database and copying the schema, nor the data.  I know you probably spent a lot...

    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 12, 2007 at 5:53 am

    #733064

  • RE: BULK INSERT unix file

    I'm pretty sure \r is the row terminator for unix, and \n is the terminator for pc based text files. I've never used \n and \r together, that would be...

    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 11, 2007 at 12:00 pm

    #732879

  • RE: Filling in numbers

    here's an example that i based off of one of Jeff Modens examples...hey I'm learning:

    there'sa huge advantage performance wise to use a tally or numbers table.

    --Your Sample Table :

    CREATE...

    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 11, 2007 at 11:30 am

    #732866

  • RE: Give datareader role create priveleges?

    you are thinking about it wrong...you should create a new role that has db_datareader writes, and then any additional rights you want toa dd. don't try to change the existing...

    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 10, 2007 at 12:02 pm

    #732575

  • RE: licensing mode and dual core

    oops sorry i skimmed over that part.

    SQL server will automatically use all availalble processors. if you had a 4 proc, but licensing for only two, you'd be out of compliance...

    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 10, 2007 at 9:27 am

    #732521

  • RE: licensing mode and dual core

    there's lots of links on microsoft on this;

    licensing is per physical processor, not per virtual processor/core .

    If the motherboard has a single socket in it, (if you could afford it)...

    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 10, 2007 at 8:12 am

    #732492

  • RE: HT Import About 8000+ Text Files from 4 Hard Drive Folders Into SQL Table?

    Assuming you have SQL server installed on your laptop, you should be able to open Query Analyzer, Press F8, which will open the object browser...find the database>> open the treeview...

    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 6, 2007 at 5:56 am

    #731774

  • RE: What''''s the difference between SQL 2005 and SQL 2005 Extended?

    won't make any difference as far as databases go.... they are backed up to a specific format for SQL 2005,a dn in a manner backwards compatible with non-service pack-ed 2005...

    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 5, 2007 at 3:42 pm

    #731631

  • RE: Unexpected SQL exception in DA

    yes, i mean run a trace in profiler, preferably against a test database, but it doesn't matter.

    start a trace, and make them duplicate the error when the trace is running.

    stop the...

    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 5, 2007 at 1:51 pm

    #731610

  • RE: Unexpected SQL exception in DA

    I doubt it's happening every time right? I always call these intermittent network issues;

    it's nothing to do with the code or even with SQL server, but the network;

    it could be...

    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 5, 2007 at 1:18 pm

    #731603

  • RE: What''''s the difference between SQL 2005 and SQL 2005 Extended?

    from some page on microsoft:

    http://msdn2.microsoft.com/en-us/library/ms143506.aspx

     

    Extended System Support

    SQL Server 2005 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature...

    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 5, 2007 at 12:01 pm

    #731592

  • RE: Tougher Question--over my head

    you said you were hyperlinking to the IttNumber; why can't you simply change the hyperlink to include the Id and the IttNumber? then you can obviously use it on the...

    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 5, 2007 at 11:39 am

    #731589

  • RE: Removing unicode data from fixed width downloaded text

    elegant solution as always from Jeff;

    I'm decent with SQL, but I still haven't gotten my arms around the Tally table concept for processing;

    someday I'll grow up and be like Jeff...

    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 5, 2007 at 7:01 am

    #731485

Viewing 15 posts - 12,451 through 12,465 (of 13,460 total)