how to count column Values in sql server

Question

hello friends : please suggest how to count column value in sql server

i.e i have one column name

products_id

and in this have two

values like 12,34

so i want to when select query execute than it show

product_id as producttotal= 2

Vinay Singh · Answer

Hi Try the below code SELECT (LENGTH(product_id) - LENGTH(REPLACE(product_id)) + 1) AS MyCol2Count FROM MyTable Where (LENGTH(product_id) - LENGTH(REPLACE(product_id)) + 1) =2

Rajeev Punhani · Answer

Hi Devendra Please find the below function. CREATE FUNCTION [dbo].[fnSplitString] ( @stringNVARCHAR( MAX ) @delimiter CHAR (1) ) RETURNS @ output TABLE (splitdataNVARCHAR( MAX ) ) BEGIN DECLARE @start INT @ end INT SELECT @start=1@ end =CHARINDEX(@delimiter@string) WHILE@start BEGIN IF@ end =0 SET @ end =LEN(@string)+1 INSERT INTO @ output (splitdata) VALUES ( SUBSTRING (@string@start@ end -@start)) SET @start=@ end +1 SET @ end =CHARINDEX(@delimiter@string@start) select count(*) from dbo.fnSplitString( '1224'  '' ) If the above solution is helpful then accept the answer.

Devendra Kumar · Answer

hii Vasanti andpasting Ravi Patel select count(products_id)as total product from tablename this query count id but i want to count in this id have how much values like product_id 1 and in this have two values 1234 count in this column have 2 value

Dipika · Answer

select count(products_id) from tablename

Ravi Patel · Answer

Hi  try this select count(products_id)as total product from tablename