Learn dotnet
Wednesday, 2 May 2018
Run Large(eg: 10gb) script file in MS SQL database
Import/Run large(eg: 10gb) script file in MS SQL database using below command:
1. Open command prompt with Administrator mode
2.
sqlcmd -S ServerName -U UserID -P Password -d DataBaseName -i C:\Users\gprao\Downloads\ProjectTrac\ProjectTrac.sql
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
git rebase command - baseed on master branch to our branch
Message brokers - MSMQ - RabbitMQ - Azure Service Bus
Message brokers: Below are the message service brokers. those are used to store messages and consume the messages and each broker has so...
Sql query using Entity framework in MVC / C#
Sql query using entity framework. In the below example we can use sql query or stored procedure or view. public List<Appointmen...
Difference between IEnumerable and IEnumerator
Difference between IEnumerable and IEnumerator IEnumerable: 1. Make the syntax sorter. 2. IEnumerable uses IEnumerator internally 3. I...