SQL Server Blog
The Oracle/PLSQL TO_NCLOB function converts the LOB value to the NCLOB value. Oracle/PLSQL syntax of TO_NCLOB function TO_NCLOB( expression_id ) Parameters or argumentsexpression_id -...
SQL Server applies role-based security rights delimitation. A role is a certain set of rights that can be assigned to a certain user or group of users.In SQL Server there are default server...
One of the tasks that one has to face during software development or DBMS administration (and, in particular, SQL Server) is determining which version of the SQL Server is installed, in which edition...
The Oracle/PLSQL TO_MULTI_BYTE function returns a character value from all single-byte characters and converts it into multi-byte characters. To use this function, your database character set...
The Oracle/PLSQL TO_LOB function converts LONG or LONG RAW values to LOB values. Syntax of the Oracle/PLSQL TO_LOB function TO_LOB( long_column_id ) Parameters or argumentslong_column_id...
The Oracle/PLSQL TO_DSINTERVAL function converts the string to INTERVAL DAY TO SECOND. Syntax of the Oracle/PLSQL TO_DSINTERVAL function TO_DSINTERVAL( character [ nls_parameter_id ] )...
Oracle/PLSQL TO_CLOB function converts character data of CLOB type Syntax of the Oracle/PLSQL TO_CLOB function TO_CLOB(expression_id) Parameters or argumentsexpression_id - can accept...
The Oracle/PLSQL RAWTOHEX function converts a RAW value into a hexadecimal character representation. Syntax of the Oracle/PLSQL RAWTOHEX function RAWTOHEX( raw_id ) Parameters or arguments...
The Oracle/PLSQL NUMTOYMINTERVAL function converts a numerical value into a value of type INTERVAL YEAR TO MONTH. Function Oracle/PLSQL NUMTOYMINTERVAL syntax NUMTOYMINTERVAL( number_id,...
The Oracle/PLSQL NUMTODSINTERVAL function converts a numeric value into a value of INTERVAL DAY TO SECOND type. Syntax of the Oracle/PLSQL NUMTODSINTERVAL function: NUMTODSINTERVAL( number_id,...
You probably already know that you can disable the index. This can be handy with large loads, and loading + enabling indexes (you will have to completely rebuild them) is faster than loading with...
The Oracle/PLSQL HEXTORAW function converts a string representing a hexadecimal number into a RAW value. Syntax of the Oracle/PLSQL HEXTORAW function HEXTORAW( char_id ) Parameters or...
The Oracle PLSQL FROM_TZ function converts the TIMESTAMP value to TIMESTAMP with the time zone value. Oracle/PLSQL FROM_TZ function syntax FROM_TZ( timestamp_value_id, time_zone_value_id...
The Oracle/PLSQL DECOMPOSE function takes a string and returns a Unicode string. Oracle/PLSQL DECOMPOSE function syntax DECOMPOSE( string_id ) Parameters or argumentsstring_id - a string...
When you run SELECT COUNT(*), the speed of results depends largely on the structure and settings of the database. Let's do a survey on the Votes table in the Stack Overflow database - 300 GB version...
Cool hints of requests - SQL Server documentation contains a pretty cool list of query hints: But what is the color box? Let's see.Since SQL Server query optimizer usually chooses the best...