^[0-9]*[0-9]+[.]?[0-9]*$
123300. Valid
123300.00 Valid
123300.. Invalid
123300..0 Invalid
output:
123300 Valid123300. Valid
123300.00 Valid
123300.. Invalid
123300..0 Invalid
Monday, 22 August 2011
Subscribe to:
Posts (Atom)
-
alter database current set single_user with rollback immediate ; go alter database current set multi_user ; go
-
Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ... -
SELECT T.name AS [TABLE NAME], I.rows AS [ROWCOUNT] FROM sys.tables AS T INNER JOIN sys.sysindexes AS I ...