Advertisement
NickProskuryakov

Untitled

Jan 19th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1.  
  2. CREATE TABLE #TestTable (ObjectPath nvarchar(100), ClassName nvarchar(100))
  3.  
  4. insert into #TestTable
  5. values
  6. ('\\wgb2012r2-2\ShareForCS','Tiny (0-10kb)'),
  7. ('\\wgb2012r2-2\ShareForCS' ,'Large (1-16Mb)'),
  8. ('\\wgb2012r2-2\ShareForCS' ,'Huge (16-128Mb)'),
  9. ('\\wgb2012r2-2\ShareForCS' ,'Text'),
  10. ('\\wgb2012r2-2\ShareForCS' ,'English'),
  11. ('\\wgb2012r2-2\ShareForCS' ,'Spanish'),
  12. ('\\wgb2012r2-2\ShareForCS' ,'Turkish'),
  13. ('\\wgb2012r2-2\ShareForCS' ,'Breton'),
  14. ('\\wgb2012r2-2\ShareForCS' ,'Credit Cards'),
  15. ('\\wgb2012r2-2\ShareForCS', 'VISA'),
  16. ('\\wgb2012r2-2\ShareForCS', 'Social Security Number'),
  17. ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'Tiny (0-10kb)'),
  18. ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'Text'),
  19. ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt' ,'English'),
  20. ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'Credit Cards'),
  21. ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'VISA'),
  22. ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Large (1-16Mb)'),
  23. ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Text'),
  24. ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Spanish'),
  25. ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt' ,'Credit Cards'),
  26. ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'VISA'),
  27. ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Social Security Number'),
  28. ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt' ,'Tiny (0-10kb)'),
  29. ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt', 'Text'),
  30. ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt', 'English'),
  31. ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt', 'Credit Cards'),
  32. ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt' ,'VISA'),
  33. ('\\wgb2012r2-2\ShareForCS\Numero Duo.txt', 'Tiny (0-10kb)'),
  34. ('\\wgb2012r2-2\ShareForCS\Numero Duo.txt' ,'Text'),
  35. ('\\wgb2012r2-2\ShareForCS\Numero Duo.txt' ,'Turkish'),
  36. ('\\wgb2012r2-2\ShareForCS\New file.txt Huge', '(16-128Mb)'),
  37. ('\\wgb2012r2-2\ShareForCS\New file.txt' ,'Text'),
  38. ('\\wgb2012r2-2\ShareForCS\New file.txt', 'Breton'),
  39. ('\\wgb2012r2-2\ShareForCS\New file.txt', 'Social Security Number')
  40.  
  41. Select * from #TestTable
  42.  
  43. drop table #TestTable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement