Database

ALTER PROCEDURE dbo.SP_SearchByUserNeed
(
    @ColumnName varchar(20),
    @Value varchar(100)
)
AS
BEGIN
DECLARE @RealColumnName sysname;
DECLARE @Statement nvarchar(max);
    
    -- Validate the column name:
    SELECT
        @RealColumnName = name
    FROM
        sys.columns
    WHERE
        object_id = OBJECT_ID('Product')
    And
        name = @ColumnName
    ;
    
    If @RealColumnName Is Null
    BEGIN
        RAISERROR('Unknown column: "%s"', 16, 1, @ColumnName);
        Return;
    END;
    
    SET @Statement = N'SELECT * FROM Product WHERE ' + QuoteName(@RealColumnName) + N' Like @Value + ''%''';
    EXEC sp_executesql @Statement, N'@Value varchar(100)', @Value;
END

exec sp_stored_procedures @sp_owner = 'dbo'

SELECT *
   FROM sys.fn_dblog(NULL,NULL)

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Schatak wrote:

seems to be good and new thing

Schatak wrote:

big for sure, data would be like more documents, images , videos . And performance of product is the key, they need fast retivals of docs, images and all.

Schatak wrote:

I am going to start a big construction project with MVC. I am confused about Db
choice.

Schatak wrote:

Although worked with SQL server from past 5 years. but now thinking to use
MongoDB.

• You could postpone the choice of which database-class to use by programming against the IDbConnection interface.
  
• Inject any database-driver in there
  
• And if you keep your SQL compatible with SQL92, then any database supporting the standard could be used.
  

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

I cannot determine whether or not MongoDB supports SQL92