In order to differentiate between two rows, we normally use primary keys or identity values which may be same across two tables. In order to overcome this problem we can use a special type named "GUID" . Its a hexadecimal number (Base 16) and the advantage is that they are unique across all databases and tables. In SQL Server the same concept is implemented through UNIQUEIDENTIFIER data type. In order to generate a new value, we use the NEWID() function. For e.g. a. Creating a table that uses the UNIQUEIDENTIFIER datatype Create table Test ( Empno uniqueidentifier, Ename varchar(20) ) b. Inserting rows in the tables with the use of NEWID() function insert into Test values (newId(),'ABC') insert into Test values (newid(),'XYZ') insert into test values (newid(),'MNO') c. Selecting the rows from the table. Select * from test Empno ...
Comments
some code is missing in client handler , even server and client code is not there.
Please kindly upload full file of client handler ,server and client side code
Thank you
Kindly check it again. Its complete in all respects i.e. Server side, Client Handler and ClientSide Socket.