Viewing 7 posts - 1 through 7 (of 7 total)
Very good question
If you change the line:
DECLARE #test TABLE (id int, pname varchar(100))
to
create table #test (id int, pname varchar(100))
it will return zero rows - which was what...
July 29, 2009 at 5:25 am
Pablo (2/18/2008)
The Answer is correct, Grant is a DCL Statement:
It is not wise just to trust these sites - they are writting by other people like you and...
March 5, 2008 at 8:12 am
GilaMonster (3/4/2008)
Varchar(max) is a blob data type and is the replacement for TEXT. Only really to be used if you expect the string length to exceed 8000 characters.
Not entirely correct...
March 5, 2008 at 6:31 am
Yulia Golod (3/4/2008)
Actually, one of the answers "management studio" is correct.You can construct MDX graphically in Sql management studio while connected to Analysis Services
Yes, you can construct MDX graphically when...
March 5, 2008 at 1:03 am
I agree - the SSAS is a service and has no GUI - I instantly thought that it had to be Management Studio but I wasn't really aware that I...
February 26, 2008 at 6:49 am
"Microsoft SQL Server 2005 Integration Services" by Kirk Haselden.
Kirk is the Development Manager of Integration Services so I would believe that he know anything worth knowing about SSIS. It's an...
December 3, 2007 at 2:36 pm
happycat59 (10/23/2007)
October 24, 2007 at 5:00 am
Viewing 7 posts - 1 through 7 (of 7 total)