User Profile

Collapse

Profile Sidebar

Collapse
arbcoll
arbcoll
Last Activity: Jul 24 '08, 08:48 AM
Joined: Jul 24 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • arbcoll
    replied to Stored Procedure to reliably update two tables.
    in SQL Server
    After each insert you got IF clause:

    if (@SlotsBalance> 0)
    if (@TableBalance> 0)

    etc...

    I couldn't get the idea behind these?
    See more | Go to post

      Leave a comment:

    • arbcoll
      replied to Return result of dynamic query from function
      in SQL Server
      Hi pal,
      I believe till now you have learned much about SQL, and you already know now that the code provided here is whole wrong.
      Here are some tips about it:
      1. Functions can return only scalar values, or tables
      2. Dynamic Queries cannot be used in functions. Use Stored Procs if you need them.
      3. Variable assigning is done via (simpliest) SET command in SQL
      4. When using text strings, always put them inside single cuotes (')
      ...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...