Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE #TestTable (ObjectPath nvarchar(100), ClassName nvarchar(100))
- insert into #TestTable
- values
- ('\\wgb2012r2-2\ShareForCS','Tiny (0-10kb)'),
- ('\\wgb2012r2-2\ShareForCS' ,'Large (1-16Mb)'),
- ('\\wgb2012r2-2\ShareForCS' ,'Huge (16-128Mb)'),
- ('\\wgb2012r2-2\ShareForCS' ,'Text'),
- ('\\wgb2012r2-2\ShareForCS' ,'English'),
- ('\\wgb2012r2-2\ShareForCS' ,'Spanish'),
- ('\\wgb2012r2-2\ShareForCS' ,'Turkish'),
- ('\\wgb2012r2-2\ShareForCS' ,'Breton'),
- ('\\wgb2012r2-2\ShareForCS' ,'Credit Cards'),
- ('\\wgb2012r2-2\ShareForCS', 'VISA'),
- ('\\wgb2012r2-2\ShareForCS', 'Social Security Number'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'Tiny (0-10kb)'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'Text'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt' ,'English'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'Credit Cards'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 001.txt', 'VISA'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Large (1-16Mb)'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Text'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Spanish'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt' ,'Credit Cards'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'VISA'),
- ('\\wgb2012r2-2\ShareForCS\CreditCard 002.txt', 'Social Security Number'),
- ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt' ,'Tiny (0-10kb)'),
- ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt', 'Text'),
- ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt', 'English'),
- ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt', 'Credit Cards'),
- ('\\wgb2012r2-2\ShareForCS\Numero Uno.txt' ,'VISA'),
- ('\\wgb2012r2-2\ShareForCS\Numero Duo.txt', 'Tiny (0-10kb)'),
- ('\\wgb2012r2-2\ShareForCS\Numero Duo.txt' ,'Text'),
- ('\\wgb2012r2-2\ShareForCS\Numero Duo.txt' ,'Turkish'),
- ('\\wgb2012r2-2\ShareForCS\New file.txt Huge', '(16-128Mb)'),
- ('\\wgb2012r2-2\ShareForCS\New file.txt' ,'Text'),
- ('\\wgb2012r2-2\ShareForCS\New file.txt', 'Breton'),
- ('\\wgb2012r2-2\ShareForCS\New file.txt', 'Social Security Number')
- Select * from #TestTable
- drop table #TestTable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement