Dynamically Select, Insert, Update, Delete In Sql Server

 DECLARE

@TYPE VARCHAR(50)='',

@TABLENAME VARCHAR(100)=NULL,

@FIELDS VARCHAR(max)='',

@CRITERIA VARCHAR(max)=NULL

 BEGIN 

DECLARE @QUERY VARCHAR(8000) 

IF @TYPE='SELECT'

BEGIN

SET @Query=' SELECT ' + CASE WHEN ( @FIELDS <> '' AND @FIELDS IS NOT NULL) THEN @FIELDS ELSE '*' END 

SET @Query=@Query + ' FROM ' 

SET @Query=@Query + @TABLENAME 

SET @Query=@Query + ' WHERE 1 = 1 ' 

SET @Query=@Query + CASE WHEN (@CRITERIA <> '' AND @CRITERIA IS NOT NULL) THEN @CRITERIA ELSE '' END 

EXEC(@Query)

END

IF @TYPE='INSERT'

BEGIN

SET @Query = 'INSERT INTO '+ @TABLENAME + ' (' + @FIELDS + ') VALUES (' + @CRITERIA + ')'  

EXEC(@Query)

END

IF @TYPE='UPDATE'

BEGIN

SET @QUERY = '

UPDATE ' + @TABLENAME + ' 

SET ' + @FIELDS + ' 

WHERE 1 = 1 ' + @CRITERIA 

EXEC(@QUERY)

END

IF @TYPE='DELETE'

BEGIN

    SET @QUERY = ' DELETE FROM ' + @TABLENAME + ' WHERE 1 = 1 ' + @CRITERIA

EXEC(@QUERY)

END

 END

   

GO

Map A Database Table From a TableDataContext For A Linq Query ...

TableDataContext _TableDataContext = new TableDataContext();

DATABASETABLE _DB = _TableDataContext.DATABASETABLEs.SingleOrDefault((DATABASETABLE p) => p.PDH_ID == Convert.ToInt32(txtValue.Text));

if (_DB == null)

{

_DB = new DATABASETABLE();

        _TableDataContext.DATABASETABLEs.InsertOnSubmit(_DB);

}

_DB.ID = Convert.ToInt32(txtId.Text);

_DB.VALUE = Convert.ToInt32(txtValue.Text);

_TableDataContext.SubmitChanges();

How To Start/Stop Windows Service With Task Scheduler Windows System

net stop RapDownloadService

net start RapDownloadService

How to Call Query in Batch File Windows

 sqlcmd -S DB\SQLEXPRESS -d DBNAME -E -Q "QUERY HERE" -s "," -o "C:\Users\User\Desktop\Export.txt"

How to call procedure in task scheduler in windows

 sqlcmd -Q "exec SP_Test" -S DC_SRVR\SQLEXPRESS -d DBNAME -U sa -P PASSWORD -o path\yourOutput.txt

Generate Sql Table All Columns In Comma Separated List In Sql Server

ALTER FUNCTION [dbo].[ReturnTableCommaSeparted]
(
    @TABLENAME VARCHAR(max) = 'table_name'
)
RETURNS @RETURN_LIST TABLE
(
    TABLE_SCHEMA VARCHAR(MAX) NOT NULL,
    TABLE_NAME VARCHAR(MAX) NOT NULL,
    Columns_List VARCHAR(MAX) NOT NULL
)
AS
BEGIN
    INSERT INTO @RETURN_LIST
    (
        TABLE_SCHEMA,
        TABLE_NAME,
        Columns_List
    )
    SELECT TABLE_SCHEMA,
           TABLE_NAME,
           'SELECT ' + STUFF(
                       (
                           SELECT ', ' + C.COLUMN_NAME
                           FROM INFORMATION_SCHEMA.COLUMNS AS C
                           WHERE C.TABLE_SCHEMA = T.TABLE_SCHEMA
                                 AND C.TABLE_NAME = T.TABLE_NAME
                           ORDER BY C.ORDINAL_POSITION
                           FOR XML PATH('')
                       ),
                       1,
                       2,
                       ''
                            ) 
+ ' FROM ' + T.TABLE_NAME + ' WITH(NOLOCK) ' AS Columns_List
    FROM INFORMATION_SCHEMA.TABLES AS T
    WHERE (
              @TABLENAME = ''
              OR T.TABLE_NAME = @TABLENAME
          );
    RETURN;

END;

Query To Access Column Description In Sql Server

 DECLARE @TableName VARCHAR(MAX)='Constant'
SELECT 
        st.name [Table],
        sc.name [Column],
        sep.value [Description]
    from sys.tables st
    inner join sys.columns sc on st.object_id = sc.object_id
    left join sys.extended_properties sep on st.object_id = sep.major_id
                                         and sc.column_id = sep.minor_id
                                         and sep.name = 'MS_Description'
    where st.name = @TableName