Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 2,648 total)

  • RE: Execute a Stored Procedure against every row insert in Table

    azhar.iqbal499 - Monday, November 5, 2018 4:10 AM

    I have around 200 tables and we have insert in each table with in each...

    November 5, 2018 at 5:44 am

    #2012374

  • RE: view generator

    Why wouldn't you just create synonyms as these view seem to be a select all columns from the tables?

    November 3, 2018 at 8:25 am

    #2012306

  • RE: Re-granting Permissions

    jon.wilson - Wednesday, October 31, 2018 6:50 AM

    I've got a group of developers who insist of dropping a view or sp when...

    November 2, 2018 at 10:23 am

    #2012224

  • RE: Validate multiple fields and return string with erroronous fields

    drew.allen - Thursday, November 1, 2018 12:16 PM

    rjjh78 - Thursday, November 1, 2018 12:05 PM

    November 1, 2018 at 1:36 pm

    #2012104

  • RE: Encrypt and Decrypt password in SQL

    It's not a good idea to pass or return unencrypted passwords from a database function. Someone might intercept the call and read the password. You should only pass, store and...

    October 31, 2018 at 2:56 pm

    #2011963

  • RE: seperate data in 1 row

    SELECT [Person Email_old], T.CleanedPersonEmailold, LEFT(T.CleanedPersonEmailold,CHARINDEX(' ',T.CleanedPersonEmailold)-1) SingleEmail
    FROM Person_oldemail
    CROSS APPLY(VALUES (REPLACE(REPLACE(REPLACE([Person Email_old],CHAR(13),' '),CHAR(10),' '),'"','')+' ')) T(CleanedPersonEmailold)

    October 30, 2018 at 10:52 am

    #2011722

  • RE: Unable to execute SP

    crow1969 - Tuesday, October 30, 2018 10:04 AM

    Check to make sure the user is running the procedure from the correct database context...

    October 30, 2018 at 10:13 am

    #2011716

  • RE: New to SQL Queries - 'Select the values that are possible but not present'

    acarmon02 - Monday, October 29, 2018 8:16 AM