Forum Replies Created

Viewing 15 posts - 3,781 through 3,795 (of 13,460 total)

  • RE: How to copy All data from sp_helpdb to some other table

    Sp_help returns multiple data sets with different numbers of columnz. It also returns different results depending on the parameters and the object you are testint... a table returns diilfferent 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!

    March 30, 2013 at 4:09 am

    #1602238

  • RE: i need the max length value of every column in every table in a database

    something like this? also, max_length only makes sense for char types, so you mean like varchar/nvarchars right?

    SELECT

    OBJECT_NAME(OBJECT_ID) AS tablename,

    name AS colName,

    TYPE_NAME(system_type_id),

    CASE...

    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!

    March 29, 2013 at 2:57 pm

    #1602162

  • RE: How to preserve global temporary table data

    rajarshi_ghosh_05 (3/29/2013)

    The highest time to keep the table alive is 120min.

    Is it possible to keep the table alive by locking it or anything else?

    again, no, it is not possible...

    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!

    March 29, 2013 at 2:01 pm

    #1602152

  • RE: How to preserve global temporary table data

    the only sure fire way to keep the keep that global temp table around is by having the process which created the temp table keep it's connection open. that...

    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!

    March 29, 2013 at 1:41 pm

    #1602144

  • RE: harnessing sp_msforeachdb to return one result set

    create a temp table, and instead of SELECTING, do INSERT INTO...SELECT:

    CREATE TABLE [dbo].[#TMP] (

    [DBNAME] NVARCHAR(256) ...

    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!

    March 29, 2013 at 1:25 pm

    #1602136

  • RE: How to preserve global temporary table data

    even global temp tables get dropped if all the sessions that referenced it disconnect, i believe.

    you'd need to start adding logic to create if not exists to your process, if...

    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!

    March 29, 2013 at 1:11 pm

    #1602132

  • RE: Parse CC in String

    Laura i think it would be easier to delete dashes, and maybe also spaces from the string, and then look for 16 [0-9] digits in a row in 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!

    March 29, 2013 at 12:59 pm

    #1602129

  • RE: Check Constraint Question - Situations Where a Child Record Should Be Limited to One Occurrance

    yes, you can make a check constraint that uses a user defined function.

    something like this is untested, but kind of gives you an idea of how it would work

    create function...

    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!

    March 29, 2013 at 12:06 pm

    #1602116

  • RE: Alter Column with Identity

    note: two year old thread.

    the answer is right here, so re-read the whole thread, and use the GUI instead;

    your error is mentioned in my post above:

    --fails: not allowed to alter...

    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!

    March 29, 2013 at 11:06 am

    #1602101

  • RE: club to columns into one

    no rules for what it is you want to do?

    my wild guess is you want to split Task by word, but no explanation ont he numbering scheme.

    With MySampleData ([Proc],Seq,Type,Task)

    AS

    (

    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!

    March 29, 2013 at 9:31 am

    #1602064

  • RE: "ORA-04091" Mutating Error

    i believe the mutating issue is when you try to update from anything other than the old; or new:

    you want to avoid that.

    it's not clear what you are trying 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!

    March 29, 2013 at 9:13 am

    #1602055

  • RE: addinga Func to an SP?

    Joe you'll most likely use a procedure like this, this is just a model, but you can see how the proc might use CROSS APPLY (or a left join? it's...

    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!

    March 29, 2013 at 7:50 am

    #1602022

  • RE: ER diagram and related query!

    look at the ER diagram i think you posted. the Meters table doesn't have that column, so you cannot try to join it in your query like that;

    the error here...

    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!

    March 29, 2013 at 7:28 am

    #1602009

  • RE: sql2008 port number changed

    you are very, very sparse on the details.

    is there more than one instance of SQL on the machine, and that is why you changed the port number?

    why did you change...

    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!

    March 29, 2013 at 7:05 am

    #1602000

  • RE: sql2008 port number changed

    if SQL browser is not running, are you explicitly adding the port to your connection? how are you connecting locally?

    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!

    March 29, 2013 at 6:45 am

    #1601990

Viewing 15 posts - 3,781 through 3,795 (of 13,460 total)