Skip to content

Commit ede5533

Browse files
v-thepetv-thepet
committed
more code lines
1 parent d07e8c9 commit ede5533

23 files changed

Lines changed: 257 additions & 339 deletions

‎docs/t-sql/database-console-commands/dbcc-freeproccache-transact-sql.md‎

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -152,15 +152,15 @@ GO
152152

153153
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
154154

155-
{!!! Mispalced text? !!!}
156-
`plan_handle text`
157-
158-
`-------------------------------------------------- -----------------------------`
159-
160-
`0x060006001ECA270EC0215D05000000000000000000000000 SELECT * FROM Person.Address;`
161-
162-
`(1 row(s) affected)`
163-
{end misplaed text ask}
155+
{!!! Misplaced text? !!!}
156+
```
157+
plan_handle text
158+
-------------------------------------------------- -----------------------------
159+
0x060006001ECA270EC0215D05000000000000000000000000 SELECT * FROM Person.Address;
160+
161+
(1 row(s) affected)```
162+
163+
{end misplaced text ask}
164164
165165
```sql
166166
-- Remove the specific plan from the cache.

‎docs/t-sql/database-console-commands/dbcc-useroptions-transact-sql.md‎

Lines changed: 17 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -49,23 +49,23 @@ DBCC USEROPTIONS returns a column for the name of the SET option and a column fo
4949

5050
```sql
5151

