Viewing 15 posts - 61 through 75 (of 78 total)
Verify if the field that is trucated in Access is not defined as Varchar(Max) or NVarchar(Max) in the database. In such cases, Access incorrectly converts the column defined with (Max)...
December 7, 2009 at 1:55 am
This is a great idea, and I would like to see (and use) such an utility too !
November 19, 2009 at 7:36 am
In Access, write your query like this:
SELECT [Field1] & [Field2] & [Field3] AS Result FROM [Table]
Have a nice day!
October 28, 2009 at 5:08 am
Moreover, the only accepted date format in JET SQL is the American date format, whatever the regional settings of the control pannel can be, so: #01/21/2009#
Have a nice day!
October 14, 2009 at 4:00 am
regsvr32 sqlncli.dll /d/i
You might have to provide the path to the dll (usually c:\windows\system32\sqlncli.dll).
Have a nice day!
October 6, 2009 at 6:19 am
I apologize if I was a bit rough. My intention was not to insult anybody but this was the un-elaborate expression of my thoughts. Many DBA people seem to live...
September 10, 2009 at 5:03 pm
Having said that you should bear in mind that the SQL server is going to be a lot better at that number crunching than Access
This is one of the...
September 10, 2009 at 1:57 pm
Personally I would practise and teach ikebana. Not sure I would earn enough from it to live decently, though! 😉
Have a nice day!
September 9, 2009 at 10:43 am
Grant Fritchey (7/14/2009)
July 15, 2009 at 10:53 am
Lynn,
I never said it was an answer you see all the time. I just replied to the question "What's the worst SQL Server advice you see regularly", and believe me...
July 12, 2009 at 3:22 pm
Maybe I should precise that I never intended to promote or even condone the use of cursors. I know that cursors are not efficient tools in MS SQL Server (to...
July 12, 2009 at 1:26 pm
Answering "never, ever use a cursor" or something equally smart.
The poster did not ask for a personal opinion about cursors (even if it's a wise one), he asked for help...
July 11, 2009 at 4:03 am
If your queries do not rely too heavily on functions that are available in Access but not in T-SQL, you should consider porting those queries to the server, as stored...
March 20, 2009 at 5:59 am
Why don't you want to write the CREATE TABLE script?
If I understand what you wrote correctly:
1) You don't want to write a script.
2) You don't want to use the wizard...
March 20, 2009 at 2:56 am
Hi!
As you describe it, I would not call wireless networking an improvement.
Move my laptop from the bedroom to the basement, to the kitchen or when playing with kids... looks...
March 20, 2009 at 2:41 am
Viewing 15 posts - 61 through 75 (of 78 total)