Bikash Kumar Ray

SQL and ASP.net Related Practical Problems

Tuesday, June 30, 2009

Generate a Random Number

Run this qry in SQL :

declare @random varchar(50)
set @random = newid()
print (@random)
select substring(@random,1, 16)
Posted by Unknown at 3:55 AM

1 comment:

Varun Bhagat said...

i do not agree with this.... to do sustring a random number is not a right approach

July 25, 2009 at 5:52 PM

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Details

  • ►  2013 (6)
    • ►  November (1)
    • ►  June (1)
    • ►  February (4)
  • ►  2012 (4)
    • ►  October (1)
    • ►  May (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2011 (9)
    • ►  December (1)
    • ►  November (1)
    • ►  September (1)
    • ►  July (1)
    • ►  May (1)
    • ►  April (4)
  • ►  2010 (13)
    • ►  September (1)
    • ►  August (5)
    • ►  July (2)
    • ►  May (1)
    • ►  February (4)
  • ▼  2009 (38)
    • ►  December (5)
    • ►  November (4)
    • ►  October (2)
    • ►  September (3)
    • ►  August (4)
    • ►  July (5)
    • ▼  June (6)
      • Generate a Random Number
      • Difference Between DDL, DML, DCL and TCL
      • Clear the Controls Data on Click of Reset Button
      • Change Color Of Gridview On Mouse-Over
      • Gridview Selected index change
      • Show Gridview Row in Red Color on the basis of Inn...
    • ►  May (3)
    • ►  April (6)

Worked Websites

  • eDMS
  • Plyreporter
  • Tour and Travel Website
  • Tradeget
Ethereal theme. Powered by Blogger.