SQL Server – error when creating stored procedure

by 

declare @Colcunt int;
Select @Colcunt  = count(*) 
from tbl_Calibration_Transaction 
where CardId = @CardId and ScalingMachine= @ScalingMachine 

IF (@Colcunt = 0 ) BEGIN INSERT INTO tbl_Calibration_Transaction ...

More Related Contents:

  1. Turning a Comma Separated string into individual rows
  2. Update a table using JOIN in SQL Server?
  3. Calculate running total / running balance
  4. When should I use semicolons in SQL Server?
  5. How to get Time from DateTime format in SQL?
  6. Parse JSON in TSQL
  7. Get size of all tables in database
  8. Fuzzy matching using T-SQL
  9. List of all index & index columns in SQL Server DB
  10. Why use a READ UNCOMMITTED isolation level?
  11. Replace duplicate spaces with a single space in T-SQL
  12. How much size “Null” value takes in SQL Server
  13. SQL Server: Isolation level leaks across pooled connections
  14. How do I use the CONCAT function in SQL Server 2008 R2?
  15. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  16. How do I exclude Weekend days in a SQL Server query?
  17. EXEC sp_executesql with multiple parameters
  18. Preserving ORDER BY in SELECT INTO
  19. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  20. Can you call a webservice from TSQL code?
  21. How to add custom attributes to SQL connection string?
  22. Multiple Column Pivot in T-SQL
  23. Joining multiple tables returns NULL value
  24. Which join syntax is better?
  25. Compute MD5 hash of a UTF8 string
  26. LPAD in SQL Server 2008
  27. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  28. How do I remove non-breaking spaces from a column in SQL server?
  29. Is there an “IF EXISTS” test for a linked server?
  30. SQL Server stored procedure return code oddity

Leave a Comment