Overblog
Follow this blog Administration + Create my blog

Interview Questions of SQLServer

March 17 2013 , Written by Balavardhan Reddy Published on #SQL Server2005

Do you know what are User Defined functions. Scalar, Inline Table-Valued and Multi-statement Table-valued. A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These are the...

Read more

Sqlserver - Query to Get Size of the data

March 17 2013 , Written by Balavardhan Reddy Published on #SQL Server2005

Query to get the size of a column data for each row. Select DATALENGTH(<>) from <> Query to get the size of a column data for each group. Select DATALENGTH(<>), <> from <> Group by <

Read more