| Usuario |
¿Cómo rehacer una DB a partir de l... |
Desconocido
|
| Enviado - 4/10/2004 |
| |
Tengo un interesante código en ASP, pero no tengo la estructura de la DB. ¿Cómo hago para reconstruirlo a partir de los scripts?
Estos son algunos ejemplos:
l_sSQL = "SELECT a.file_ref FROM vp_" & l_sType & " AS a WHERE (" & l_sType & "_id=" & l_iCOID & ");"
l_sSQL = "SELECT a.extension FROM vp_media_type AS a INNER JOIN vp_" & l_sType & " AS b ON a.media_type_id = b.media_type_id WHERE (b." & l_sType & "_id=" & l_iCOID & ");"
Set l_oRS = l_oDBCon.Execute("SELECT page_spot_id, tracking_schema_id, url FROM vp_page_spot WITH (NOLOCK) WHERE track_navigation = 'Y';")
Set l_oRS = l_oDBCon.Execute("SELECT element_id, element_name FROM vp_element WITH (NOLOCK) WHERE element_type = 'session';")
Set l_oRS = l_oDBCon.Execute("SELECT element_id, element_name FROM vp_element WITH (NOLOCK) WHERE element_type = 'techtracking';")
l_sSQL = "SELECT a.pf_id, b.sku FROM vp_document AS b INNER JOIN vp_variant AS a ON b.sku = a.sku WHERE (b.doc_id=" & doc_id & ");"
l_sSQL = "SELECT a.pf_id, b.sku FROM vp_template AS a INNER JOIN vp_variant AS b ON a.pf_id = b.pf_id WHERE (a.template_id=" & tmp_id & ") ORDER BY b.sku;"
l_sSQL = "SELECT a.pf_id, b.sku FROM vp_cd_template AS a INNER JOIN vp_variant AS b ON a.pf_id = b.pf_id WHERE (a.cd_template_id=" & cd_tmp_id & ") ORDER BY b.sku;"
l_sSQL = "SELECT a.pf_id, b.sku FROM vp_papereffect AS a INNER JOIN vp_variant AS b ON a.pf_id = b.pf_id WHERE (a.papereffect_id=" & pe_id & ") ORDER BY b.sku;"
l_sSQL = "SELECT a.pf_id, b.sku FROM vp_design AS a INNER JOIN vp_variant AS b ON a.pf_id = b.pf_id WHERE (a.design_id=" & ds_id & ") ORDER BY b.sku;" |
| |
|
|
|
