Viewing 15 posts - 166 through 180 (of 630 total)
In T-SQL the connection is handled entirely by the Query window you open. Unless you specify a database name in the Query then you can run the query against either...
April 14, 2011 at 8:31 am
I think it might be getting confused try adding an alias for the tables like so.
select COUNT (empl.employee_no) as 'Number of Employees in Section',dep.Department_Name
from Employees empl
INNER JOIN
Departments dep
on dep.Department_No=empl.Department_No
having
COUNT(*)...
April 14, 2011 at 7:17 am
I don't know so much as information to provide as much as things to consider. What else is running on the server? Who is connected to the server?...
April 13, 2011 at 2:38 pm
Thank you Michael. This is one of my must have scripts for a DBA toolbox very well done.
April 13, 2011 at 1:58 pm
Llike other languages you can not bypass a compile error with a catch block. Since the insert does not match the table definition this is generating a compile error...
April 13, 2011 at 12:59 pm
I did not write this but here is a little script I picked up a while back that I use. It provides some pretty useful information. I would give...
April 13, 2011 at 12:44 pm
Grant Fritchey (4/13/2011)
ChrisM@home (4/13/2011)
CirquedeSQLeil (4/13/2011)
Grant Fritchey (4/13/2011)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.*cough*
That should help.
Don't you have to...
April 13, 2011 at 12:17 pm
A little link to lead you in the right path.
April 13, 2011 at 12:16 pm
Daniel Bowlin (4/13/2011)
crookj (4/13/2011)
sing4you (4/13/2011)
crookj (4/13/2011)
Speeking of older music....Anyone remember Harpers Bizarre?
Joe
I do sort of remember them. What were their hits?
Pocket full of miracles, anything goes, and Feeling Groovy...
April 13, 2011 at 11:54 am
Seeing as how in the grand state of IL I have an extremly low chance of actually encountering one I can say I have never given thought to weather I...
April 13, 2011 at 9:54 am
We you setup the connection in the package if you specify widows autentication then know. The person using the package or again the Agent account if you are running...
April 13, 2011 at 9:31 am
I could be horribly wrong as I have not done extensive research on GUID's but I do not beleive that would be the case. The GUID is generated per...
April 12, 2011 at 2:45 pm
I do not beleive that would show what you are looking for. Even if the child record existed in table 2 I would not expect to find a relationship in...
April 12, 2011 at 2:35 pm
When I create a database I am always logged in as my Windows Authenticated logic which places me as part of the SysAdmin group.
April 12, 2011 at 2:11 pm
Viewing 15 posts - 166 through 180 (of 630 total)