Ticker

6/recent/ticker-posts
Showing posts from February, 2018Show All
Delete Duplicate Items in SQL

Delete Duplicate Items in SQL

ASHISH February 18, 2018

Delete LU FROM   (SELECT *,                Row_number()                  OVER (                    partition BY Do…

Create a Dynamic Store Procedure to Pass Table Name as Argument

Create a Dynamic Store Procedure to Pass Table Name as Argument

ASHISH February 18, 2018

Create Proc usp_SelectItems ( @TableName nvarchar(100) ) as begin DECLARE @Sql NVARCHAR(MAX); SET @Sql = N'…

Get the database record count on every table of database

Get the database record count on every table of database

ASHISH February 18, 2018

USE  dbname-- CHANGE THE DATABASE NAME only HERE, I am using dbnamefor example, rest code will as it  is GO SEL…

That is All

Ad Code

Responsive Advertisement