Need to edge out the competition for your dream job? Train for certifications today.
create table testTable
A BIGINT IDENTITY(1,1), Data VARCHAR(100) NULL
INSERT INTO testTable(data) values('1');
INSERT INTO testTable(data) values('10');
INSERT INTO testTable(data) values('20');
INSERT INTO testTable(data) values('30');
Open in new window
CREATE FUNCTION dbo.paramViewTestTable
SELECT * from testTable WHERE data= @paramData
select * FROM dbo.paramViewTestTable('30')
The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.