Search:

Type: Posts; User: GaryMazzone

Page 1 of 13 1 2 3 4

Search: Search took 0.88 seconds.

  1. Replies
    28
    Views
    2,725

    Re: ADO on Sql Server not working

    Remember this saying... You can't make it idiot proof because someone will make a better idiot
  2. Replies
    28
    Views
    2,725

    Re: ADO on Sql Server not working

    Username should be unique not password
  3. VS 2019 Re: Windows service connect to SQL server error

    @tg if the user is marked as sysadmin (sa) they get access to all databases no need to add to each DB. I would not put empty string for initial catalog. But something (master,msdb... but something)
  4. Re: how to Retrieve Data from Access Database and represent them in a text box?

    I prefer Tilt your monitor to the right.... apparently all the screen fonts and forms are falling off the left side of the monitor
  5. Re: [RESOLVED] IDENTITY_INSERT problem using Sql Server

    I run this is SSMS (or an app I wrote):


    SELECT
    COLUMN_NAME AS [Field Name] ,
    DATA_TYPE AS [Data Type] ,
    Case DATA_TYPE
    WHEN 'char' THEN CASE...
  6. Replies
    4
    Views
    829

    Re: Index on NULL + data

    The question should be how unique will the values be? Will you be searching more often for a NULL or the not NULL values. A filtered index would should be you best choice, actually 2 of them one...
  7. Replies
    20
    Views
    2,218

    Re: Add --SELECT--

    It's a There will always be a better IDIOT
  8. Re: Double click .SQL file open in extant instance in SSMS

    I usually just drag and drop it into SSMS
  9. Re: I did not know that SQL had a NUL: "disk device"

    Sorry but when consulting I always point out problems with the way a company is handling backups. Everything from not doing proper T-Log backups to relying on something like comvalt (pauses IO on...
  10. Replies
    18
    Views
    2,088

    Re: Mostly Merging Multiple Tables

    My complaint on merge statement is purely performance related... It is horrible when ever I used it
  11. Replies
    10
    Views
    1,661

    Re: Management of sql server using vb6

    Learn documentation then ask questions:

    https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15
    ...
  12. Replies
    21
    Views
    5,703

    Re: [RESOLVED] SQL - Basic math issue

    In 2 seconds can be bad..... I have to return results in less that 2 seconds with internal time (time spent in our DB) should be under 500 ms. We are in the Credit card processing area
  13. Replies
    3
    Views
    4,459

    Re: Inserting too many records at once

    In typical DBA fashion .... It depends....
    By that I mean is the data type small? Not a problem (probably) Is it large batches of text, A problem .... the problem will be in the transaction logs...
  14. VS 2019 Re: VB.NET SQL statement to amalgamate four columns from joining two tables into two.

    If the fields are the same type have you considered using a UNION query:



    PSQL = "SELECT [Desc] As Field1, Price as Field2 FROM LineEntry WHERE Desc LIKE '" & mCelContent & "%' ORDER BY [Desc]...
  15. Replies
    7
    Views
    5,531

    Re: Information on a Dropped...Something

    Do you have transaction logs for the database? If in full recovery you could use SQL tools to look though them. The default trace might have something if it was not done long ago
  16. Re: Pass a list of integers to stored procedure and perform insert on each

    This works for 2012 or 2014 (and 2008,2008Rs, 2005)


    CREATE FUNCTION usp_fnsplit (
    @inputVals VARCHAR(MAX),
    @delimiter CHAR(1)
    )
    RETURNS @output TABLE (splitval VARCHAR(MAX))
    BEGIN...
  17. Re: Advantages of grouping everything in EXE

    How I see development going most of the time (I still see this now)

    User: Bring me a rock
    Developer: OK here is a rock
    User: Yes it is a rock but just not the rock I was looking for. Bring me...
  18. Re: work on SQL Server database without SQL Server installed

    Powershell will work also
  19. Re: What would syntax of this be in C# code?

    I would do a Cast(RecieveDate AS DATE) No need to convert to string
  20. Replies
    7
    Views
    1,582

    Re: BLOBS in Database: Good or Bad practice?

    One other thing to remember in SQL Server blob storage is not in line (meaning not on the row) so it required extra IO anyway.
  21. Re: Security Question: MS SQL direct access using windows authentication

    You need a column added to the table along with the function. Each user would need something.... i.e. the app can still be the .Net user but a user needs to log in with their own credentials. Those...
  22. Re: Security Question: MS SQL direct access using windows authentication

    As I said that is possible using Row-Level security in SQL Server 2016 and up. You write a function that is used when you access a table that basically adds a where clause to you query. You can see...
  23. Replies
    53
    Views
    8,785

    Re: Unable to Access MySQL Remotely

    Did you check the users table in MySQL? There is a host column is that location in that column for that user? You can use % in the host column also (that would mean anywhere)
  24. Re: Which SQL Version should my scripts be for client machines

    There is no SQL Server Version 18.9.1 that is an SSMS version and has nothing to do with the SQL Server version.
  25. Re: Security Question: MS SQL direct access using windows authentication

    It is on the row. the function acts like part of the where clause (automatically added) . It is a bit of a pain to setup especially if the tables already exist and you are trying to add it to...
  26. Re: Security Question: MS SQL direct access using windows authentication

    There is row level security in SQL Server (from 2016 on). It requires functions created and using those function on a call to the select statement. If the function says you have access you see the...
  27. Re: Any troubleshooting ideas to solve CR causing VS crash?

    When I was developing CR reports for use in VB (or .Net) I always developed them in CR and just used them in the app.
  28. Re: Any troubleshooting ideas to solve CR causing VS crash?

    I believe it formats to the default/ selected printer
  29. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    I have no idea why yours run slowly I can do that over tables with 10,000,000 rows and get good speed.... If you are running MS Access that is not the fastest database there is. The second one down...
  30. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    Another way



    INSERT INTO TABLE1 (field1,field2,field3)
    SELECT
    t2.field1
    ,t2.field2
    ,t2.field3
    FROM table2 t2
  31. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    If a record exists in table 2 and not in table 1 there is no way to update table 1 it is not there..... If it exists in both table 2 and table 1 then you can update. If it exists in table 1 and not...
  32. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    We will need more info than you have supplied here... What is the database? Where do the tables exist? Does your DB support the MERGE statement? As say more info
  33. Re: How do we change our update statment? we want to add rows from NEWschoolmark tabl

    You can't update rows that do not exsist in the table already....
    You need to do an insert to the table where not already in place...
  34. Replies
    6
    Views
    3,149

    Re: MSSQL Login for Stored Procedure

    You create the SQL login. You grant connect to the database you want then only grant execute on the stored procedure you want that login to be able to execute..... If it is all SPs in the DB you can...
  35. Replies
    6
    Views
    3,149

    Re: MSSQL Login for Stored Procedure

    I would just grant execute on the procedures to the user you want.
  36. Replies
    12
    Views
    4,374

    VS 2019 Re: error sql query too complex

    I would use a BETWEEN clause ( WHERE ID BETWEEN (X and Y) )
  37. Re: Allow users to build WHERE clauses

    We also include a parameter value for AND name @OR as a BIT is it is 1 then we set all parameters to OR if 0 set to AND
  38. Re: Allow users to build WHERE clauses

    We do that in our app... unfortunately we need to use dynamic SQL to build it. There are a lot of parameters that we pass into the SP (they can be null). The front end allows the user to select...
  39. Replies
    10
    Views
    1,982

    Re: Delete all records in a table

    Truncate table should work with most DB systems that follow the ansi standard.
  40. Replies
    10
    Views
    1,982

    Re: Delete all records in a table

    Zvoni DON"T do DROP and CREATE for the table the better option would be (if not the Parent table in a FK relationship) to use TRUNCATE TABLE schema.tableName. this will also reset identities to 0...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width