By using this site, you acknowledge that you have read and understand our Cookie policy, Privacy policy and Terms .

local_offer t-sql

Select top N records in T-SQL / SQL Server

more_vert

local_offer mssql local_offer t-sql

visibility 17
comment 0
thumb_up 2
access_time 3 months ago

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

open_in_new View

Convert string to date in T-SQL / SQL Server

more_vert

local_offer mssql local_offer t-sql

visibility 3
comment 0
thumb_up 0
access_time 3 months ago

This code snippet shows how to convert string to date.

open_in_new View

Calculate time difference in T-SQL / SQL Server

more_vert

local_offer mssql local_offer t-sql

visibility 8
comment 0
thumb_up 0
access_time 3 months ago

This code snippet shows how to calculate time differences.

open_in_new View

Read and parse JSON in T-SQL / SQL Server

more_vert

local_offer mssql local_offer t-sql

visibility 6
comment 0
thumb_up 0
access_time 3 months ago

JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON. 

open_in_new View

Select from dual in T-SQL / SQL Server

more_vert

local_offer mssql local_offer t-sql

visibility 9
comment 0
thumb_up 0
access_time 3 months ago

In Oracle database, you can select from dual table if you only want to return a one row result set. In many other databases, the query engine supports select directly from constant values without specifying a table name. 

open_in_new View

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

more_vert

local_offer teradata local_offer t-sql local_offer mssql local_offer SQL local_offer SQL Server

visibility 3949
comment 2
thumb_up 0
access_time 5 years ago

Tutorial –1 For Teradata developers, if you have no SQL Server installed, please go to the following link to download the SQL Server 2014 Expression Edition. ...

open_in_new View

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

more_vert

local_offer SQL local_offer SQL Server local_offer t-sql local_offer teradata

visibility 38810
comment 7
thumb_up 0
access_time 5 years ago

SELECT is one of the most commonly used statements. In this tutorial, I will cover the following items: Two of the principal query clauses—FROM and SELECT Data Types Built-in functions CASE expressions and variations like ISNULL and COALESCE. * The functio...

open_in_new View

Tag cloud

local_offer C# local_offer .NET local_offer ASP.NET local_offer SQL Server local_offer Windows Phone local_offer SSIS local_offer QlikView local_offer HTML local_offer Windows Azure local_offer Javascript local_offer MVC local_offer SVN local_offer C&CPP local_offer VB local_offer Windows 8 App local_offer Context Project local_offer WebMatrix local_offer Linq local_offer Java local_offer Web Services local_offer dotnet core local_offer angular local_offer asp.net core 2 local_offer kontext local_offer xml-rpc local_offer .net core local_offer Azure local_offer asp.net core local_offer identity core 2 local_offer teradata local_offer SQL local_offer python local_offer dotnetcore local_offer bootstrap local_offer lite-log local_offer zeppelin local_offer spark local_offer hadoop local_offer yarn local_offer hdfs local_offer rdd local_offer scala local_offer parquet local_offer kerberos local_offer powershell local_offer linux local_offer sqoop local_offer power-bi local_offer google-analytics local_offer entity-framework local_offer docu local_offer bigquery local_offer gcp local_offer dataflow local_offer gcs local_offer pyspark local_offer open-banking local_offer hive local_offer partitioning local_offer gulp local_offer NTLM local_offer WSL local_offer ubuntu local_offer oozie local_offer pandas local_offer hue local_offer csharp local_offer dotnet local_offer dotnet-core local_offer mssql local_offer r-lang local_offer shell local_offer spark-2-x local_offer t-sql local_offer .net-core-3 local_offer asp.net core 3 local_offer devops local_offer ssl local_offer bug local_offer aws local_offer jupyter-notebook local_offer f# local_offer machine-learning