SELECT value, label, COD_CDC, ATTIVO FROM dbo.v_selUtentiAll DELETE FROM [dbo].[UTENTE] WHERE (((@IsNull_DOMINIO = 1 AND [DOMINIO] IS NULL) OR ([DOMINIO] = @Original_DOMINIO)) AND ([USER_NAME] = @Original_USER_NAME) AND ((@IsNull_COGNOME = 1 AND [COGNOME] IS NULL) OR ([COGNOME] = @Original_COGNOME)) AND ((@IsNull_NOME = 1 AND [NOME] IS NULL) OR ([NOME] = @Original_NOME)) AND ((@IsNull_COD_SOCIETA = 1 AND [COD_SOCIETA] IS NULL) OR ([COD_SOCIETA] = @Original_COD_SOCIETA)) AND ((@IsNull_MATRICOLA = 1 AND [MATRICOLA] IS NULL) OR ([MATRICOLA] = @Original_MATRICOLA)) AND ((@IsNull_COD_CDC = 1 AND [COD_CDC] IS NULL) OR ([COD_CDC] = @Original_COD_CDC)) AND ((@IsNull_EMAIL = 1 AND [EMAIL] IS NULL) OR ([EMAIL] = @Original_EMAIL)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_COD_LINGUA = 1 AND [COD_LINGUA] IS NULL) OR ([COD_LINGUA] = @Original_COD_LINGUA)) AND ((@IsNull_ATTIVO = 1 AND [ATTIVO] IS NULL) OR ([ATTIVO] = @Original_ATTIVO))) INSERT INTO [dbo].[UTENTE] ([DOMINIO], [USER_NAME], [COGNOME], [NOME], [COD_SOCIETA], [MATRICOLA], [COD_CDC], [EMAIL], [SIGLA], [COD_LINGUA], [ATTIVO]) VALUES (@DOMINIO, @USER_NAME, @COGNOME, @NOME, @COD_SOCIETA, @MATRICOLA, @COD_CDC, @EMAIL, @SIGLA, @COD_LINGUA, @ATTIVO); SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO FROM UTENTE WHERE (USER_NAME = @USER_NAME) SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO FROM dbo.UTENTE UPDATE [dbo].[UTENTE] SET [DOMINIO] = @DOMINIO, [USER_NAME] = @USER_NAME, [COGNOME] = @COGNOME, [NOME] = @NOME, [COD_SOCIETA] = @COD_SOCIETA, [MATRICOLA] = @MATRICOLA, [COD_CDC] = @COD_CDC, [EMAIL] = @EMAIL, [SIGLA] = @SIGLA, [COD_LINGUA] = @COD_LINGUA, [ATTIVO] = @ATTIVO WHERE (((@IsNull_DOMINIO = 1 AND [DOMINIO] IS NULL) OR ([DOMINIO] = @Original_DOMINIO)) AND ([USER_NAME] = @Original_USER_NAME) AND ((@IsNull_COGNOME = 1 AND [COGNOME] IS NULL) OR ([COGNOME] = @Original_COGNOME)) AND ((@IsNull_NOME = 1 AND [NOME] IS NULL) OR ([NOME] = @Original_NOME)) AND ((@IsNull_COD_SOCIETA = 1 AND [COD_SOCIETA] IS NULL) OR ([COD_SOCIETA] = @Original_COD_SOCIETA)) AND ((@IsNull_MATRICOLA = 1 AND [MATRICOLA] IS NULL) OR ([MATRICOLA] = @Original_MATRICOLA)) AND ((@IsNull_COD_CDC = 1 AND [COD_CDC] IS NULL) OR ([COD_CDC] = @Original_COD_CDC)) AND ((@IsNull_EMAIL = 1 AND [EMAIL] IS NULL) OR ([EMAIL] = @Original_EMAIL)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_COD_LINGUA = 1 AND [COD_LINGUA] IS NULL) OR ([COD_LINGUA] = @Original_COD_LINGUA)) AND ((@IsNull_ATTIVO = 1 AND [ATTIVO] IS NULL) OR ([ATTIVO] = @Original_ATTIVO))); SELECT DOMINIO, USER_NAME, COGNOME, NOME, COD_SOCIETA, MATRICOLA, COD_CDC, EMAIL, SIGLA, COD_LINGUA, ATTIVO FROM UTENTE WHERE (USER_NAME = @USER_NAME) SELECT * FROM Utente WHERE (USER_NAME = @USER_NAME) SELECT value, label, COD_CDC, ATTIVO FROM dbo.v_selUtentiShortAD SELECT value, label, COD_CDC, ATTIVO FROM dbo.v_selUtentiShortAD where value=@value SELECT value, label, conditio FROM dbo.v_selFiltri dbo.stp_VSF_getByCond dbo.stp_VSF_getByUrl SELECT value, label FROM dbo.v_selTipoEvento SELECT Data FROM dbo.v_dateEsecuzione dbo.stp_dateProxScadenze SELECT value, label, conditio FROM dbo.v_selStati SELECT value, label, conditio FROM dbo.v_selStati where conditio=@conditio dbo.stp_selStatiMinMax SELECT value, label FROM dbo.v_selClienti SELECT value, label FROM dbo.v_selTipoMappa SELECT value, label FROM dbo.v_selAnagLav SELECT value, label FROM dbo.v_selSetObj