SELECT CAST(CAST(NEWID() AS BINARY(15)) AS INT)
or
SELECT SUBSTRING(CAST(CAST(CAST(NEWID() AS BINARY(15)) AS INT)AS VARCHAR),2,7)
Subscribe to:
Post Comments (Atom)
About Me
Visitor Map
My Blog List
Popular Posts
-
Free HL7 Parser: The HL7(Health Level 7) message is very familior to the people who are working on HealthCare Projects.It is like a plain tx...
-
The MSChart control is an external ActiveX control that lets you add charting capabilities to your applications. You can create two- and thr... -
Gridview can be scrollable if it is put under a div with the overflow property.But if we scroll down the div ,the grid are go down and heade... -
Step 1-Create a Asp.NET Web Application project "CustAppPage" and a class library project "CustAppPageClassLib" and make... -
Most applications are currently written on top of relational databases. At some point, these applications will have to interact with the dat... -
In few cases we need to show yes now popup instead of OK Cancel confirm dialog box. You can do it by the following code. Write the following... -
Quotation is one of the important aspect of software cycle. Any prediction less or more will affect the project a lot. Lets look at how basi... -
Database Mirroring is a technology for increasing database availability. Database Mirroring transfers transaction log records from one serve... -
Two Dropdownlist within a Gridview with autopostback / how to get selectedindexchanged event of dropdown in a gridview In many cases,we nee...
No comments:
Post a Comment