|
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[UploadByTableType]')
AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[UploadByTableType];
GO
IF EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss
ON st.schema_id = ss.schema_id
WHERE st.name = N'TStudentScore' AND ss.name = N'dbo')
DROP TYPE [dbo].[TStudentScore];
GO
CREATE TYPE [dbo].[TStudentScore] AS TABLE(
[ID] [int] NULL,
[Name] [varchar](250) NULL,
[Score] [int] NULL
);
GO
CREATE PROCEDURE dbo.UploadByTableType
@DataInTableType AS TStudentScore READONLY
AS
BEGIN
SELECT * FROM @DataInTableType
END;
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I have been working in the IT industry for some time. It is still exciting and I am still learning. I am a happy and honest person, and I want to be your friend.