Precision and Scale

 

Use Case in SQL

 select @OfficeCode=OfficeCode   from Office where OfficeID= @OfficeID

SELECT OfficeId FROM Office

WHERE (CASE WHEN @OfficeLevel=1 THEN FirstLevel

WHEN @OfficeLevel=2 THEN SecondLevel

WHEN @OfficeLevel=3 THEN ThirdLevel

WHEN @OfficeLevel=4 THEN FourthLevel

END) = @OfficeCode

Get a Table from Comma separated value SQL

 Create a function :

CREATE FUNCTION split_string

(

    @in_string VARCHAR(MAX),

    @delimeter VARCHAR(1)

)

RETURNS @list TABLE(tuple VARCHAR(100))

AS

BEGIN

        WHILE LEN(@in_string) > 0

        BEGIN

            INSERT INTO @list(tuple)

            SELECT left(@in_string, charindex(@delimiter, @in_string+',') -1) as tuple

    

            SET @in_string = stuff(@in_string, 1, charindex(@delimiter, @in_string + @delimiter), '')

        end

    RETURN 

END

Calling a function: SELECT * FROM split_string('1001,1002,1003,1004', ',')

Table Descriptions

 select * 

  from information_schema.columns 

 where table_name = 'SMSParking'

 order by ordinal_position

EXEC sp_help SMSParking

File Size Validations

 jQuery File size validations. Arrow functions for file size validations.

    Filevalidation = () => {

        document.getElementById('size').innerHTML = '';

        let fi = document.getElementById('files');

        // Check if any file is selected.

        if (fi.files.length > 0) {

            for (const i = 0; i <= fi.files.length - 1; i++) {

                const fsize = fi.files.item(i).size;

                const file = Math.round((fsize / 1024));

                // The size of the file.

                if (file >= 4096) {

                    alert(

                        "File too Big, please select a file less than 4mb");

                    document.getElementById('files').value = '';

                } else if (file <= 1 ) {

                    alert(

                        "File too small, please select a file greater than 1KB");

                } else {

                    document.getElementById('size').innerHTML = '<b>'

                        + file + '</b> KB';

                }

            }

        }

    }

HTML:    <input type="file" name="files" id="files" multiple="multiple" onchange="Filevalidation()" />

ReactJS

 ReactJS Tutorial - 1 - Introduction - YouTube