Viewing 15 posts - 1 through 15 (of 15 total)
dariuslearn (1/16/2015)
Grant Fritchey (1/16/2015)
Check out the lessons at Pluralsight.com. They have some specifically for that test. I'm starting to work on the 70-464 lessons right now.
Thanks I will check it...
January 16, 2015 at 6:46 am
Grant Fritchey (1/16/2015)
Check out the lessons at Pluralsight.com. They have some specifically for that test. I'm starting to work on the 70-464 lessons right now.
Thanks I will check it out.
January 16, 2015 at 6:44 am
Ok i tried to figure this out but can't. I handed in the homework with out answering this problem because I could not figure it. Every method i tried led...
October 24, 2014 at 8:19 am
dariuslearn (10/23/2014)
Luis Cazares (10/23/2014)
When you're sure that you have the correct query, you...
October 23, 2014 at 8:59 pm
Luis Cazares (10/23/2014)
When you're sure that you have the correct query, you can...
October 23, 2014 at 8:58 pm
Luis Cazares (10/23/2014)
You don't need to create a table each time you need to query something. A SELECT will be enough.Check the following articles:
COUNT(): http://msdn.microsoft.com/en-us/library/ms175997.aspx
QUOTENAME(): http://msdn.microsoft.com/en-us/library/ms176114.aspx
Dynamic SQL: http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/
I have no...
October 23, 2014 at 6:35 pm
This is as close as i can get.. 1 i cant figure out how to add "Count of" to the column name so that it would be "count of...
October 23, 2014 at 5:31 pm
dariuslearn (10/23/2014)
USE AP
Declare @MyRowCount int
SELECT Top 1 name
FROM sys.tables
WHERE name not like 'dtproperties' and...
October 23, 2014 at 4:42 pm
Luis Cazares (10/23/2014)
dariuslearn (10/23/2014)
so the table name resulting from the following query should become the column name.
SELECT name
FROM sys.tables
WHERE name = (select Top 1 name from sys.tables)
;
You don't need...
October 23, 2014 at 4:27 pm
USE AP
Declare @MyRowCount int
SELECT Top 1 name
FROM sys.tables
WHERE name not like 'dtproperties' and name not like 'sysdiagrams'
order by name asc
SET @MyRowCount = @@ROWCOUNT
;
October 23, 2014 at 4:25 pm
This is what i have so far.
USE AP
Declare @MyRowCount int
SELECT Top 1 name
FROM sys.tables
WHERE name not like 'dtproperties' and name not like 'sysdiagrams'
order by name asc
SET @MyRowCount = @@ROWCOUNT
;
October 23, 2014 at 4:24 pm
sorry I am having trouble responding to post. This is the code I have so far.
USE AP
Declare @MyRowCount int
SELECT Top 1 name
FROM sys.tables
WHERE name not like 'dtproperties' and name...
October 23, 2014 at 4:14 pm
dogramone (10/23/2014)
conceptually ...
select the...
October 23, 2014 at 4:04 pm
Luis Cazares (10/23/2014)
dariuslearn (10/23/2014)
so the table name resulting from the following query should become the column name.
SELECT name
FROM sys.tables
WHERE name = (select Top 1 name from sys.tables)
;
You don't need...
October 23, 2014 at 3:59 pm
ScottPletcher (10/23/2014)
In the SELECT list, after the original column name or expression, you can add "AS new_column_name", and the...
October 23, 2014 at 3:23 pm
Viewing 15 posts - 1 through 15 (of 15 total)