Avoiding IF.. ELSE by using WHERE EXISTS - SQL Server Planet

Avoiding IF.. ELSE by using WHERE EXISTS - SQL Server Planet

瀏覽:961
日期:2024-07-14
I made a example if you want to see: ALTER PROCEDURE [dbo].[USP_getCliente] @id int AS BEGIN SET NOCOUNT ON; — programa começa aqui –verifica se já existe tabela, –se não, cria a tabela e insere o registo, if not exists (SELECT * from sysobjects where nam...看更多