I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

Converting TSQL/C#/VB Code to HTML

you paste the code you want to display on the page and it creates the color coded html. preety cool...

http://www.manoli.net/csharpformat/

there's even a source of the app that does the convert that you can view.

Print | posted on Saturday, April 08, 2006 1:49 PM | Filed Under [ Misc ]

Feedback

Gravatar

# re: Converting TSQL/C#/VB Code to HTML

Good link ... very nice find!
- Jeff
4/11/2006 4:41 PM | Jeff
Gravatar

# re: Converting TSQL/C#/VB Code to HTML

SELECT r.rollout_id,
r.ROLLOUT_TYPE,
r.rollback_from,
r.description,
r.rollout_plan_ticket,
r.parent_rollout_id,
r.machines_so_far,
r.machines_to_roll,
r.HAS_STARTED_ROLLBACK,
r.skip_staging,
r.skip_approval,
r.skip_qa,
r.build_label,
r.force_rollout,
r.train_number,
r.build_number_code,
bd1.code_value as code_tag,
r.build_number_xsl,
bd2.code_value as xsl_tag,
r.TC_ID,
cu.email as conductor_login,
cu.first_name as conductor_f,
cu.last_name as conductor_l,
r.RE_ID,
ru.email as release_login,
ru.first_name as release_f,
ru.last_name as release_l,
r.start_time,
r.include_machine_list,
r.exclude_machine_list,
r.rollout_command,
r.rollback_command,
r.rollout_command2,
r.rollback_command2,
r.rollout_success_match,
r.rollback_success_match,
r.status_id,
rs.status_name,
r.plan_id,
pl.plan_name,
r. pool_id,
p.DELIVERABLE_NAME,
p.cal_pool_name,
p.pool_type_id,
r.LAST_MODIFIED_DATE,
p.staging_timeout,
p.runtask_timeout,
p.odb_name,
p.qa_approval_req,
pt.pool_category,
val.TASK_COMMAND
FROM tr2_build_detail bd1,
tr2_build_detail bd2,
tr2_rollout r,
tr2_rollout_status rs,
tr2_plan pl,
tr2_pool p,
tr2_user cu,
tr2_user ru,
tr2_pool_type pt,
TR2_POOL_TASK val,
TR2_TASK task
WHERE (rs.status_id(+) = r.status_id) AND (pl.plan_id(+) = r.plan_id) AND
(p.pool_id(+) = r.pool_id) AND (cu.user_id = r.TC_ID) AND
(ru.user_id = r.RE_ID) AND
(bd1.build_number(+) = r.build_number_code) AND
(bd2.build_number(+) = r.build_number_xsl) AND
(pt.pool_type_id(+) = p.pool_type_id) AND
(val.pool_id(+) = p.pool_id) AND (task.task_id(+) = val.task_id) AND
(task.task_name = 'ValidateInternals' or task.task_name is null) AND
(r.parent_rollout_id = 0 or r.parent_rollout_id = null) AND
r.status_id =
(select status_id from tr2_rollout_status where status_name = :1) AND
r.start_time > :2 AND cu.email = :3

4/20/2006 2:22 AM | Jay
Gravatar

# re: Converting TSQL/C#/VB Code to HTML

and the point of this select is?
4/20/2006 11:11 AM | Mladen
Gravatar

# re: Converting TSQL/C#/VB Code to HTML

that doesn't work
only thing that happened is to re write the same code no thing happened
is there any problem
10/24/2009 4:22 PM | tareq
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET