ferreira12 0 Posted October 27, 2015 Report Share Posted October 27, 2015 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 post Share on other sites
PaisNeto 2 Posted October 29, 2015 Report Share Posted October 29, 2015 Bom dia, vê se isto te pode ajudar. https://msdn.microsoft.com/pt-br/library/ms175976(v=sql.120).aspx Link to post Share on other sites
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