Monthly Archives: July 2011

SQL 150 Table Creation, Introduction or How can I define a data table?

SQL 150 Table Creation, Introduction or How can I define a data table?

Explains an introduction to table definition. From ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, Postgre…

PARSE() – SQL Server Function usage with Screenshot

SQL Server Denali CTP3 has introduces a new function PARSE() to translate the result of an expression to specified data type that too is specified language. PARSE() returns the result of an expression, translated to specified data type if the translation is possible, otherwise, it raises an error. PARSE (), expects three parameters, string_value – [...]

TRY_PARSE() – SQL Server Function usage with Screenshot

SQL Server Denali CTP3 has introduces a new function TRY_PARSE() to translate the result of an expression to specified data type. TRY_PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns NULL. Moreover, we can also specify the CULTURE, during this conversion. CULTURE, means [...]

TRY_CONVERT() SQL Server Example – Screenshot

SQL Server Denali CTP3 has introduces a new function TRY_CONVERT() to evaluates whether a data type conversion is possible or not? TRY_CONVERT(), checks whether typecasting / datatype conversion from one datatype to other datatype is possible or not and if it possible then it converts the source data type into the target type and if [...]

How to use IIF() in SQL Server ?

SQL Server Denali CTP3 has introduces a new function IIF() to evaluates specified expression and returns specified true/false values. IIF(), is kind of shorthand way of writing a CASE expression where we can expect only two result either true or false. This function is same as available in other languages. IIF(), accepts three parameters, First [...]

CHOOSE – SQL Server Fuction

SQL Server Denali CTP3 has introduces a new function CHOOSE() for selecting a specific value from a given options . Choose () function is used to return any specific value from a given list, CHOOSE(), accepts two parameters, where the first parameter is Index – Numeric expression that results in a value between 1 and [...]

SQL Server evaluation period has expired

Today Morning, when I switched my Virtual Machine for Denali CTP1 and I was unable to login and received the following error Message TITLE: Connect to Server Cannot connect to WIN-8Z9VLH1HA5G. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. [...]