SELECT value, label FROM v_selFonti ORDER BY value dbo.stp_Fonti_likeSearch SELECT value, label FROM dbo.v_selCommesse dbo.stp_Commesse_likeSearch SELECT value, label FROM dbo.v_selFasi dbo.stp_Fasi_likeSearch SELECT value, label FROM dbo.v_tbDocs_selCommesse dbo.stp_tbDocs_Commesse_likeSearch SELECT value, label FROM dbo.v_tbDocs_selFasi dbo.stp_tbDocs_Fasi_likeSearch SELECT value, label FROM dbo.v_tbDocs_selFonti dbo.stp_tbDocs_Fonti_likeSearch SELECT value, label FROM dbo.v_tbDocs_selOggetto dbo.stp_tbDocs_Oggetto_likeSearch SELECT value, label FROM dbo.v_selAutori dbo.stp_Autori_likeSearch dbo.stp_calcolaProtocollo SELECT codFornitore, Email FROM dbo.v_selEmailFornitori dbo.stp_EF_byCodFornitore DELETE FROM [AnagSuggestTags] WHERE (([TagAutocomplete] = @Original_TagAutocomplete)) INSERT INTO [AnagSuggestTags] ([TagAutocomplete]) VALUES (@TagAutocomplete); SELECT TagAutocomplete FROM AnagSuggestTags WHERE (TagAutocomplete = @TagAutocomplete) ORDER BY TagAutocomplete SELECT TagAutocomplete FROM AnagSuggestTags ORDER BY TagAutocomplete UPDATE [AnagSuggestTags] SET [TagAutocomplete] = @TagAutocomplete WHERE (([TagAutocomplete] = @Original_TagAutocomplete)); SELECT TagAutocomplete FROM AnagSuggestTags WHERE (TagAutocomplete = @TagAutocomplete) ORDER BY TagAutocomplete dbo.stp_AST_likeSearch SELECT value, label FROM dbo.v_tbDocs_selRedattore dbo.stp_tbDocs_Redattore_likeSearch SELECT value, label, conditio FROM dbo.v_selTMD dbo.stp_selTDM_byConditio SELECT value, label, Telefono, Fax, Email FROM dbo.v_selFonti_expl dbo.stp_VSFE_getByFonte DELETE FROM [dbo].[ElencoOpzioni] WHERE (([CodTipo] = @Original_CodTipo) AND ([ordine] = @Original_ordine) AND ((@IsNull_opzione = 1 AND [opzione] IS NULL) OR ([opzione] = @Original_opzione))) INSERT INTO [dbo].[ElencoOpzioni] ([CodTipo], [ordine], [opzione]) VALUES (@CodTipo, @ordine, @opzione); SELECT CodTipo, ordine, opzione FROM ElencoOpzioni WHERE (CodTipo = @CodTipo) AND (ordine = @ordine) SELECT CodTipo, ordine, opzione FROM dbo.ElencoOpzioni UPDATE [dbo].[ElencoOpzioni] SET [CodTipo] = @CodTipo, [ordine] = @ordine, [opzione] = @opzione WHERE (([CodTipo] = @Original_CodTipo) AND ([ordine] = @Original_ordine) AND ((@IsNull_opzione = 1 AND [opzione] IS NULL) OR ([opzione] = @Original_opzione))); SELECT CodTipo, ordine, opzione FROM ElencoOpzioni WHERE (CodTipo = @CodTipo) AND (ordine = @ordine) dbo.stp_EO_getByTipo