Forum Replies Created

Viewing 15 posts - 9,556 through 9,570 (of 13,460 total)

  • RE: how to improve qurey perpormace

    lot of one line questions from you; without details, google and research may be your best bet;

    look at teh execution plan and determine if any indexes would help; make sure...

    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!

    May 2, 2010 at 5:32 am

    #1160976

  • RE: ecxptions

    take a look in books on line for the try-catch statement;

    if an error is raised, you can put in some logic to do something different that failed in the TRY

    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!

    May 2, 2010 at 5:31 am

    #1160975

  • RE: String splitter to table weird result

    Digs thanks; as always, you post everything someone might need to test the scenario. I really appreciate it.

    this was interesting as heck; i got similar results when trying to use...

    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!

    May 1, 2010 at 7:56 pm

    #1160944

  • RE: Retreive an error for an UPDATE SQL Statement

    yeah from a SQL perspective, an update that affects zero rows is not an "error", but from your perspective it's a logical error, as you expected at least one row...

    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!

    May 1, 2010 at 6:28 am

    #1160889

  • RE: outputting a sql database to an email /to windows

    craig 84462 (5/1/2010)

    I have imported a microsoft database into sql server but now I want to 'export' it out into a folder in windows explorer in order to email 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!

    May 1, 2010 at 6:23 am

    #1160888

  • RE: Read logfile with vb.net (in admin mode)

    if it's a class exercise, I'm sure if you read the instructions for the exercise, or maybe read the chapter in your study materials for the course, it will cover...

    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!

    May 1, 2010 at 6:16 am

    #1160887

  • RE: Strange Behavior, Invalid Field no matter what I name it.

    the script you pasted, assuming a missing closing-parenthesis, makes [IsRegistered] the table's primary key; was that the desired results? was there something missing like a comma and the rest of...

    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!

    April 30, 2010 at 5:06 pm

    #1160810

  • RE: Table level backup

    not directly from MS, no table level backups.

    I believe some of the RedGate stuff does it, and i know you can script out the table and the data right from...

    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!

    April 30, 2010 at 4:55 pm

    #1160809

  • RE: Dynamic SQL To Update Table With CASE

    David Portas (4/30/2010)

    Why would you do that? Use one table with a month number column and you won't have to use dynamic SQL at all.

    excellent point, David. sometimes you need...

    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!

    April 30, 2010 at 12:29 pm

    #1160678

  • RE: Dynamic SQL To Update Table With CASE

    Danny i think this is just a basic syntax issue;

    if you are building a string that ahs a single quote in it, two single quotes in a row signify 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!

    April 30, 2010 at 11:56 am

    #1160658

  • RE: compact database backups

    replication does not require a constant connection; merge replication, for example, would stack up untill it got PULLED; log shipping would be up to the other end to grab...

    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!

    April 30, 2010 at 11:52 am

    #1160655

  • RE: Replace column

    I want to replace 2 and 4 with 5 and 6.

    --edited and removed when i found out it was homework.

    For homework, me pasting a solution helps noone; you never learn...

    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!

    April 30, 2010 at 11:45 am

    #1160647

  • RE: compact database backups

    even with the maximum compression settings a backup file that compresses to 200meg might go to 189meg with higher compression; there is no miracle compression that will shrink a gig...

    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!

    April 30, 2010 at 11:28 am

    #1160636

  • RE: Table function - list of parameters

    what would the function do with the values if it got them? you might be looking at a problem head on, when a sideways look might present a better solution.

    what...

    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!

    April 30, 2010 at 11:19 am

    #1160626

  • RE: The value of variable is disappearing in stored procedure

    chaturvedi.garima (4/30/2010)

    Hi!!!

    The variable is initialized in a stored procedure with the value present in a table.

    It is disappearing at later point of time.The data type of variable is Char.

    Tried to...

    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!

    April 30, 2010 at 11:15 am

    #1160621

Viewing 15 posts - 9,556 through 9,570 (of 13,460 total)