52-
| `Set Option Value`
53-
`---------------------------- ---------------------------`
54-
`textsize 64512`
55-
`language us_english`
56-
`dateformat mdy`
57-
`datefirst 7`
58-
`lock_timeout -1`
59-
`quoted_identifier SET`
60-
`arithabort SET`
61-
`ansi_null_dflt_on SET`
62-
`ansi_warnings SET`
63-
`ansi_padding SET`
64-
`ansi_nulls SET`
65-
`concat_null_yields_null SET`
66-
`isolation level read committed`
67-
`(13 row(s) affected)`
68-
`DBCC execution completed. If DBCC printed error messages, contact your system administrator.`
52+
Set Option Value`
53+
---------------------------- ---------------------------`
54+
textsize 64512
55+
language us_english
56+
dateformat mdy
57+
datefirst 7
58+
lock_timeout -1
59+
quoted_identifier SET
60+
arithabort SET
61+
ansi_null_dflt_on SET
62+
ansi_warnings SET
63+
ansi_padding SET
64+
ansi_nulls SET
65+
concat_null_yields_null SET
66+
isolation level read committed
67+
(13 row(s) affected)
68+
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
6969
```
7070

7171
## Remarks

‎docs/t-sql/functions/datepart-transact-sql.md‎

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -200,9 +200,10 @@ SELECT TOP(1) DATEPART (day,'12/20/1974') FROM dbo.DimCustomer;
200200

201201
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
202202

203-
`--------`
204-
205-
`20`
203+
```
204+
--------
205+
20
206+
```
206207

207208
The following example returns the year part of the date `12/20/1974`.
208209

@@ -214,9 +215,10 @@ SELECT TOP(1) DATEPART (year,'12/20/1974') FROM dbo.DimCustomer;
214215

215216
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
216217

217-
`--------`
218-
219-
`1974`
218+
```
219+
--------
220+
1974
221+
```
220222

221223
## See also
222224
[CAST and CONVERT (Transact-SQL)](../../t-sql/functions/cast-and-convert-transact-sql.md)

‎docs/t-sql/functions/dense-rank-transact-sql.md‎

Lines changed: 18 additions & 34 deletions
Original file line numberDiff line numberDiff line change
@@ -181,40 +181,24 @@ GROUP BY LastName,SalesTerritoryGroup;
181181

182182
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
183183

184-
`LastName TotalSales SalesTerritoryGroup RankResult`
185-
186-
`---------------- ------------- ------------------- --------`
187-
188-
`Pak 10514000.0000 Europe 1`
189-
190-
`Varkey Chudukatil 5557000.0000 Europe 2`
191-
192-
`Valdez 2287000.0000 Europe 3`
193-
194-
`Carson 12198000.0000 North America 1`
195-
196-
`Mitchell 11786000.0000 North America 2`
197-
198-
`Blythe 11162000.0000 North America 3`
199-
200-
`Reiter 8541000.0000 North America 4`
201-
202-
`Ito 7804000.0000 North America 5`
203-
204-
`Saraiva 7098000.0000 North America 6`
205-
206-
`Vargas 4365000.0000 North America 7`
207-
208-
`Campbell 4025000.0000 North America 8`
209-
210-
`Ansman-Wolfe 3551000.0000 North America 9`
211-
212-
`Mensa-Annan 2753000.0000 North America 10`
213-
214-
`Tsoflias 1687000.0000 Pacific 1`
215-
216-
217-
184+
```
185+
LastName TotalSales SalesTerritoryGroup RankResult
186+
---------------- ------------- ------------------- --------
187+
Pak 10514000.0000 Europe 1
188+
Varkey Chudukatil 5557000.0000 Europe 2
189+
Valdez 2287000.0000 Europe 3
190+
Carson 12198000.0000 North America 1
191+
Mitchell 11786000.0000 North America 2
192+
Blythe 11162000.0000 North America 3
193+
Reiter 8541000.0000 North America 4
194+
Ito 7804000.0000 North America 5
195+
Saraiva 7098000.0000 North America 6
196+
Vargas 4365000.0000 North America 7
197+
Campbell 4025000.0000 North America 8
198+
Ansman-Wolfe 3551000.0000 North America 9
199+
Mensa-Annan 2753000.0000 North America 10
200+
Tsoflias 1687000.0000 Pacific 1
201+
```
218202

219203
## See Also
220204
[RANK (Transact-SQL)](../../t-sql/functions/rank-transact-sql.md)

‎docs/t-sql/functions/file-name-transact-sql.md‎

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -65,13 +65,13 @@ GO
6565

6666
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
6767

68-
`File Name 1 File Name 2`
69-
70-
`---------------- ------------------------`
71-
72-
`AdventureWorks2012_Data AdventureWorks2012_Log`
73-
74-
`(1 row(s) affected)`
68+
```
69+
File Name 1 File Name 2
70+
---------------- ------------------------
71+
AdventureWorks2012_Data AdventureWorks2012_Log
72+
73+
(1 row(s) affected)
74+
```
7575

7676
## See Also
7777
[FILE_IDEX (Transact-SQL)](../../t-sql/functions/file-idex-transact-sql.md)

‎docs/t-sql/functions/filegroup-id-transact-sql.md‎

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -61,13 +61,13 @@ GO
6161

6262
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
6363

64-
`Filegroup ID`
65-
66-
`------------`
67-
68-
`1`
69-
70-
`(1 row(s) affected)`
64+
```
65+
Filegroup ID
66+
------------
67+
1
68+
69+
(1 row(s) affected)
70+
```
7171

7272
## See Also
7373
[FILEGROUP_NAME (Transact-SQL)](../../t-sql/functions/filegroup-name-transact-sql.md)

‎docs/t-sql/functions/floor-transact-sql.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -67,9 +67,11 @@ SELECT FLOOR(123.45), FLOOR(-123.45), FLOOR($123.45);
6767

6868
The result is the integer part of the calculated value in the same data type as *numeric_expression*.
6969

70-
`----- --------- -----------`
70+
```
71+
----- --------- -----------
7172
72-
`123 -124 123`
73+
123 -124 123
74+
```
7375

7476
## See Also
7577
[Mathematical Functions (Transact-SQL)](../../t-sql/functions/mathematical-functions-transact-sql.md)

‎docs/t-sql/functions/getansinull-transact-sql.md‎

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -69,11 +69,12 @@ GO
6969

7070
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
7171

72-
`------`
73-
74-
`1`
75-
76-
`(1 row(s) affected)`
72+
```
73+
------
74+
1
75+
76+
(1 row(s) affected)
77+
```
7778

7879
## See Also
7980
[System Functions (Transact-SQL)](../../relational-databases/system-functions/system-functions-for-transact-sql.md)

‎docs/t-sql/functions/getdate-transact-sql.md‎

Lines changed: 16 additions & 22 deletions
Original file line numberDiff line numberDiff line change
@@ -111,17 +111,14 @@ SELECT CONVERT (date, SYSDATETIME())
111111

112112
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
113113

114-
`SYSDATETIME() 2007-05-03`
115-
116-
`SYSDATETIMEOFFSET() 2007-05-03`
117-
118-
`SYSUTCDATETIME() 2007-05-04`
119-
120-
`CURRENT_TIMESTAMP 2007-05-03`
121-
122-
`GETDATE() 2007-05-03`
123-
124-
`GETUTCDATE() 2007-05-04`
114+
```
115+
SYSDATETIME() 2007-05-03
116+
SYSDATETIMEOFFSET() 2007-05-03
117+
SYSUTCDATETIME() 2007-05-04
118+
CURRENT_TIMESTAMP 2007-05-03
119+
GETDATE() 2007-05-03
120+
GETUTCDATE() 2007-05-04
121+
```
125122

126123
### C. Getting the current system time
127124

@@ -137,17 +134,14 @@ SELECT CONVERT (time, SYSDATETIME())
137134

138135
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
139136

140-
`SYSDATETIME() 13:18:45.3490361`
141-
142-
`SYSDATETIMEOFFSET()13:18:45.3490361`
143-
144-
`SYSUTCDATETIME() 20:18:45.3490361`
145-
146-
`CURRENT_TIMESTAMP 13:18:45.3470000`
147-
148-
`GETDATE() 13:18:45.3470000`
149-
150-
`GETUTCDATE() 20:18:45.3470000`
137+
```
138+
SYSDATETIME() 13:18:45.3490361
139+
SYSDATETIMEOFFSET()13:18:45.3490361
140+
SYSUTCDATETIME() 20:18:45.3490361
141+
CURRENT_TIMESTAMP 13:18:45.3470000
142+
GETDATE() 13:18:45.3470000
143+
GETUTCDATE() 20:18:45.3470000
144+
```
151145

152146
## Examples: [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]
153147
The following examples use the three [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] system functions that return current date and time to return the date, time, or both. The values are returned in series; therefore, their fractional seconds might be different.

‎docs/t-sql/functions/grouping-transact-sql.md‎

Lines changed: 10 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -65,19 +65,16 @@ GO
6565

6666
[!INCLUDE[ssResult](../../includes/ssresult-md.md)]
6767

68-
`SalesQuota TotalSalesYTD Grouping`
69-
70-
`------------ ----------------- --------`
71-
72-
`NULL 1533087.5999 0`
73-
74-
`250000.00 33461260.59 0`
75-
76-
`300000.00 9299677.9445 0`
77-
78-
`NULL 44294026.1344 1`
79-
80-
`(4 row(s) affected)`
68+
```
69+
SalesQuota TotalSalesYTD Grouping
70+
------------ ----------------- --------
71+
NULL 1533087.5999 0
72+
250000.00 33461260.59 0
73+
300000.00 9299677.9445 0
74+
NULL 44294026.1344 1
75+
76+
(4 row(s) affected)
77+
```
8178

8279
## See Also
8380
[GROUPING_ID (Transact-SQL)](../../t-sql/functions/grouping-id-transact-sql.md)

0 commit comments

Comments
 (0)