- Which external languages are supported by SQL Server?
Python and R. - Which service must be running for the successful execution of external code?
SQL Server Launchpad. - Can we combine filestreams with temporal tables?
No, temporal tables do not support the versioning of filestream data. - We are calling the following code: exec sp_execute_external_script @language = 'R', @script = '';. The script does not work and returns an error. Why?
Every parameter of the procedure is of the nvarchar data type. All parameter values must start with a leading capital N: N'text in the parameter'. - We are calling the sp_execute_external_script stored procedure. Inside the R script, we have the following line: Outputdataset <- as.data.frame(1+1);. The code does not return a result. Why?
This is because the R language is case-sensitive. The correct casing is...
Germany
Slovakia
Canada
Brazil
Singapore
Hungary
Philippines
Mexico
Thailand
Ukraine
Luxembourg
Estonia
Lithuania
Norway
Chile
United States
Great Britain
India
Spain
South Korea
Ecuador
Colombia
Taiwan
Switzerland
Indonesia
Cyprus
Denmark
Finland
Poland
Malta
Czechia
New Zealand
Austria
Turkey
France
Sweden
Italy
Egypt
Belgium
Portugal
Slovenia
Ireland
Romania
Greece
Argentina
Malaysia
South Africa
Netherlands
Bulgaria
Latvia
Australia
Japan
Russia