Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 13,460 total)

  • RE: how to insert image in sql server 2005

    Sanjay openrowset does not allow variables...it must be a static string inside single quotes. Replace @image with 'c:/filename'

    You could build an openrowset as a string and use dynamic sql instead

    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 11, 2012 at 4:45 am

    #1557948

  • RE: Dropping constraints

    instead of dropping and recreating, it would be much faster and easier to generate code to simply rename the existing constraints.

    this is what i would do:

    /*

    EXEC sp_rename 'DF__SFHEAD__MSLOAN__51278362','DF__SFHEAD_MSLOAN'

    EXEC sp_rename 'DF__SFHEAD__URUSEAMT__2D8A0CC1','DF__SFHEAD_URUSEAMT'

    EXEC...

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

    #1557681

  • RE: script for setting min and max memory of sql server

    ok clue me in, because i'm not seeing it...

    what difference does it make on # of logical cores?

    why not calculate, say 7/8ths of the total available memory for the SQL...

    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 9, 2012 at 6:22 am

    #1557585

  • RE: Static values for a table that currently doesn't have that value.

    here's an example that kind of shows what we are talking about...you have to select from all possible values, and join that to what was sold.

    run this and take a...

    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 8, 2012 at 2:32 pm

    #1557362

  • RE: need to track user

    yogi123 (11/8/2012)

    Hello

    in one table, i need to find from which sql account, table got insert , update and delete.

    so please help me, how i track this

    Thanks

    Unless you've already setup a...

    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 8, 2012 at 12:13 pm

    #1557326

  • RE: Call a URL and pass a parameter in the URL (http post)

    Received an pm asking for more details on the programming portion of this, as CLR can be a bit scary the first time around.

    hopefully, this can get someone started, but...

    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 8, 2012 at 12:08 pm

    #1557325

  • RE: Find where Database uses CLR

    these two queries seem to return all the objects and all the assemblies:

    EXEC sp_MSforeachdb 'SELECT ''?'' As DBName,

    ...

    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 8, 2012 at 10:14 am

    #1557272

  • RE: Call a URL and pass a parameter in the URL (http post)

    oh yeah!!!

    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 8, 2012 at 9:23 am

    #1557244

  • RE: Call a URL and pass a parameter in the URL (http post)

    I'd do exactly what Sean is recommending...I'd have a service slam the web site and store the results in a table, all outside of TSQL.

    Now, having said that, just 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!

    November 8, 2012 at 8:08 am

    #1557199

  • RE: Howto udpdate text using Replace html font in textfield

    here's a TSQL method, which generates the actual REPLACE statements you would want to use to remove the css style assignment, if it exists.

    Notice how i'm generating a lsit 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!

    November 8, 2012 at 6:02 am

    #1557137

  • RE: Clearing out msdb.dbo.sysmail_mailitems...

    Markus (11/8/2012)

    There are several reasons for it. Typically the rows that are active are at the end of the file so it isn't shrinking. Rebuilding indexes 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!

    November 8, 2012 at 5:45 am

    #1557133

  • RE: trying to insert using sql

    you know your data better than use;

    this query seems to be what you were trying to insert.

    does the sELECT return teh expected values? if the PatientId = Key, and 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!

    November 7, 2012 at 2:25 pm

    #1556941

  • RE: trying to insert using sql

    Edit!!

    Snippy Snippy Double Dippy!

    i double psoted somehow sorry.

    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 7, 2012 at 2:24 pm

    #1556940

  • RE: Query Help

    you can use a standard integer identity, and then simply format the number with preceeding zeros whenever you are displaying it. there's no need to store preceeding zeros...that's just a...

    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 7, 2012 at 6:28 am

    #1556747

  • RE: SSRS 2008 R2 ERD?

    there sure is...

    on the same page you posted, there's a drop down menu for Otehr versions...R2 was the sole selection, which redirects you to here:

    http://msdn.microsoft.com/en-us/library/bb677408(v=sql.105).aspx

    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 6, 2012 at 9:29 am

    #1556517

Viewing 15 posts - 4,426 through 4,440 (of 13,460 total)