MSSQL

I will tell you below metadata functions in this article. APP_NAME COL_LENGTH DATABASEPROPERTYEX SERVERPROPERTY DB_ID DB_NAME OBJECT_ID OBJECT_NAME SCHEMA_ID SCHEMA_NAME STATS_DATE APP_NAME Function: This function …

Before you begin this article, I suggest you read my article “How To Create a Login On SQL Server(Manage Logins)” for a detailed review of …

A login must have authority over some database roles in the msdb database in order to access SQL Server Agent. These roles in the msdb …

  CHOOSE and IIF functions are logical functions. CHOOSE function returns the value at the specified index from the specified list. IIF function performs the …

  Spatial Index can only be created on Spatial columns. That is, the type of column must be geometry or geography. Let’s create a table …

  SQRT function returns the square root of a float value and the return data type is float. SQUARE function returns the square of a …

  The Filtered Index is a filtered nonclustered index. For example, you have 100,000 records in a table. And some of your queries are only …

  The SIGN function determines whether a number is negative, 0, or positive. If the number is negative, it returns -1, If the number is …

Most database experts, or TSQL developer knows EDIT TOP 200 Rows option. When you click EDIT TOP 200 Rows by right-clicking on the table, unlike …

  The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number …