Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 13,460 total)

  • RE: Limit when a trigger runs

    dwilliscp (7/26/2013)

    The where looks at the two columns that make up the PK... You code is more compact though.

    But I am looking for a better way to not run 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!

    July 26, 2013 at 12:09 pm

    #1636273

  • RE: Add one MilliSecond to each row

    As An FYI for datetime, Luis mentioned you can't add a single millisecond; the minimum is 3 milliseconds, and that's imposed due to the way the data is stored by...

    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!

    July 26, 2013 at 10:25 am

    #1636239

  • RE: Oracle Instant Client on SQL 2008 R2 64bit

    Patti Johnson (7/26/2013)

    Thank you Lowell. It looks like you have installed the Oracle full client not the Oracle Instant client. Is that correct?

    Patti yes, that is correct; we...

    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!

    July 26, 2013 at 10:15 am

    #1636232

  • RE: Limit when a trigger runs

    my first thought, is that this trigger is checking things that don't make sense in that WHERE statement, and can be updating rows that it should not.

    of course the [Document]...

    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!

    July 26, 2013 at 9:47 am

    #1636214

  • RE: Limit when a trigger runs

    dwilliscp (7/26/2013)

    Is there any way to limit the trigger, so that it only runs when the app is a .Net SqlClient Data Provider? Or ...not to run if the app...

    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!

    July 26, 2013 at 8:29 am

    #1636183

  • RE: Oracle Instant Client on SQL 2008 R2 64bit

    Patti I hope this helps:

    this is a copy of the definition for scripting my linked server to Oracle; this is working for me, without using a DSN.

    note that if 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!

    July 26, 2013 at 6:55 am

    #1636131

  • RE: Webservice to establish connection with SQL Server

    ok, after modifying the SoapAction to the correct name, i get the xml back of the data table, but the xml doesn't contain the schema,just the data i think,...

    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!

    July 26, 2013 at 6:04 am

    #1636109

  • RE: Webservice to establish connection with SQL Server

    ||edit||: the code below, as long as you have a web server and a valid conneciton to a sql server from that web server works 100%

    I found this interesting when...

    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!

    July 26, 2013 at 5:56 am

    #1636108

  • RE: Unknown Traces - Keep restarting when stopped

    note that the PATH variable is null?

    I'm sure that means because someone is actively using SQL Profiler to run the trace live; Profiler will instantly recreate the trace if 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!

    July 26, 2013 at 5:40 am

    #1636106

  • RE: Find integer at end of a string. There *must* be a better solution ?

    Cadavre I love your new signature with the nolock pointers! just noticed it today.

    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!

    July 26, 2013 at 5:33 am

    #1636103

  • RE: SQL dependency

    at least in SQL2008 and above, for cross database or cross server references, references are at least tracked in the current database, but not enforced of course

    this query has...

    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!

    July 25, 2013 at 2:21 pm

    #1635928

  • RE: Restrinct for insert update and delete from a specific table

    another possibility is to create the user with the "right" limited permissions, with the same password as 'sa' currently;

    that should be easy to do , since everyone is logging in...

    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!

    July 25, 2013 at 2:11 pm

    #1635921

  • RE: Conditional print for testing scripts.

    i believe that's because , according to SQL rules, you cannot create a parameter from appended objects. you can assign it, or build it before hand, but noty inline

    declare @param...

    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!

    July 25, 2013 at 9:54 am

    #1635803

  • RE: Find integer at end of a string. There *must* be a better solution ?

    Eugene Elutin (7/25/2013)

    Lowell (7/25/2013)

    doh!, if it ends in [0-9] might be even easier?

    SELECT *,

    CASE

    WHEN x LIKE '%[0-9]'

    THEN 1

    ...

    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!

    July 25, 2013 at 9:39 am

    #1635792

  • RE: Find integer at end of a string. There *must* be a better solution ?

    doh!, if it ends in [0-9] might be even easier?

    SELECT *,

    CASE

    WHEN x LIKE '%[0-9]'

    THEN 1

    ELSE...

    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!

    July 25, 2013 at 8:06 am

    #1635725

Viewing 15 posts - 3,046 through 3,060 (of 13,460 total)