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 2005 Forums
 Transact-SQL (2005)
 Regular expression to retrieve the query fields

Author  Topic 

samsqlteam
Starting Member

2 Posts

Posted - 2010-01-12 : 19:01:55
I need to extract from .net app, the dynamic sql "select" query's all selected columns...is there an easy regularexpression to achieve this?

Thanks,

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2010-01-12 : 20:30:06
Can you clarify what you are looking for? Perhaps an example with sample data would help to elucidate.

=======================================
Few things are harder to put up with than the annoyance of a good example. (Mark Twain)
Go to Top of Page

samsqlteam
Starting Member

2 Posts

Posted - 2010-01-13 : 00:01:15
The sql statement is "select firstname, lastname, address from client

Then the .net application, should extract "firstname, lastname, address" as a list or a string with the help of regularexpression

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-13 : 01:27:54
do you need a sql query or are you looking for .net code?
Go to Top of Page
   

- Advertisement -