Sql – How should I get stored procedure result set in sql server 2005

sql-server

I have a stored procedure that named globalsearch. the stored procedure return some results. the problem is how should I get results that is returned stored procedure in sql server 2005.thanks!

Best Solution

If you're asking how to get the result of a procedure from another procedure, the only way is to capture it into a table insert. See this article on MSDN covering the subject in detail: Getting Creative with EXEC.

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

SQL Server 2005 onwards:

IF EXISTS(SELECT 1 FROM sys.columns 
          WHERE Name = N'columnName'
          AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
    -- Column Exists
END

Martin Smith's version is shorter:

IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
    -- Column Exists
END

Sql-server – Check if table exists in SQL Server

For queries like this it is always best to use an INFORMATION_SCHEMA view. These views are (mostly) standard across many different databases and rarely change from version to version.

To check if a table exists use:

IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'TheSchema' 
                 AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

Best Solution

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

Sql-server – Check if table exists in SQL Server

Related Question