Cursor, drop all tables,views, procedures

USE LRRV6Portal

GO

--SELECT name

--FROM sys.Tables

--GO

  DECLARE @name nvarchar(50); 

   DECLARE tableCursor CURSOR FOR

       SELECT name

FROM sys.Tables

 

  OPEN tableCursor

 

  FETCH NEXT FROM tableCursor into @name

 

  WHILE @@FETCH_STATUS = 0

  BEGIN

  

  

 

         PRINT @name

        

        exec( 'drop table "'+@name+'"');

    FETCH NEXT FROM tableCursor into @name

  end   

  CLOSE tableCursor;

  DEALLOCATE tableCursor;

  go

------------

 DECLARE @name nvarchar(50);
   DECLARE viewCursor CURSOR FOR
       SELECT name
FROM sys.views

  OPEN viewCursor

  FETCH NEXT FROM viewCursor into @name

  WHILE @@FETCH_STATUS = 0
  BEGIN
 
 

         PRINT @name
       
        exec( 'drop view "'+@name+'"');

    FETCH NEXT FROM viewCursor into @name

  end  
  CLOSE viewCursor;
  DEALLOCATE viewCursor;
  go

----------

 DECLARE @name nvarchar(50);
   DECLARE procedCursor CURSOR FOR
       SELECT name
FROM sys.procedures

  OPEN procedCursor

  FETCH NEXT FROM procedCursor into @name

  WHILE @@FETCH_STATUS = 0
  BEGIN
 
 

         PRINT @name
       
        exec( 'drop procedure "'+@name+'"');

    FETCH NEXT FROM procedCursor into @name

  end  
  CLOSE procedCursor;
  DEALLOCATE procedCursor;
  go

SQL WHILE Begin End

USE CommunityUseOfPublicSchools;





DECLARE @name VARCHAR(MAX);
DECLARE @sql VARCHAR(MAX);



DECLARE table_cursor CURSOR FOR
SELECT  ST.name FROM sys.tables ST



OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN

SET @sql= 'drop table "'+@name+'" ';
EXECUTE(@sql);

FETCH NEXT FROM table_cursor INTO @name
END
CLOSE table_cursor
 DEALLOCATE table_cursor

Discover query for SSAS server

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>MDSCHEMA_CUBESRequestType>
  <Restrictions />
  <Properties>
    <PropertyList>
      <Catalog>Adventure Works DWCatalog>
    PropertyList>
  Properties>
Discover>

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
   <RequestType>DBSCHEMA_CATALOGSRequestType>
   <Restrictions />
   <Properties />
Discover>

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>MDSCHEMA_CUBESRequestType>
  <Restrictions />
  <Properties />Discover>


 
 

SQL 2008

Case
org_type =
CASE org_type
WHEN 'OTHER' THEN 'OTHERS'
WHEN 'M' THEN 'Mountain'
WHEN 'T' THEN 'Touring'
WHEN 'S' THEN 'Other sale items'
ELSE org_type
END


 getting last word has '\'
Select RIGHT(UploadPhysicalPath, CHARINDEX ('\',REVERSE (UploadPhysicalPath))-1),UploadPhysicalPath
  FROM [CLProjects].[dbo].[tbl_Projects]