Viewing 15 posts - 31 through 45 (of 51 total)
Hari.Sharma (7/15/2008)
As simple as it is:-- Query
USE [MyDataBase]
GO
TableName -- Bold shows that it is selected
-- Now Press Alt+F1
I think it is very easy and self explanatory.
See the attachment
Tried...
July 15, 2008 at 5:48 am
Hari.Sharma (7/14/2008)
Did you really try this?
Just select a table name and press Alt+F1 and see the result...
Just select a table name and press Alt+F1, is that all I have to...
July 15, 2008 at 2:08 am
kevriley (7/1/2008)
From the same link
SYSTEM specifies an ANSI SQL implementation-dependent sampling method. Specifying SYSTEM is optional, but this option is the only...
July 1, 2008 at 4:13 am
I got this right, but the explanation, to me, doesn't really sound right:
"TABLESAMPLE returns an approximate percentage of rows, even if a number of rows is specified. This is used...
July 1, 2008 at 2:48 am
No matter, fixed it. It was returning no records as I was checking that the WBSSubsetID didn't equal in the not exists, whereas I should of been checking they...
June 25, 2008 at 2:29 am
Thanks.
I have tried doing that, but at the moment it doesn't return any records. Here is what I have now:
SELECT dbo.vWBSAvailable.WBSSubsetID, dbo.vWBSAvailable.[Change : WBS : WBSSubset]
FROM dbo.vWBSAvailable
WHERE dbo.vWBSAvailable.ProjectID =...
June 25, 2008 at 2:18 am
majorbloodnock (6/24/2008)
June 24, 2008 at 6:27 am
William Strutts (6/23/2008)
June 23, 2008 at 8:52 am
Thanks, that solved it.
Andrew
June 23, 2008 at 8:19 am
I to got the question "wrong". What I want to know is, when someone puts up a QoD, is there any sort of checking involved by the mods/admins, or...
June 23, 2008 at 4:55 am
That is sort of what I had before. The problem is that, it works when the text box is blank. But, if I want to add to the...
June 20, 2008 at 3:13 am
You say you want to update Status = 1 if username exists. On your update statement, are you doing that right as I would of thought you would do...
June 20, 2008 at 2:55 am
I solved the other error as well. I put brackets around the select from where statement, and I also missed out the group by which I put in. ...
June 19, 2008 at 5:02 am
I solved the "Incorrect syntax near the keyword 'from'." error, I had missed of the word 'end' at the end of the set @UAP = ... line.
I need help with...
June 19, 2008 at 4:47 am
Viewing 15 posts - 31 through 45 (of 51 total)