Don't know what kind of crappy code Access is generating for you that is different from your non-junky book, but inner and outer joins, union queries and most sub-queries will be the exactly same as SQL Server. What I would do is build your Access queries from your book examples in "SQL" view. It's possible […]
2005-04-30
thanks, will do.as an aside question, is there away to know what the sa password is? or do i have to use t-sql to hange the password. the problem with that is there are so many applications that were created before i got here, that has the sa password hard-coded. oh and none of the […]
2005-04-18
#temp tables are created in the tempdb and are only available during the current connection. Something like the following would not work:begincreate #tempcommitselect * from #temp From BOL:Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user; and they […]
2005-04-15
did you reload sql databases on new server, meaning having another name?IF so, first check BOL on sp_dropserver and sp_addserver.You can also check msdb..sysjobs table. It keeps some informationabout the server it's running jobs on.hthJP
2005-03-09
Thanks but i know that i want some set like the set quoteidentifier on to avoid the problems between the "" and ' , i need something similar to avoid to use the cast or convert to comparate the varchars and the integers
2005-02-21
I've been interested to read the musings, as I always wondered what it was about open source that got people so excited. Little of value is ever really given away, and it does seem to spawn a myriad of different flavours. At least in the closed source world we have a controlled number of jellies […]
2005-02-04
>> In a stored procedure, I need to be able to run various sets of code based on whether variable1 is passed or variable2 is passed or variable3 is passed or if variable4 is passed (more than one variable will not be passed at one time.) Sounds to me like you should be looking at […]
2005-02-04
Dunno, maybe I missed something....SELECT E.PAYTYPE , SUM(CASE datepart(dw,E.TimeDate) WHEN 2 THEN E.Hours ELSE 0 END) as Monday , SUM(CASE datepart(dw,E.TimeDate) WHEN 3 THEN E.Hours ELSE 0 END) as Tuesday , SUM(CASE datepart(dw,E.TimeDate) WHEN 4 THEN E.Hours ELSE 0 END) as Wednesday , SUM(CASE datepart(dw,E.TimeDate) WHEN 5 THEN E.Hours ELSE 0 END) as Thursday , […]
2005-01-27
getting back to your original question, the way to interrogate objects in AS is through the use of DSO (Decision Support OBjects). This is very easy to do with VB6, slightly harder with VBScript (no object typing ) and OK(ish) with .net (I've used C#) but a little more cumbersome because of the poor object […]
2004-12-07
As has been stated, a plain UNION will eliminate duplicates automatically (a fact which has tripped me up more than once!). The BOL documentation is to my mind a bit poor here - you have the section on the UNION operator in the SELECT topic, then right at the endof the UNION topic it says:ALLIncorporates […]
2004-10-21
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers