SQL Server 2012-DENALI-whats new in T-SQL

Who is online?  98 guests and 0 members
home  »  blogs  »  Amit Bansal  »  SQL Server 2012-DENALI-whats new in T-SQL

Training on Microsoft Products & Technologies

SQL Server 2012-DENALI-whats new in T-SQL

change text size: A A A

posted  11/30/2011 8:05:31 AM  by Amit Bansal -  Views: [40738] 

Hi Friends,

I have written a couple of blog posts on new T-SQL features and enhancements in SQL Server 2012 (DENALI). This post summarizes some of them:

SQL Server 2012 DENALI series-THROW statement

http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/365/sql-server-2012-denali-series-throw-statement

 

SQL Server 2012 DENALI series: SEQUENCE OBJECT

http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/346/sql-server-2012-denali-series-sequence-object

 

SQL Server 2012 DENALI series: SEQUENCE OBJECT – Part 2

http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/349/sql-server-2012-denali-series-sequence-object-%E2%80%93-part-2

 

SQL Server 2012 DENALI series: SEQUENCE feature – Part 3 – Re-seeding, Restarting, incrementing & Cycling

http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/358/sql-server-2012-denali-series-sequence-feature-%E2%80%93-part-3-%E2%80%93-re-seeding-restarting-incrementing-cycling

 

If you liked the posts, do like us on FaceBook at http://www.FaceBook.com/SQLServerGeeks

 

Regards, 
Amit Bansal

http://www.twitter.com/A_Bansal

http://www.twitter.com/SQLServerGeeks

http://www.amitbansal.net/

Visit my FaceBook page at http://www.facebook.com/AmitRSBansal

Contribute on SQLServerGeeks.com: visit http://www.sqlservergeeks.com/default-category/write-for-us

tags : What’s new in T-SQL in DENALI SQL Server 2012, denali t-sql enhancements
  Rate This Blog Entry:  register  or  login

Author

AmitBansal Amit Bansal (Member since: 3/12/2011 4:59:54 PM)
Follow Amit at Twitter @A_Bansal : Amit Bansal is the CTO of eDominer Systems & Peopleware India. He is a consultant, trainer, writer, speaker & evangelist on SQL Server & Business Intelligence. A seasoned speaker; he speaks at major summits and conferences of Microsoft worldwide including TechED, MCT Summits, MSDN & TechNet conferences. Over the last 8 years, he has consulted, trained & mentored more than 6000 IT professionals on SQL Server & Business Intelligence and worked with top notch blue chip companies worldwide including Microsoft, Infosys, Wipro, RBS, HCL, HP, Siemens, IBM, Accenture, etc. He has delivered more than 400 workshops on SQL Server & Business Intelligence. Apart from holding many Microsoft credentials, he is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server. He is also one of the first Microsoft Certified Trainer in India. Amit has worked with Microsoft in India and US as a Subject Matter Expert in various capacities participating in OD sessions, technical reviewing, etc. He is also a very active community lead in Asia Pacific. Visit www.amitbansal.net to know more. Subscribe to Amit’s blog and be a member of his technical forum at www.SQLServerGeeks.com - an exclusive SQL Server portal. Visit www.peoplewareindia.com for Corporate Training solutions. FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346 LinkedIn – http://www.linkedin.com/pub/amit-bansal/7/121/755

View Amit Bansal 's profile

Comments (2)

Srinivas
1/12/2012 11:14:55 AM Srinivas said:

Any thoughts why packages(like in Oracle) are still not being introduced in SQL Server.

by
Chinna Babu
1/18/2012 9:41:04 AM Chinna Babu said:

Hi,

Thank you

 

by

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

example: "http://www.SQLServerGeeks.com"

 
Type the characters:
 *
 
   

Training on Microsoft Products & Technologies

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Amit Bansal's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • SQL Server Day in Gurgaon in May 05’ 2012
    4/30/2012 5:05:54 AM by Admin Admin  - Views: 280  - Comments: 0
    Dear SQL Geek, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And after successful events in Bangalore, Kolkata & Mumbai, we a...
  • SQL Server 2012 Feature Pack
    4/23/2012 9:24:41 AM by Quick Tip  - Views: 241  - Comments: 0
    Hi SQL Geeks, The Microsoft® SQL Server® 2012 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. You can download the ...
  • SQL Server QUOTENAME function
    4/23/2012 9:09:51 AM by Amit Bansal  - Views: 1158  - Comments: 4
    Hi Friends, Here is an interesting function: QUOTENAME() which returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. (from Books Online) ...
  • SQL Server 2008 R2 Express Database size limit
    4/12/2012 8:20:10 AM by Ravi Kumar  - Views: 926  - Comments: 0
    Hi All, It is a great news to all those who use SQL Server Express editions. Microsoft has increased the database size limit of SQL Server 2008 R2 Express edition from 4GB to 10GB. Previous versions o...
  • SQL Server – What is Scalar Function?
    4/11/2012 7:04:48 AM by Piyush Bajaj  - Views: 3239  - Comments: 2
    Hello Friends, It’s been a while that I have posted any blog. So here it is- Well with the arrival of SQL Server 2000, Microsoft has introduced the concept of User Defined Function (UDF). So the...
  • SQL Server 2012 Released to Manufacturing
    4/9/2012 11:41:31 AM by SQLnews SQLnews  - Views: 325  - Comments: 0
    Exciting news! SQL Server 2012 has released to manufacturing. Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1. Microsoft ...