SHARE
TWEET

Untitled

a guest Jun 18th, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE [dbo].[StatisticsDemo](
  2.     [ID] [int] IDENTITY(1,1) NOT NULL,
  3.     [Name] [nvarchar](50) NULL
  4.    ) ON [PRIMARY]
  5.      
  6. SELECT NAME,COUNT(*) AS COUNT
  7. FROM StatisticsDemo
  8. GROUP BY NAME
  9.  
  10. NAME    COUNT
  11. -------------
  12. AABBCC  59999
  13. XXYYZZ  1
  14.      
  15. CREATE NONCLUSTERED INDEX [NCI_STATISTICSDEMO_NAME] ON [dbo].[StatisticsDemo]
  16. (
  17.     [Name] ASC
  18. )
  19.      
  20. SELECT NAME FROM [dbo].[StatisticsDemo]
  21. WHERE NAME = 'AABBCC'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top