SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Column encryption

  Hi Experts , we want to encrypt sensitive information like ssn ,tax_id ,  phone no and address we a…

  arvind.patil 98284

  3 replies

  5 years, 5 months ago

  By: Scott Arendt

• Constraint in a column

  Hi, I have a requirement where my table (ex: TableA having columns Tranno , Trandate, Itemno). Tran…

  haichells

  4 replies

  5 years, 5 months ago

  By: jcelko212 32090

• find and replace text in sproc

  I need to find all sprocs having a misspelled word and dynamically correct. Googled and found a sol…

  polkadot

  13 replies

  5 years, 5 months ago

  By: elric.sims

• ORDER BY in the OVER clause

  I am using the AVG( ) with the OVER clause and within the OVER clause I have a question about ORDER…

  michael.leach2015

  8 replies

  5 years, 5 months ago

  By: michael.leach2015

• T-SQL: Pulling Different Data from the Same Table

  Hi: The results of the first code below are attached as the file called "Results". Likewise, the re…

  John Roy Ellis

  1 replies

  5 years, 5 months ago

  By: John Roy Ellis

• NVarchar field sizes

  Hi, In my database I have a table with product information.  The number of records in the table var…

  ErwinB

  5 replies

  5 years, 5 months ago

  By: John Mitchell-245523

• Collapse record and get the number of days

  here is my data. I am trying to get the dates in single row like below. Any help appreciated. resu…

  Angela4eva

  4 replies

  5 years, 5 months ago

  By: jcelko212 32090

• using OleDbConnection can we connect to both sqlserver and mdb

  Hi All, In administrative Tools ODBC Data Sources (64-bit) configuration ,Please find the attached …

  sampathmeka

  1 replies

  5 years, 5 months ago

  By: sampathmeka

• Conversion failed when converting the varchar value ' ' to data type int

  Hello, What I am trying to do is to replace the null values that I initially populated my table wit…

  Edward Chau

  5 replies

  5 years, 5 months ago

  By: John Mitchell-245523

• Count the number of Code Types with a Subquery

  I need help with a query to select against the following table: CREATE TABLE dbo.Claims ( [Organiz…

  netguykb

  3 replies

  5 years, 5 months ago

  By: Jeffrey Williams

• Use the results from a Substring in a Left Join

  Hey Folks, did. a little digging around however I was not able to find a simple solution for this. …

  netguykb

  2 replies

  5 years, 5 months ago

  By: Ken McKelvey

• Script Task Fails due to BulkCopy in SSIS

    Hi All, I found a script task code and used it however i am a novice on it. I know the bulkc…

  prince_esemiteye

  1 replies

  5 years, 5 months ago

  By: Jeffrey Williams

• Real columns are comma separated instead of dot separated ?

  Hi, installed a new SQL Server Express 2019 and somehow my real columns are now with comma instead …

  gormus

  12 replies

  5 years, 5 months ago

  By: Jeffrey Williams

• Slow Query when add 1 additional field

  dear all, i have simple query that related several tables which 1 table have millions of rows. i ha…

  detanto

  6 replies

  5 years, 5 months ago

  By: detanto

• How to compare two rows in same table

  Actually i was able to compare two rows in same table after inner joining them from multiple tables…

  ranadas

  1 replies

  5 years, 5 months ago

  By: nick.hinton