MEHUL MAHERIYA

Difference between Sql Server Char and Varchar Data Type What is difference between nvarchar and char? CHAR Data Type is a Fixed Length Data Type. For example if you declare a variable/column of CHAR (10) data type, then it will always take 10 bytes irrespective of whether you are storing 1 character or 10 character in this variable or column. And in this example as we have declared this variable/column as CHAR (10), so we can store max 10 characters in this column. VARCHAR is a variable length Data Type. For example if you declare a variable/column of VARCHAR (10) data type, it will take the no. of bytes equal to the number of characters stored in this column. So, in this variable/column if you are storing only one character then it will take only one byte and if we are storing 10 characters then it will take 10 bytes DECLARE @Char Char ( 20 ) = 'MEHUL' ,   @VarChar VarChar ( 20 ) = '  MEHUL'   SELECT DATALENGTH ( @Char ) Ch...

  Interview Questions For Experienced  What is Function Overloading? Give me example of inbuilt Function over loading method. What is constructor? What is HTML text after rendering in require field validator? What is HTML text after rendering in list box? What is use of read only variable? What is difference between read only and normal variables? Write a query to get following result Department No of Emp HR 8 IT 3 Department Dept Name Dept Id Employee Emp id Emp name Dept Id ANS: Select DeptName , count ( EmpId ) as NooFEmp from dbo . DeptMaster D left outer Join dbo . EmpMaster E on E . EmpId = D . DeptId Group by DeptName Result:     What is Function Overriding? What is difference between Unique Key and Private Key?