Tagged Questions
4
votes
2answers
2k views
"Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio
I have created a table testtable inside the database testbase that have the following structure:
product_no (int, not null)
product_name (varchar(30), not null)
price (money, null)
expire_date (date, ...
2
votes
1answer
136 views
Why evaluates “IS NULL” in SSMS interactive mode to “TRUE” but the same statement being executed in a SP to “FALSE”? [closed]
Given
DECLARE @IN__CUST_NO INT
DECLARE @OUT__USER_ID INT
SET @IN__CUST_NO = 1000006660
CASE 1: IS NULL evaluates TRUE
Since no CUSTOMER_NUMBER with the value of 1000006660 exists in our dummy ...
