Question When saving a number with leading zeros into a string variable or column, leading zeros are truncated. When I run this query: The result I get is 11. Is there any way to get 011? asked 2021-05-17 by sandhun p.s Answer In your code … [Read More]
Question I have 2 tables(source and destination) which are respectively NOR_LABOR and ALL_LABOR_DETAILS. In the source table(NOR_LABOR) there is a column feet_produced with the data type nchar(10). In the destination table(ALL_LABOR_DETAILS) there’s a column labor_feet_produced with the data type decimal(18,4). I want to convert the … [Read More]
Question Is there a way to view and copy the code that the "Import Flat File to SQL" Wizard ultimately uses, after I have gone through all the steps (chosen file, set up data types for my columns, etc.)? While using the Import Flat File … [Read More]
Question we use the SqlTransaction-class in the backend to access data stored in the MS-SQLServer. In some cases we definitely know that no data were changed by this transaction (and no errors occurred). So the question is: How to close transactions in these cases? Shall … [Read More]
Copyright © 2024 | Andy Mallon | am2.co