Stack Exchange

Question I came across some weird behavior: While passing a float value into a varchar column, the values are getting converted from integers into scientific notation, and it’s that scientific notation that gets stored as a string. results look like this: 1.49559e+006 Scientific notation stored … [Read More]

Question I have been using linked server with the old provider (SQLNCLI) without any issue, as recommended by Microsoft, I’m planning to switch to new provider (MSOLEDBSQL). I’m able to add linked server using following T-SQL after installing the drivers Unfortunately, getting following error when … [Read More]

Question Error message: Msg 4145, Level 15, State 1, Procedure usp_BaseScan_CycleCount_Report, Line 16 An expression of non-boolean type specified in a context where a condition is expected, near ‘AND’. Msg 156, Level 15, State 1, Procedure usp_BaseScan_CycleCount_Report, Line 21 Incorrect syntax near the keyword ‘ELSE’. … [Read More]

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 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]

Question I have a stored procedure that begins by declaring a few variables then contains begin tran; After this it performs some validations on the supplied arguments (and increments an error count each time a supplied argument fails validation). If there is no error count … [Read More]

Question Table sysjobschedules contains 2 columns next_run_date and next_run_time. With the help of sysschedules and column enable it should be easy to determine the next running date/time of a specific job. However, when you change a schedule, sysjobschedules is only refreshed 20 minutes after alteration … [Read More]

Question I am trying to figure out the way to monitor these 2 events log send queue size – I can see this in perfmon Redo queue size – I can see in dmv but not in perfmon counter Is there any way of using … [Read More]