Article on the subject of "sql server advanced command"

  • COALESCE statement in SQL Server

    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

    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

    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

    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

    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

    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

    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

    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

    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)

    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

    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 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

    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

    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

    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

    SELECT INTO command in SQL Server

    the article guides using select into command in sql server with syntax and examples.
  • Prncnfg command in Windows

    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

    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 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

    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

    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

    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

    The ntfrsutl command in Windows

    (applies to windows server (semi-annual channel), windows server 2016, windows server 2012 r2, windows server 2012).