Article on the subject of "sql server advanced command"
-
COALESCE statement in SQL Server
the coalesce statement returns the expression with the first non-null value among the passed expressions.
-
Function SESSION_USER in SQL Server
the session_user statement returns the username of the current session in the sql server database.
-
SYSTEM_USER function in SQL Server
the system_user statement returns the username of the current user in the sql server database.
-
USER_NAME function in SQL Server
this article will show you in detail how to use the function to handle the user_name statement in sql server with specific syntax and examples to better visualize and capture the function.
-
COALESCE statement in SQL Server
the coalesce statement returns the expression with the first non-null value among the passed expressions.
-
Configure advanced firewall in Windows 2008 using NETSH CLI
in the previous article, i introduced how to configure windows server 2008 advanced firewall using the mmc snap-in. in this article, i will show you how to configure the same windows 2008 server advanced firewall using the command line interface (cli) using the netsh utility. c & oacu
-
SYSTEM_USER function in SQL Server
the system_user statement returns the username of the current user in the sql server database.
-
GOTO command in SQL Server
the goto command is a simple jump command, which allows an unconditional jump program from goto to a location in the program that has a label (laber) command in the same function.
-
Clean command in Windows
the clean command deletes all partitions or formats the volume from the current drive. the command applies to windows server (semi-annual channel), windows server 2019, windows server 2016, windows server 2012 r2, windows server 2012.
-
CASE function in SQL Server (part 1)
in sql server, the case function verifies the value based on the list of given conditions, then returns one or more results. in this article we will illustrate a number of different uses of this function in different situations.
-
The sfc command in Windows
(applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012)
-
The cacls command in Windows
the cacls command displays or modifies an arbitrary access control list (dacl) on the specified file. the command applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012.
-
CASE statement in SQL Server
this article will show you in detail how to use the case statement handling function in sql server with specific syntax and examples to better visualize and capture functions.
-
SELECT TOP command in SQL Server
in sql server, the select top command is used to retrieve records from one or more tables in sql server and limit the number of return records based on a fixed value or percentage.
-
Function SESSION_USER in SQL Server
the session_user statement returns the username of the current session in the sql server database.
-
SELECT INTO command in SQL Server
the article guides using select into command in sql server with syntax and examples.
-
Prncnfg command in Windows
(applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012
-
CURRENT_USER statement in SQL Server
the current_user statement returns the name of the current user in the sql server database.
-
The command bootcfg delete in Windows
the bootcfg delete command deletes the operating system entry in the [operating systems] section of the boot.ini file. the command applies to: windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012.
-
The route_ws2008 command in Windows
(applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012)
-
Ntcmdprompt command in Windows
(applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012).
-
Nslookup command in Windows
(applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012).
-
The ntfrsutl command in Windows
(applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012).