Forum Replies Created

Viewing 15 posts - 2,191 through 2,205 (of 13,460 total)

  • RE: can you have too many rows in a table

    and the issue is often not really related to the number of rows, but if it can be accessed effectively and with reasonable speed.

    that starts bringing in things like design,...

    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!

    November 14, 2014 at 2:11 pm

    #1758728

  • RE: Simple Update Query from SQL Newbie

    you probably want to cleanup line2 as well;

    i think it's something like this:

    CREATE TABLE #address(AddressID int, Line1 varchar(100), Line2 varchar(100) )

    INSERT INTO #address

    SELECT '1234','123 Main St.','Suite 2000' UNION ALL

    SELECT '6596','2400...

    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!

    November 14, 2014 at 12:52 pm

    #1758717

  • RE: Simple Update Query from SQL Newbie

    looks like you posted before you did anything more than pasting some sample data.

    what is the question?

    since your new, i've reformatted your paste into consumable format...then anyone can grab your...

    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!

    November 14, 2014 at 12:12 pm

    #1758711

  • RE: Column content is truncated when I view but there when I process

    could it be because the SSMS settings is defaulting to a 256char display limit for a column length, in order to conserve resources?

    on both the Results to Grid and Results...

    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!

    November 14, 2014 at 11:32 am

    #1758700

  • RE: In sql 2008 - One Stored procedure return data (select statement) into another stored procedure

    how can another procedure consume the data of a dynamic procedure, if it doesn't know what columns would be included?

    typically, you create a temp table and insert into it, ie:

    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!

    November 14, 2014 at 7:50 am

    #1758599

  • RE: database rolls

    Perry Whittle posted a nice script for scripting all database permissions in this thread;

    I've adapted that one to my own needs:

    the important part there is probably the nested roles, plus...

    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!

    November 14, 2014 at 6:25 am

    #1758542

  • RE: CDC get all changes function error issue

    according to this msdn, it seems like the range you are choosing for your LSN start and end are invalid, and it raises that exact error:

    could it be that your...

    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!

    November 13, 2014 at 8:33 am

    #1758259

  • RE: Track all logins on to a single SQL database

    you've got to differentiate between LOGIN and ACCESS

    a login occurs once, and might have a reference a database in it's connection string, but it never "logs into" a database.

    After...

    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!

    October 17, 2014 at 10:37 am

    #1753215

  • RE: Inconsistent Query Results in SQL Server 2008 R2

    does your query use the NOLOCK hint?

    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!

    October 17, 2014 at 10:32 am

    #1753213

  • RE: app to match clients in the different databases

    onixsoft (10/1/2014)

    Lowell (10/1/2014)

    you are overthinking this if you think you need an app for that.

    no "app" is needed for this, as the data entry for any app that 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!

    October 1, 2014 at 2:08 pm

    #1749530

  • RE: app to match clients in the different databases

    you are overthinking this if you think you need an app for that.

    no "app" is needed for this, as the data entry for any app that tried to do this...

    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!

    October 1, 2014 at 8:46 am

    #1749417

  • RE: temporary table in a stored procedure

    either drop the table once at the very top, don't use two different statements.

    also, you could modify the query to be a single one with a case statement:

    CREATE PROCEDURE MyProc...

    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 26, 2014 at 6:57 am

    #1748473

  • RE: Working with Image,text,binary datatypes

    writing to disk requires either an external application, like somethign written in .NET , or using bcp or a CLR object to help you do it.

    there's no native way ...

    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 24, 2014 at 8:11 am

    #1747848

  • RE: Seems like my SQL database is corrupted

    CliffordPreston (9/23/2014)

    Feb 20 11:49:33 kyrgyznews mysqld[11461]: ...

    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, 2014 at 10:17 am

    #1747568

  • RE: CLR, RTF to Plain Text not working.

    what error are you getting? not working is a pretty wide net to cast.

    do you get an error stating the database needs to be set to trustworthy?

    is the new server...

    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, 2014 at 8:08 am

    #1747482

Viewing 15 posts - 2,191 through 2,205 (of 13,460 total)