adspace


Can select statements be used on views in ms sql server?

Answer Posted / Anees Ahmad

When working with NULL values and DateTime operations in MS SQL Server, you may face unexpected results or errors. It's generally recommended to handle NULL values explicitly using ISNULL(), COALESCE(), or IFNULL() functions.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is spatial nonclustered index

1058


How to convert numeric expression data types using the cast() function?

1149


Can you index views?

954


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1071


What is acid mean in sql server?

1245


What is normalization and what are the advantages of it?

1055


What are the source of constraints?

1009


What kind of problems occurs if we do not implement proper locking strategy?

1499


How to enter binary string literals in ms sql server?

1244


What is temporary table in sql server? Why we use temp table?

1021


What are the properties of the transaction?

1073


What is a view in sql?

1040


what is the difference between openrowset and openquery?

1194


Where can you add custom error messages to sql server?

1211


Can we do dml on views?

1038