Forum Replies Created

Viewing 15 posts - 8,791 through 8,805 (of 13,460 total)

  • RE: Question: float display as character

    Jeff Moden (9/8/2010)

    Will this do?

    SELECT UPPER(CONVERT(VARCHAR(30),@ReturnValue,2))

    [/code]

    I know there is usually a reason behind everything in your posts , Jeff...I love reading your posts specifically because I learn something (and I'm...

    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 9, 2010 at 4:03 am

    #1218468

  • RE: I need script related to databases

    i love logon traces, but for tracking/ accessing specific databases, i don't think it would work;, a logon trigger occurs before a user connects to a database...so in the trigger...

    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 9, 2010 at 3:57 am

    #1218465

  • RE: Send mail to more than 1 mail id through Account

    the parameter @recipients for msdb.dbo.sp_send_dbmail expects a semicolon delimited list of recipients; there's no limit to the # of recipients, since it is a varchar(max) definition;

    so if you are...

    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 9, 2010 at 3:52 am

    #1218464

  • RE: Script Out Database Mail Settings?

    As a solution to my own question, one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not know...

    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 8, 2010 at 7:10 pm

    #1218319

  • RE: Script Out Database Mail Settings?

    yeah, digging for stuff is turning into a pain...

    just going for the account info, for example, the password associated to the username used for SMTP AUTH command appears 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!

    September 8, 2010 at 2:20 pm

    #1218242

  • RE: This is SSC related actually

    it's easy!

    there is a link named "Control Panel" just left of the oh so familiar "Recent Posts"

    click that, and down on the left is a link to "Edit Avatar"

    click 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!

    September 8, 2010 at 12:09 pm

    #1218151

  • RE: Oracle Wrap like utility in MS-SQL

    the example i gave you will work with absolutely any SQL command; try it before you dismiss it.

    Declare @cmds Nvarchar(MAX)

    Declare @obfoo varbinary(MAX)

    Set @cmds = '

    ALTER procedure [dbo].[sp_find]

    @findcolumn varchar(50)

    AS

    BEGIN

    ...

    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 8, 2010 at 10:30 am

    #1218091

  • RE: Oracle Wrap like utility in MS-SQL

    are you sending the actual scripts fo rhte client to run, or an executable which will then execute the script after the client provides connection information to the server?

    you could...

    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 8, 2010 at 6:49 am

    #1217892

  • RE: after insert trigger

    yep, so your WHERE statement would reference the THREE columns that make up your primary key:

    ...WHERE TableName.IdContrato = INSERTED.IdContrato

    AND TableName.EiCanalId = INSERTED.EiCanalId

    ...

    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 7, 2010 at 4:41 pm

    #1217671

  • RE: after insert trigger

    igngua (9/7/2010)

    thanks!!

    im using this one because the other one cant get updated.

    Ive a question if you excuse my 'newbieness', what does 'id' means.

    i had to infer a lot 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!

    September 7, 2010 at 4:23 pm

    #1217667

  • RE: Disabling index by using select query

    if the query has a WHERE statement, you could make the arguments non-SARG-able, and force it to use a table scan, but it would still use an index(probably the clustered...

    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 7, 2010 at 4:18 pm

    #1217664

  • RE: Columns_Updated() in update trigger reverses the bitmask?

    I always felt those two functions should be renamed, as they are really misleading; something like ISREFERENCED would be a much better name

    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 7, 2010 at 4:15 pm

    #1217663

  • RE: Columns_Updated() in update trigger reverses the bitmask?

    I always felt those two functions should be renamed, as they are really misleading; something like ISREFERENCED would be a much better name .

    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 7, 2010 at 4:14 pm

    #1217662

  • RE: Columns_Updated() in update trigger reverses the bitmask?

    At the moment we're using an equality where clause check to determine changes between inserted and deleted which, while functional, is slower.

    i think that's the only way to do...

    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 7, 2010 at 3:57 pm

    #1217658

  • RE: after insert trigger

    Craig Farrell (9/7/2010)

    I think you're looking for something like:

    CREATE TRIGGER tr_test ON dbo.A FOR INSERT AS

    UPDATE inserted

    SET col1 = <value>

    where col1 = 'm'

    UPDATE inserted

    SET col2 = <value2>

    where col2 = 'n'

    END

    can...

    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 7, 2010 at 3:43 pm

    #1217652

Viewing 15 posts - 8,791 through 8,805 (of 13,460 total)