Viewing 9 posts - 1 through 9 (of 9 total)
I'd put it through the wizard in MS Access that already does this!
September 17, 2012 at 4:41 am
uh Access linked tables ALWAYS provide sub-standard performance. You should move to Access Data Projects- there are a lot less layers between Access in SQL Server if you use...
July 23, 2012 at 5:38 am
I agree: nchar(1) is the most correct answer IMHO so thats what i chose. I lobby for the answer to be changed.
September 23, 2009 at 10:08 am
good for you, when you make an assumption you make an A$$ out of who and who?
not me-- I choose NCHAR or NVARCHAR, because it's not fair to take...
July 2, 2009 at 12:29 am
it's not a spec-- it's not specified.. I don't know if the creator of this site is in Chicago or Beijing!
Without that critical piece of information 'who is asking me...
June 16, 2009 at 1:57 pm
I agree-- anyone who chose CHAR or VARCHAR is nothing but egocentric.
Yes-- in most situations I choose VarChar (because I know I am in America, and people speak English).. but...
June 15, 2009 at 5:45 pm
I've chosen for nchar(1) because it only says that the value won't be NULL or empty, but there's no limitation on the characters used.
June 11, 2009 at 10:02 am
u might need to enable named pipes in the SSMS config manager, right? off by default, I think
May 8, 2009 at 9:42 am
you actually cannot do this with SQL Server.
Only mySQL supports the limit keyword, like LIMIT 1,2 would show you two records LIMIT 3,4 would show you records 3 and 4.
one...
March 2, 2009 at 9:50 am
Viewing 9 posts - 1 through 9 (of 9 total)