ferreira12 Posted October 27, 2015 at 04:37 PM Report Share #589203 Posted October 27, 2015 at 04:37 PM Boas, estou com a seguinte dúvida, o meu select pode não retornar qualquer valor devido ao where, então gostaria que nesses casos que apresentá se uma mensagem. Para isso estou a usar um case. exemplo select Case when teste is null then 'ola' else teste end ( from tabela1 where campo1=23 Será que me poderão ajudar?? Link to comment Share on other sites More sharing options...
PaisNeto Posted October 29, 2015 at 10:25 AM Report Share #589285 Posted October 29, 2015 at 10:25 AM Bom dia, vê se isto te pode ajudar. https://msdn.microsoft.com/pt-br/library/ms175976(v=sql.120).aspx Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now