tsql - AZURE SQL TRUNCATE TABLE PARTITIONS -


i stuck trying 

truncate table partitiontable1 (partitions (2, 4, 6 8));

that syntax same in msdn here

in vs 2012 latest ssdt , target platform: "microsoft azure sql database v12" error :

"sql46010: incorrect syntax near (. " , mark bracket between "with ( partitions"

i´ve got same error in azure management portal - sql database.

in microsoft sql server management studio error message:

"incorrect syntax near 'with'."

any thought appreciated...

disclaimer: work on sql server tooling team.

there 2 separate issues here, 1 in ssdt , 1 related ssms failure.

  • for ssms failure, problem using azure v1 server/database , syntax isn't supported against v1 dbs. try upgrading server or running against different 1 verify works expected you. there information on upgrading or creating azure v12 databases here.
  • the main ssdt bug because syntax new azure v12 (not available in other sql server version). ssdt uses component called sqldom parse scripts, , current release still uses sql server 2014 rtm version of component. fixed in upcoming preview release support new syntax such this. unfortunately until issue cause statement fail in project system. workaround avoid using new syntax until ssdt updated.

Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more