Advertisement
Guest User

Invalid added column

a guest
Jun 30th, 2015
277
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.36 KB | None | 0 0
  1. CREATE TABLE Customers (
  2.         ID INT IDENTITY NOT NULL,
  3.         FirstName NVARCHAR(50) NOT NULL,
  4.         LastName NVARCHAR(50) NOT NULL,
  5.         Manager NVARCHAR(100) NULL
  6.         CONSTRAINT PK_Customers PRIMARY KEY (ID)
  7.         )
  8. GO
  9.  
  10. ALTER TABLE Customers
  11. ADD CustomerDate DATE NULL
  12. GO
  13.  
  14. USE SoftUni
  15. GO
  16. CREATE PROCEDURE usp_NewCustomer
  17.         @FirstName NVARCHAR(50),
  18.         @LastName NVARCHAR(50),
  19.         @Manager NVARCHAR(100),
  20.         @CustomerDate DATE
  21. AS
  22.         INSERT INTO Customers
  23.                 (FirstName, LastName, Manager, CustomerDate) VALUES --INVALID COLUMN NAME DATE?!
  24.                 (@FirstName, @LastName, @Manager, GETDATE())
  25. GO
  26.  
  27. --Recreate the table:
  28.  
  29. DROP TABLE Customers
  30.  
  31. CREATE TABLE Customers (
  32.         ID INT IDENTITY NOT NULL,
  33.         FirstName NVARCHAR(50) NOT NULL,
  34.         LastName NVARCHAR(50) NOT NULL,
  35.         Manager NVARCHAR(100) NULL,
  36.         CustomerDate DATE NULL
  37.         CONSTRAINT PK_Customers PRIMARY KEY (ID)
  38.         )
  39. GO
  40.        
  41. USE SoftUni
  42. GO
  43. ALTER PROCEDURE usp_NewCustomer
  44.         @FirstName NVARCHAR(50),
  45.         @LastName NVARCHAR(50),
  46.         @Manager NVARCHAR(100),
  47.         @CustomerDate DATE
  48. AS
  49.         INSERT INTO Customers
  50.                 (FirstName, LastName, Manager, CustomerDate) VALUES --Now Date is valid, why?
  51.                 (@FirstName, @LastName, @Manager, GETDATE())
  52. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement