Denali – 2012
SQL Server 2012 (a.k.a Denali) – New Features:
23. Another reason to use THROW clause instead of RAISERROR
22. Enhanced OVER() Clause – Part 2
21. Using FullText search with FileTables in SQL Server 2012
20. New THROW statement in SQL Server 2012 (vs RAISERROR)
19. SQL Server 2012 does not support Linked Server to SQL Server 2000, workaround
18. Temp Tables are created with negative Object IDs
17. Passed 70-461 Exam : Querying Microsoft SQL Server 2012
16. SQL Server 2012 Upgrade – Use Upgrade Advisor
15. Issue with the new SEQUENCE feature in SQL Server 2012 and its workaround (not a bug)
14. Issue with IDENTITY property in SQL Server 2012 and its workaround (not a bug)
13. SQL Server 2012 Upgrade Technical Guide and Why Upgrade
12. New CONCAT() & FORMAT() functions
9. SET FMTONLY ON/OFF Depricated | New SPs and DMFs introduced in replacement
8. Enhanced OVER() Clause – Part 1
7. SQL Server 2012 (a.k.a Denali) – New feature | WITH RESULT SETS
6. Filetables
2. SEQUENCES
1. New Features
Hi Manoj,
Could you please help me how to handle the the space in the sheet value ( Budget Administrative Code in the following example)
SELECT *
FROM OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0′,
‘Data Source= C:\testing Country.xlsx;
Extended Properties=”Excel 12.0″‘)…[Budget Administrative Code$];
What do mean by space in sheet value & how do you want to handle it?
Can you please explain.
how to use vb function to sql query function
ex:
function emp()
str=”select * from employ”
set rs=conn.execute(str)
do while rs.eof=false
for i= 1 to 6
if sex=’m’ then
update status=’male’ where empcode=’1000′
else
update status=’female’ where empcode=’1000′
next
loop
end function
Check this:
UPDATE employ
SET status=’male’
WHERE sex=’m’
and where empcode=1000
UPDATE employ
SET status=’female’
WHERE sex’m’
and where empcode=1000
I am planning to prepare for SQL 2012 certification (Business Intelligence). Could you give me some idea how to setup the lab environment to cover 40-461, 462, 463, 466 & 467.I do not have access to server machines, so it would be good if you can provide me some info about simulating the environment using my desktop machine.
Thanks.