Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to display these data

Author  Topic 

optimism
Starting Member

1 Post

Posted - 2009-05-16 : 05:20:46
Hello

i have some issues in how to display data in specific format (i am using SQL server 2008 & visual web developer 2008 C#)



- how to display the data input as percentage like this 3%

- i have field which the input should be more than zero (how can i do that, should i do it on the Database or on the visual web developer )

- i want to generate auto unique number for each record like this which start with a letter then numbers , like this G12576

- how can i creat an input mask in SQL for field which contain number & symobls like

this : 1- 00- 260493







thanks ...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-16 : 05:31:39
- you can use formatting function available in visual web developer to achieve this. just bring the quantity as a decimla from db
-Use validation functions in visual web developer to check if entered number > 0 and display warning if not
-create an identity column and another computed column based on this identity column for this. see below for example
http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server
-see this
http://sqlserver2000.databases.aspfaq.com/can-i-implement-an-input-mask-in-sql-server.html
Go to Top of Page
   

- Advertisement -