-
Notifications
You must be signed in to change notification settings - Fork 0
/
Azure_azure-sdk-for-python.sql
6 lines (6 loc) · 1.2 KB
/
Azure_azure-sdk-for-python.sql
1
2
3
4
5
6
SELECT * FROM \n (\n VALUES(1,2),(2,4)\n ) \n AS \n T(a, b);\nEND;
CREATE TABLE adladbb9d51798.dbo.adlatableb9d51798\n(\n //Define schema of table\n UserId int, \n Start DateTime, \n Region string, \n Query string, \n Duration int, \n Urls string, \n ClickedUrls string,\n INDEX idx1 \n CLUSTERED (Region ASC) \n PARTITIONED BY BUCKETS (UserId) HASH (Region)\n)
CREATE TABLE adladbb9d51798.dbo.adlatableb9d51798\n(\n //Define schema of table\n UserId int, \n Start DateTime, \n Region string, \n Query string, \n Duration int, \n Urls string, \n ClickedUrls string,\n INDEX idx1 \n CLUSTERED (Region ASC) \n PARTITIONED BY (UserId) HASH (Region)\n)
CREATE TABLE adladb32e3152c.dbo.adlatable32e3152c\n(\n //Define schema of table\n UserId int, \n Start DateTime, \n Region string, \n Query string, \n Duration int, \n Urls string, \n ClickedUrls string,\n INDEX idx1 \n CLUSTERED (Region ASC) \n PARTITIONED BY (UserId) HASH (Region)\n)
SELECT * FROM \n (\n VALUES(1,2),(2,4)\n ) \n AS \n T(a, b);\nEND;
CREATE TABLE {0}.dbo.{1}( //Define schema of table UserId int, Start DateTime, Region string, Query string, Duration int, Urls string, ClickedUrls string, INDEX idx1 CLUSTERED (Region ASC) PARTITIONED BY (UserId) HASH (Region))