Skip to main content

drop table if exists in SQL Server

This is basically used for drop table using if exists in sql server. The example as given below. 


IF OBJECT_ID('TEMPDB..#SPLETEDTEMPTABLE') IS NOT NULL 
    DROP TABLE #SPLETEDTEMPTABLE


CREATE TABLE #SPLETEDTEMPTABLE(ID INT, SERVICES VARCHAR(300))


INSERT INTO #SPLETEDTEMPTABLE EXEC GET_SPLITED_TABLE 'Anil Singh India', '-'





























Labels


















Labels:
































 By Anil Singh  | Rating of this article (*****) 




Popular posts from this blog



















List of Countries, Nationalities and their Code In Excel File






















 Download JSON file for this List - Click on JSON file      Countries List, Nationalities and Code Excel       ID      Country      Country   Code      Nationality      Person         1      UNITED   KINGDOM      GB      British      a   Briton         2      ARGENTINA      AR      Argentinian      an   Argentinian         3      AUSTRALIA      AU      Australian      an   Australian         4      BAHAMAS      BS      Bahamian      a   Bahamian         5      BELGIUM      BE      Belgian      a   Belgian         6      BRAZIL      BR      Brazilian      a   Brazilian         7      CANADA      CA      Canadian      a   Canadian         8      CHINA      CN      Chinese      a   Chinese         9      COLOMBIA      CO      Colombian      a   Colombian         10      CUBA      CU      Cuban      a   Cuban         11      DOMINICAN   REPUBLIC      DO      Dominican      a   Dominican         12      ECUADOR      EC      Ecuadorean      an   Ecuadorean         13      EL   SALVA...

























Read more






























 nullinjectorerror no provider for httpclient angular 17






















In Angular 17 where the standalone true option is set by default, the app.config.ts  file is generated in src/app/ and provideHttpClient(). We can be added to the list of providers in app.config.ts Step 1:   To provide HttpClient in a standalone app we could do this in the app.config.ts  file, app.config.ts: import { ApplicationConfig } from '@angular/core'; import { provideRouter } from '@angular/router'; import { routes } from './app.routes'; import { provideClientHydration } from '@angular/platform-browser'; //This (provideHttpClient) will help us to resolve the issue  import {provideHttpClient} from '@angular/common/http'; export const appConfig: ApplicationConfig = {   providers: [ 	 provideRouter(routes),  	 provideClientHydration(), 	 provideHttpClient ()      ] }; The appConfig const is used in the main.ts file, see the code, main.ts : import { bootstrapApplication } from '@angular/platform-browser'; import { appConfig } from ...

























Read more






























51 Best React Interview Questions and Answers






















 1) What Is React?   React is a fast, open-source, and front-end JavaScript library and It was developed by Facebook in 2011 for building complex, stateful and interactive UI in web as well as mobile Applications.     React follows the component based approach which helps you to building reusable and interactive web and mobile user interface (UI) components.   React has one of the largest communities supporting it.     The high level component Lifecycle  -   At the highest level component Lifecycle, React components have lifecycle events  that are -   1.       Initialization   2.       State/Property Updates   3.       Destruction      Explore to detail understanding   -  React Lifecycle Components   Reactjs is very fast technology that can be trusted for complex tasks and can simply be trusted for quality outcomes.     2) When Reactjs released?   March 2013     3) What Is the current stable version of ...

























Read more






























Top 15+ Angular 17 Interview Questions Answers | For Experienced Professionals as well






















G Google team released the latest version of Angular – Angular 17 on November 6, 2023, creating a significant milestone for the super fast front-end development. What Are the New Features in Angular 17? 1.       Angular 17 is the highly anticipated release for the community, bringing many new exciting features, updates, and improvements. 2.       New Syntax for Control Flow in Templates - new @if, @switch, @for, @case, @empty @end control flow syntax 3.       Deferred Loading - @defer partial template 4.       The Angular signals API 5.       Angular SSR and client hydration 6.       Automatic Migration to Build-in Control Flow 7.       Build Performance with ESBuild 8.       By default, set this newly generated component as a standalone, and now we don't have an app module file. To use (ng...

























Read more




























39 Best Object Oriented JavaScript Interview Questions and Answers






















  Most Popular 37 Key Questions for JavaScript Interviews.                What is Object in JavaScript?              What is the Prototype object in JavaScript and how it is used?                        What is "this"? What is its value?              Explain why "self" is needed instead of "this".                        What is a Closure and why are they so useful to us?              Explain how to write class methods vs. instance methods.                        Can you explain the difference between == and ===?              Can you explain the difference between call and apply?                        Explain why Asynchronous code is important in JavaScript?              Can you please tell me a story about JavaScript performance problems?                        Tell me your JavaScript Naming Convention?              How do you define a class and its constructor?                        What is Hoisted in JavaScript?              What is function overloadin...

























Read more