daily pastebin goal
42%
SHARE
TWEET

Untitled

a guest May 16th, 2018 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE PROC pCreate_DBQuery
  2. (
  3.    @Message varchar(max),
  4.    @DateTime smalldatetime
  5. )
  6. AS
  7. BEGIN
  8.     INSERT INTO dbo.TestTbl(Message, DateTime)
  9.     VALUES (@Message, @DateTime)
  10.     SELECT ISNULL( REPLACE(@DateTime,NULL,''),'') AS [Changed Date]
  11.     SELECT SCOPE_IDENTITY()
  12. END
  13.    
  14. EXEC pCreate_DBQuery 'None', NULL
  15.    
  16. None, NULL
  17.    
  18. INSERT INTO dbo.TestTbl(Message, DateTime)
  19. VALUES (@Message, @DateTime)
  20. SELECT ISNULL(@DateTime,'19000101') AS [Changed Date];
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top