Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
Showing error Invalid object name 'INFORMATION_SCHEMA.COLUM'
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Fareeda Hussain
7y
231
1
Reply
When I try to execute the below procedure showing error 'INFORMATION_SCHEMA.COLUM'
create procedure data
(
@tablename varchar(50),
@userid int =''
)
AS
BEGIN
Declare @tsql varchar(50)
IF (@tablename = '')
SELECT * FROM tbl;
--ELSE
BEGIN
set @tsql = 'select Column_name
from INFORMATION_SCHEMA.COLUMNS
where Table_name like '+@tablename
exec(@tsql);
--set @tsql = 'select * from '+@tablename +' where userid ='+@userid
--exec(@tsql);
END
END
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
sql server counts of columns
write trigger after insert to send mail to employeee