|
2d
|
|
asked | c# serialization - complex type containing simple content with attributes |
|
May
21 |
|
awarded | Supporter |
|
May
17 |
|
comment |
Varchar to Numeric conversion error If your datatypes are decimal, why the string comparisons? There will be an implicit cast on the string types to do the comparison. |
|
May
16 |
|
comment |
Execute stored procedure programmatically inside recursive CTE instead of Cursor I would note that comments on the question above are probably valid. There may be a quicker way to do this using set based operations depending on what is inside your stored procedure (i.e. not calling it multiple times, but writing a new one instead), but can't tell from the outside. |
|
May
16 |
|
comment |
Execute stored procedure programmatically inside recursive CTE instead of Cursor You'll need to update the code that sets the DayOfWeek variable to suit - a case statement probably best. I just didn't fancy typing it all in here - it just stops you having to repeat the code to call the sproc. |
|
May
16 |
|
answered | Execute stored procedure programmatically inside recursive CTE instead of Cursor |
|
May
16 |
|
answered | Sql server can't select from tables from time to time |
|
May
15 |
|
comment |
is there any linqish way to save user form data - Re factoring my code I guess my question is then why the isnullorempty checks - they don't seem necessary to me? If you take them out, then that's your update code implemented... |
|
May
15 |
|
comment |
is there any linqish way to save user form data - Re factoring my code With your code, what happens if the user actually wants to remove the address line 2, for example? |
|
May
13 |
|
comment |
does sql automatically kill sleep processes or not?can i stop this action? This is not a very good way of doing it. |
|
May
11 |
|
comment |
C# interfaces - What's the point? Isn't it annoying when you find an answer that was trying to say what you were, but does it a lot better - stackoverflow.com/a/93998/117215 |
|
May
11 |
|
answered | C# interfaces - What's the point? |
|
May
11 |
|
comment |
does sql automatically kill sleep processes or not?can i stop this action? Honestly, I cannot think of a good reason for this. If you have a requirement for this, there's probably something else wrong. If you can elaborate on your requirements in the question, we may be able to help. |
|
May
11 |
|
comment |
Single sql transaction on mutiple method As a side note - you need to look in the code in your methods to see if this is suitable, and to ensure you keep the transaction in the database and not have it escalated to a distributed transaction! |
|
May
11 |
|
answered | Single sql transaction on mutiple method |
|
May
11 |
|
revised |
What does this weird javascript code do? added 66 characters in body |
|
May
11 |
|
answered | What does this weird javascript code do? |
|
May
11 |
|
revised |
does sql automatically kill sleep processes or not?can i stop this action? added 303 characters in body |
|
May
11 |
|
comment |
does sql automatically kill sleep processes or not?can i stop this action? Also, this should be an edit or a comment on your original question, not an answer. |
|
May
11 |
|
comment |
does sql automatically kill sleep processes or not?can i stop this action? Why not? If it's not doing anything why not recycle it? |
