Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 13,460 total)

  • RE: Select table names from queries

    Eugene Elutin (8/30/2012)

    Lowell (8/30/2012)

    you could search for words that exist after "FROM" and "JOIN", right? ...

    What about: INSERT, INTO, DELETE, TABLE (in possible truncate, create, alter or drop table statements).

    good...

    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!

    August 30, 2012 at 6:56 am

    #1531848

  • RE: Select table names from queries

    i get very few false positives when i go after my procedure and function definitions using that technique:

    SELECT definition,T1.*,T2.* from sys.sql_modules

    CROSS APPLY dbo.DelimitedSplit8K(definition,' ') T1

    CROSS APPLY dbo.DelimitedSplit8K(definition,' ') T2

    WHERE...

    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!

    August 30, 2012 at 6:32 am

    #1531833

  • RE: Select table names from queries

    you could search for words that exist after "FROM" and "JOIN", right? and that should get the tables, regardless of the prefix?

    I'm playing wiht a splitting with a delimited...

    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!

    August 30, 2012 at 6:27 am

    #1531827

  • RE: Querying EAV data

    can you post some more details? the DDL for the table, a couple of sample rows, and an example of what you have to change wehn you add a new...

    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!

    August 30, 2012 at 6:21 am

    #1531822

  • RE: its ages since i wrote a trigger

    Eric i see just a couple of things i'd change.

    the IF UPDATE(Canc) is misleading...it doesn't test if the column changed...it tests if the column was referenced in the update;

    some...

    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!

    August 30, 2012 at 6:18 am

    #1531820

  • RE: How to write Transpose in Oracle Please Help

    if you google "Oracle UNPIVOT", you should get some examples of this "transpose" thing you are looking for.

    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!

    August 29, 2012 at 2:59 pm

    #1531647

  • RE: SQL Execute Reader Error

    that one is a snippet from a specific report that gets sent as a raw text;

    it's being padded so that in courior font it uses lines up in pretty...

    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!

    August 29, 2012 at 1:51 pm

    #1531631

  • RE: SQL Execute Reader Error

    SQLdr.Read would move the pointer to the next row; my code is very similar to yours, so i think RBarryYoung is right...it seems like you have a boatload of rows?

    ...

    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!

    August 29, 2012 at 1:27 pm

    #1531613

  • RE: Certificate-Signed Stored Procedure: CREATE PROC script doesn't include this

    pretty sure your going to hit the wall trying to script the password;

    ADD SIGNATURE TO OBJECT::[TestSendMail]

    BY CERTIFICATE [DBMailCertificate]

    WITH PASSWORD = '$tr0ngp@$$w0rd';

    i was playing around and came up with 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!

    August 29, 2012 at 12:06 pm

    #1531552

  • RE: Adding Seconds to Time field

    As Lynn was asking, it's a real TIME datatype, you can add values via dateadd.

    /*

    (No column name)(No column name)

    16:40:27.000000016:52:41.0000000

    */

    declare @time time

    SET @time = '16:40:27'

    SELECT @time,DATEADD(ss,734,@time)

    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!

    August 29, 2012 at 11:13 am

    #1531529

  • RE: Stored procedure in a function

    Are you sure about that?

    copy and paste it to SSMS...that stops right away with a syntax check, since the EXEC command cannot exist inside the parameter list.

    H4K (8/29/2012)

    You...

    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!

    August 29, 2012 at 6:49 am

    #1531357

  • RE: How to edit User Defined Type's column datatype

    I just tested this: you must drop all the objects that use the type, drop and recreate teh type, and then create all the objects that used to use 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!

    August 29, 2012 at 5:56 am

    #1531318

  • RE: Can't Restore DB Because of Active Connections

    you want to make sure that YOU are in the database, so that when it is set to single user, YOU are the single user. otherwise, like if you rant...

    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!

    August 28, 2012 at 3:17 pm

    #1531112

  • RE: Query Result in HTML format

    I always break it into peices;

    the Header and Tail are appended to the body;

    then i can test of the Body is an empty string, i can convert it to "No...

    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!

    August 28, 2012 at 12:15 pm

    #1531008

  • RE: explicitly denying user rights

    SQLHeap (8/28/2012)

    We do most of our right granting through AD groups. Can I explicitly restrict or deny access to just read for a single person from a group 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!

    August 28, 2012 at 11:46 am

    #1530991

Viewing 15 posts - 4,831 through 4,845 (of 13,460 total)