What is INTVAL( )and where we use Plz any body help me

What is INTVAL( )and where we use

Plz any body help me

Question Posted / bhaskar

What is INTVAL( )and where we use Plz any body help me..

Answer / akash

it will return the integer value of a variable

for example

intval(42); // 42
intval(4.2); // 4
intval('42'); // 42
intval('+42'); // 42

Is This Answer Correct ?

3 Yes

2 No

More SQL Server Interview Questions

When should you use an instead of trigger?

How to list all schemas in a database?

Repair mdf file

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

Is the primary key column of a table an index in ms sql server?

What is difference between getdate and sysdatetime in sql server 2008?

How to create new table with "create table" statements?

How do I create an extended event in sql server?

Explain some DBCC commands?

How can you insert null values in a column while inserting the data?

How do I create a trace in sql server?

How to use go command in "sqlcmd"?

For more SQL Server Interview Questions Click Here