Viewing 15 posts - 15,046 through 15,060 (of 15,381 total)
I am not sure. It would have never occurred to me to use Access to create tables in SQL. Is there a reason you can't use sql to to your...
January 31, 2011 at 2:47 pm
Can you just create an update in sql? You are going to have to create update, insert queries anyway.
January 31, 2011 at 2:43 pm
Adding data is a whole different beast than editing tables. 😉
You should be able to create a stored procedure on the sql side and have Access call it. Was all...
January 31, 2011 at 2:38 pm
Why would you choose to edit a table with Access instead of sql server? There will not be any way to do this from access other than running a sql...
January 31, 2011 at 2:19 pm
I actually don't think either way will make much, if any, difference. You could also write this as isnull(col1, @value) = @value however I don't find this is as easy...
January 25, 2011 at 9:01 am
I also included System, which of course isn't actually a pool it is a type of pool. /sigh
Great question, had to brush on the topic since this is not the...
January 14, 2011 at 8:11 am
Jeff Moden (1/10/2011)
I guess I'd like to know why this has to be in dynamic SQL to begin with.
LOL I was thinking the same thing. Looks like dynamically hard coded...
January 11, 2011 at 8:21 am
The error he is getting is a timeout. His cursor use is making the response so slow that whatever the timeout is in the connection string (or the default) is...
January 11, 2011 at 8:13 am
There are a few things going on here. First your comment about the code being too complicated to be put in asp...you should not have any sql in your application....
January 11, 2011 at 8:06 am
Take a look at the create procedure syntax. I think what you are saying is that you want to prevent most users from seeing the sql of your proc.
January 11, 2011 at 7:30 am
Hugo,
I totally agree. A trigger is really nothing more than an event attached to a table. A before trigger would be much the same thing as a Form_PreLoad event on...
January 10, 2011 at 6:14 pm
Yes you can select a GUID on the sql side of things very easily. Your sql looks like it should be fine. As for the datatype of a GUID in...
January 10, 2011 at 10:23 am
Just do integer division.
col1 = 6, 6/3 = 2
col2 = 5, 5/3 = 1
January 10, 2011 at 10:08 am
Nice straight forward question.
It seems that once again there are people who will complain about the wording of the question no matter how straight forward it is. For those...
January 10, 2011 at 8:44 am
Just simply giving you the solution is not the best approach on two levels. First you aren't learning anything about how to deal with this in the future. Secondly, I...
January 5, 2011 at 4:09 pm
Viewing 15 posts - 15,046 through 15,060 (of 15,381 total)