Views: 838 SQLContent
How to configure SQL Server 2014 to accept remote connections over TCP/IP using SQL Server Configuration Manager, open the port on firewall for incoming connection. Enable Remote Connection to SQL Server, Allow remote connections to SQL Server, Configure SQL Server to Allow Network Connections How to Enable Remote Connection to SQL Server is a Solution for Error: 40 How to configure SQL server 2014 (SQL server 2012) on network How to configuration in SQL Server 2014 (SQL server 2012) How to Configure SQL Server 2014 (SQL Server 2012) to Allow Network Connections Resolving SQL Server Connection Error 26 Configuring SQL Server 2014 (SQL Server 2012) Remote Access Allowing SQL Server 2014 (SQL Server 2012) external connections Allow remote connections to SQL Server 2014 (SQL Server 2012) : How to Video Fix error Cannot Connect to Server (SQL Server) Configuring MSSQL 2014 (MSSQL 2012) Server to Access Database via Network using SQL Server Authentication SQL Server Configuration Manager Options in SQL Server Named Pipes Provider, error: 40 --Could not open a connection to SQL Server Microsoft SQL Server Configure (Server - Client) SQL Server 2014 (SQL Server 2012) offer Network TCP/IP Microsoft SqlServer 2014 (SQL Server 2012) TCP/IP settings
Views: 49855 Fox Learn
http://www.learningsqlserver2008.com/ In this sql server tutorial, we show you how to configure and use sqlcmd (formerly osql) in SQL Server 2008 using the wizard. Next in this SQL Server Training, we show you examples of using sqlcmd including returning data and working with input/output files an email using the mail account we just created
Views: 29212 baghul
SQL Server Database Backup and Restore using Command Prompt
Views: 10568 studywithdemo
Restoring Master Db backup the master database stop all the service except sql server . 1.keep the sql server in single user mode add -m in startup parameters in startup optionn 2.open command prompt sqlcmd named instance 3.type command restore database master from disk= with replace then type go
Views: 1045 All Videos
This week's episode of Data Exposed welcomes Abhi Abhishek to the show! Abhi is a Software Engineer in the SQL Server engineering group focusing on SQL Tools. Today he is in the studio to talk about mssql-cli, a new open source and cross-platform command line tool for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. In this session, Abhi talks about the history of mssql-cli by forking pgcli, along with mssql-cli features including: Syntax Highlighting Intellisense Output formatting w/ horizontal paging Multi-line mode Join suggestions Special Commands History management To learn more or install mssql-cli, visit our Github at https://github.com/dbcli/mssql-cli. For any feature requests or issues, please report on our Github Issues page https://github.com/dbcli/mssql-cli/issues You can follow us on Twitter @sqldatatools Create a Free Account (Azure): https://aka.ms/azft-sql
Views: 906 Microsoft Developer
Select Count Record from Table SQL Server with Query Condition Command Line Management Studio
Views: 99 Saidah Faulia
Agenda of this video is to show hot to query SQL Data Service using command line option (infacmd.sh)
Views: 605 Informatica Support
Discussion of Temporary Tables and persistence and how it differs between the TSQL Command Line and within STORED PROCEDURES. Temp tables are persistent, but can exist for very short amounts of time (like some man- made elements).
Views: 211 Dave Merton
Discussion of Table Variables in TSQL Command Line and how to create its own IDENTITY column. This is a very powerful programming technique, especially if you are looping through a table variable's records. However, you have to understand a few of the tricks that are involved with this type of table variable defining and populating. Table Variables are extremely useful and in some cases are a much better choice than Temporary Tables.
Views: 459 Dave Merton
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/exec-vs-spexecutesql-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/exec-vs-spexecutesql-in-sql-server_18.html Dot Net & SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd In this video we will discuss the difference between exec and sp_executesql. In SQL Servere we have 2 options to execute dynamic sql 1. Exec/Execute 2. sp_executesql We discussed sp_executesql in detail in Part 138 of SQL Server tutorial. Please check out that video if you are new to sp_executesql. If you do a quick search on the internet for the difference between exec and sp_executesql, you will see that many articles on the web states using exec over sp_executesql will have the following 2 problems 1. It open doors for sql injection attacks 2. Cached query plans may not be reused and leads to poor performance This is generally true, but if you use QUOTENAME() function you can avoid sql injection attacks and with sql server auto-parameterisation capability the cached query plans can be reused so performance is also not an issue. Let's understand these with examples. What is exec() in SQL Server Exec() or Execute() function is used to execute dynamic sql and has only one parameter i.e the dynamic sql statement you want to execute. As you can see in the example below, we are concatenating strings to build dynamic sql statements which open doors for sql injection. Declare @FN nvarchar(50) Set @FN = 'John' Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where FirstName = ''' + @FN + '''' Exec(@sql) If we set @FN parameter to something like below, it drops SalesDB database Declare @FN nvarchar(50) Set @FN = ''' Drop Database SalesDB --''' Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where FirstName = ''' + @FN + '''' Exec(@sql) However, we can prevent SQL injection using the QUOTENAME() function as shown below. Declare @FN nvarchar(50) Set @FN = ''' Drop Database SalesDB --''' Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where FirstName = ' + QUOTENAME(@FN,'''') --Print @sql Exec(@sql) Notice with the quotename function we are using a single quote as a delimiter. With the use of this function if there is a single quote in the user input it is doubled. For example, if we set @FN='John', notice the string 'John' is wrapped in single quotes Declare @FN nvarchar(50) Set @FN = 'John' Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where FirstName = ' + QUOTENAME(@FN,'''') Print @sql When the above query is executed the following is the query printed Select * from Employees where FirstName = 'John' Along the same lines, if we try to inject sql, QUOTENAME() function wraps all that input in another pair of single quotes treating it as a value for the FirstName column and prevents SQL injection. With sql server auto-parameterisation capability the cached query plans can be reused. SQL Server can detect parameter values and create parameterised queries on its own, even if you don't explicitly declare them. However, there are exceptions to this. Auto-parameterisation comes in 2 flavours - Simple and Forced. We will discuss auto-parameterisation in detail in a later video. Execute the following DBCC command to remove all entries from the plan cache DBCC FREEPROCCACHE Execute the following query. Notice we have set @FN='Mary' Declare @FN nvarchar(50) Set @FN = 'Mary' Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where FirstName = ' + QUOTENAME(@FN,'''') Exec(@sql) Execute the following query to retrieve what we have in the query plan cache SELECT cp.usecounts, cp.cacheobjtype, cp.objtype, st.text, qp.query_plan FROM sys.dm_exec_cached_plans AS cp CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st CROSS APPLY sys.dm_exec_query_plan(plan_handle) AS qp ORDER BY cp.usecounts DESC Notice we have an auto-parameterised query and at the moment usecounts is 1. Now change @FN='Mark' and execute the same query. After the query is completed, retrieve the entries from the plan cache. Notice the usecounts for the auto-parameterised query is 2, suggesting that the same query plan is reused. Along the same lines, if you change @FN='John' and execute the query, you will see that the usecounts is now 3 for the auto-parameterised query. Summary 1. If you use QUOTENAME() function, you can prevent sql injection while using Exec() 2. Cached query plan reusability is also not an issue while using Exec(), as SQL server automatically parameterize queries. 3. I personally prefer using sp_executesql over exec() as we can explicitly parameterise queries instead of relying on sql server auto-parameterisation feature or QUOTENAME() function. I use Exec() only in throw away scripts rather than in production code.
Views: 18012 kudvenkat
This Video will show you how to execute Scripts in Multiple Schemas through Command Prompt. sqlplus execute sql file? how to run sql script in sqlplus command line? how to run sql script in oracle sql developer? sqlplus execute command? how to run sql script in sqlplus command line in windows? sqlplus script example sqlplus command line example sqlplus run script output to file sqlplus run script command line sqlplus command line example sqlplus command line options sqlplus command example how to run sql script in sqlplus command line in windows sqlplus command in unix sqlplus script example sqlplus command line windows
Views: 3384 Oracle PL/SQL World
How to execute sql and Sqlplus commands from an external script
Views: 86329 jbleistein11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 111042 kudvenkat
THIS VIDEO WILL HELPFUL IN INSTALLING SQL SERVER USING COMMAND PROMPT. A REAL TIME EXPLANATION. COMMAND FOR UNINSTALLING SQL SERVER 2008 OPEN THE COMMAND PROMPT IN RUN AS ADMIN MODE AND THE RUN THE BELOW COMMAND setup.exe /ACTION="unInstall" /QS /FEATURES=SQLENGINE,REPLICATION,FULLTEXT,CONN,BC,SDK, BOL,SSMS,ADV_SSMS,BROWSER,WRITER /INSTANCENAME="NAME OF THE INSTNACE"
Views: 463 SQL DBA CLASSES
Today's Video is on Installing SQL server using CMD line. Senerio :- What if you have to install SQL server on multiple computer let say more then 10 computer. Installing SQL usng GUI on 10 computer may take your entire day. SO this video will help you to understand how to install SQL using CMD and configuration file. Hope you all like it. Please Like and Subscribe to my channel for all the latest post and update
Views: 506 MSSQL DBACourse
SQL Server DATEPART Function Result Year Month Day Quarter Datetime Command Line Management Studio.
Views: 75 Saidah Faulia
Discussion of Table Variables in TSQL Command Line. Table Variables are extremely useful in some cases are even better than Temp Tables. However, you will always need to define them, unlike a temp table where you can simply do a select into statement.
Views: 175 Dave Merton
Learn more about logical read http://bit.ly/LogicalRead_UnattendedSQL. Discover how to create a SQL Server Configuration File and then use that Configuration File to perform an unattended installation of SQL Server 2014. Connect with SolarWinds: thwack Community: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds LinkedIn: http://www.linkedin.com/company/solarwinds Instagram: http://instagram.com/solarwindsinc/
Views: 8002 solarwindsinc
I manually install and configure a local MySQL database server. This involves troubleshooting some error messages that you might encounter. I also create a test database and a second user who is granted access to it. ** Note: The my-default.ini file is no longer included in version 5.7.18 or later. Refer to https://youtu.be/ZnAmRF8TTpA if you really need it. Table of contents 1:02 Downloading the Community Server. 2:16 Extracting the program to disk. 3:25 Starting the server for the first time. 4:32 Creating a data directory to hold database and log files. 5:00 Allow Windows Firewall to allow the database to use private networks. 5:50 Starting the server to display server logs to the screen using the --console parameter. 6:18 Exploring the "table mysql.user doesn't exist error" message. 7:00 Viewing the server command line options. 7:45 Initializing the database to create the mysql.user table and other necessary tables. 10:32 Starting the server with an initialized database. 11:05 Logging in as the root user for the first time. 12:15 Changing the root password. This assumes that you are logged into the database as the root user. 13:48 Changing the root password using the --init-file option if you have forgotten what this password is. 16:13 Troubleshooting the (Errcode: 2 - No such file or directory) message when using the --init-file option when the file is present. 17:40 Looking at the warning messages displayed on the screen. [obsolete] 18:02 Copying my-default.ini to my.ini. 19:00 Resolving the timestamp and sql mode warning messages. 21:15 Installing the server as a Windows service. 21:55 Troubleshooting the "Install/Remove of the Service Denied" message. 22:45 Starting the service. 23:35 Troubleshooting the "innodb_system data file ibdata1 must be writable" message. 24:32 Creating a database. 26:12 Creating a second user and giving that user access to the database created in the previous step. 29:50 Adding the MySQL binary directory to the Windows environment path.
Views: 49743 ProgramOften
In this video we will discuss some of the common options that we can use with ng new command. Flag Type Default Alias --dry-run Boolean false -d Run through without making any changes. Just reports the files that will be created --skip-install Boolean false -si Skip installing packages --skip-tests Boolean false -st Skip creating tests --inline-style Boolean false -is Use inline styles when generating the new application --inline-template Boolean false -it Use inline templates when generating the new project Text version of the video http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-ng-new-options.html Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-ng-new-options-slides.html Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 23356 kudvenkat
Open the “Windows PowerShell” or “Windows PowerShell ISE” application utilizing the “Run as Administrator” option. Change to the deployment directory (C:\temp\DeploySQL) in the PowerShell command window. Execute the command below that fits the edition of SQL Server required from the PowerShell command prompt, replacing all options in brackets [ ] with the value in the row for the design document. MSSQL Server 2012 command : .\InstanceInstall_2012V2.exe -INSTANCE "[ Instance Name]" -INSTALLDRIVE "[ Install Drive]" -DATADRIVE "[Data Drive ]" -LOGDRIVE "[Log Drive ]" -TEMPDRIVE "[TempDB Drive]" -SQLSVR "[SQL Server account optional]" -SVRPWD "[Password optional ]" -SQLAGT "[SQL Agent optional ]" -AGTPWD "[Password optional ]" -SAPWD "[SA Password]" –VERPATH "[Path to installation file location optional ]” -BASE "[Base optional ]" -PCU "[PCU optional ]" -CU "[CU optional ]" -COLLATION "[Collation optional ]" MSSQL Server 2014 command : .\InstanceInstall_2014V2.exe -INSTANCE "[ Instance Name]" -INSTALLDRIVE "[ Install Drive]" -DATADRIVE "[Data Drive ]" -LOGDRIVE "[Log Drive ]" -TEMPDRIVE "[TempDB Drive]" -SQLSVR "[SQL Server account optional]" -SVRPWD "[Password optional ]" -SQLAGT "[SQL Agent optional ]" -AGTPWD "[Password optional ]" -SAPWD "[SA Password]" –VERPATH "[Path to installation file location optional ]” -BASE "[Base optional ]" -PCU "[PCU optional ]" -CU "[CU optional ]" -COLLATION "[Collation optional ]"
Views: 45 SQL DBA TIPS
Discussion of Temporary Tables and how to add IDENTITY field with AUTONUMBER in TSQL Command Line Code. Temp Tables can be created with their own unique auto increment fields, but it is a little more work to set up. The benefits may far outweigh the extra steps however.
Views: 254 Dave Merton
MySQL Tutorial for Beginners - 1 - Creating a Database and Adding Tables to it
Views: 1546961 CodePotion
In this video we will learn 1. Creating and executing stored procedures with output parameters 2. Learn about some of the useful system stored procedures Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-with-output.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-19-stored-procedures-with-output.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 411377 kudvenkat
In this Super SQL Tip Software Engineer Andrei Rusitoru explains the fantastic new formatting options available in SQL Prompt 8 from Redgate. SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hello, I’m Andrei Rusitoru and I work for Redgate software. Today I’m going to show you how to create your own style using the brand new formatting options in SQL Prompt 8. In SQL Prompt 8 we’ve added our completely re-designed formatting engine, giving you the best possible control over your formatting styles. Today we are going to go through the new SQL Prompt formatting options in SQL Server Management Studio, but exactly the same functionality is also available in Visual Studio. In SSMS I’m going to open the SQL Prompt menu at the top here and choose Edit Formatting Styles from the drop-down. This opens the Formatting styles window where you can see we have already included a couple of example styles to get you started. Keep an eye out for more of these in upcoming releases. Under “Your Styles” I’m going to click on Create a style to get started. It’s much easier to build your style on an existing one rather than starting completely from scratch. If you have created styles in previous versions of SQL Prompt then you will find them added here, and you can continue to work on them. I’m going to use Redgate’s Default Style as a base to build my new style on. So here are all the options. As you can see we’ve added a lot of functionality to allow you to tweak your style settings. Each of the main areas of SQL code has a section down the left hand side here, with sub-sections to help you easily find and manage these settings. To start with, let’s take a look at the GLOBAL settings and set the Whitespace options. For my tab behaviour, I want to use only tabs and I want 2 spaces in a tab. As you can see, there is some sample code at the bottom here that updates live as you change your settings so you can see exactly what impact your changes are having. If you want, you can change this to your own code if you have a query open. I don’t want to wrap my lines so I’m going to uncheck that. And finally I want to add a space before my commas. Let’s check how it looks… that looks good so I’m going to press Save. My new style has now been added to the menu on the left, and I can see a preview of what it does right here. This is going to be really helpful when I’ve created a few of these. I can also set the new style as my default active formatting by clicking Set As Active. I’m now going to go back in and change some other settings, so I click edit at the bottom here. I like to have my JOIN clauses right aligned to FROM, so I’m going to change that. I also like to have an extra line between them so I can see them easily. And I want my AND/OR operators to be aligned to the first list item, so I am going to go down here to the EXPRESSIONS section and change that under Operators. As you can see, there are lots of options to help you get your SQL looking exactly the way you want it and you can keep tweaking it until it looks perfect. You can create as many styles as you want too, so if you want a few different versions you can create them and then easily switch between them by simply right-clicking in your code, we are going to cover this in another video soon. So there you have it, it really is that easy to create your own style using the new formatting options in SQL Prompt 8.
Views: 1090 Redgate Videos
Buy Redmi 6 Pro (Gold, 32GB) - https://amzn.to/2Ntpkv4 Redmi Y2 (Gold, 3GB RAM, 32GB Storage) - https://amzn.to/2BXkNie Redmi 6 Pro (Black, 32GB) - https://amzn.to/2NofTwN Redmi 6 Pro (Gold, 64GB) - https://amzn.to/2BXMJmm Redmi Y2 (Black, 32GB) - https://amzn.to/2NqoHlV OnePlus 6 (Mirror Black, 6GB RAM, 64GB Storage) - https://amzn.to/2NrqtDb Redmi Y2 (Dark Grey, 3GB RAM, 32GB Storage) - https://amzn.to/2BXwvcS Redmi 6 Pro (Black, 64GB) - https://amzn.to/2OauUHV Connect To SQL Server Database Over A Network, connect to sql server database via LAN, Enable Network Access in SQL Server Database, Enable Remote Connection In SQL Express, Enable Remote Connection Over Network, Connect To SQL Server Database, Configure SQL Server To Allow Network Connection, Connect To SQL Server Database Over A Network Using Management Studio, Sharing a Database on a Local Area Network, SQL Server Database, SQL Server Allow Remote Connections to SQL Server Express, Allow Remote Connections to SQL Express, Allow Remote Connections to SQL, Allow Remote Connections To MSSQL, Remote Connections To SQL Express Verbinden mit SQL Server-Datenbank über Netzwerk - Aktivieren Sie den Netzwerkzugriff in SQL Server Conectarse a la base de datos de SQL Server a través de la red: habilitar el acceso a la red en SQL Server Connessione al database SQL Server tramite rete: abilitare l'accesso alla rete in SQL Server Se connecter à la base de données SQL Server sur le réseau - Activer l'accès au réseau dans SQL Server Подключение к базе данных SQL Server через сеть - включение сетевого доступа в SQL Server Podklyucheniye k baze dannykh SQL Server cherez set' - vklyucheniye setevogo dostupa v SQL Server 通过网络连接到SQL Server数据库 - 在SQL Server中启用网络访问 Tōngguò wǎngluò liánjiē dào SQL Server shùjùkù - zài SQL Server zhōng qǐyòng wǎngluò fǎngwèn ネットワーク経由でSQL Serverデータベースに接続する - SQL Serverでネットワークアクセスを有効にする Nettowāku keiyu de SQL sābā dētabēsu ni setsuzoku suru - SQL sābā de nettowākuakusesu o yūkōnisuru Conectar-se ao banco de dados do SQL Server pela rede - habilitar o acesso à rede no SQL Server Anslut till SQL Server Database över nätverk - Aktivera nätverksåtkomst i SQL Server
Views: 72232 Admin Technomark
https://www.youtube.com/user/masterkeshav This is the first part of the 3 part video on BCP, this explains in the simplest way how BCP (a command utility) helps you in pushing or pulling out data to and SQL Server tables. It is a very fast,robust,secure mechanism to do so..
Views: 37610 Keshav Singh
Views: 25698 kudvenkat
Demonstration of using SSIS Execute SQL Task to call a stored procedure to set SSIS variables from the stored procedure output parameter values and return value. No result set involved. Examples cover both OLEDB and ADO.NET.
Views: 14163 Steden Videos
Here we cover everything about the Command Line Arguments. Right from why we need command line arguments, what is their importance, how to pass them and how to access command line arguments. Part 3 describes how to create c# console application without visual studio. How to pass command line arguments from command prompt and visual studio debug tab. How to display command line. Link for all dot net and sql server video tutorial playlists Link for slides, code samples and text version of the video .
Views: 16 kabot hulk
Views: 296730 Questpond
Learn how to start sql server browser In this video, you will learn how to start and stop the SQL Server Browser service. By default, Microsoft SQL Server 2008 Express Edition (SQL Server Express) does not set the SQL Server Browser service to start automatically. To start SQL server browser service : 1) On the Start menu, right-click My Computer, and then click Manage. 2) In Computer Management, expand Services and Applications, and then click Services. 3) In the list of services, double-click SQL Server Browser. 4) In the SQL Server Browser Properties window, click Start or Stop. 5) When the service starts or stops, click OK. Using Cmd : to start the sql server browser :-- From the command prompt, type "net start sqlbrowser" to stop sql server browser : -- From the command prompt, type " net stop sqlbrowser "
Views: 14749 Solution Cone
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: http://www.joes2pros.com/joes2pros/Course/Introduction_To_Microsoft_SQL_Server Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
Views: 241250 Joes2Pros SQL Trainings
How to install SQL Prompt Tool for SQL Server 2012 and 2014 -----------------Cambo Cloud--------------------- Phone : +855 86 663 868 E-mail : [email protected] Website : https://cambocloud.blogspot.com/ ------------------------------------------------- ---How to Crack SQL Prompt for SQL Server 2012--- Support SQL SQL Server 2014 down 1- Install SQL Prompt for SQL Server 2012 2- Open Crack MultiKeygen 3- Select option below -Program Selection : Red-Gate SQL Multi Script 1 - Licensing methods : Method 1 4- Click Generate and then copy 5- Open SQL Server -Select SQL Prompt Tab -- Help -- Enter Serial Number... -Paste Ctrl+V on Serial number -- Activate -- Activate Manually --Activate Manually --Copy data in left textbox -- Paste into left Activation Request in MultiKeygen --Copy data in Activation Response --Paste into right textbox in Activate SQL Prompt 6- Finish -- Exit Activation Process ********* Made by Mr. Phann Channrithy ********* ********* Guided by Mr. Van Sochan ********* Download link : https://mega.nz/#!HjYACI7L!BlNVsZyrqOD_j_IAb1KvFtc_-sCaeKXYYBDlFT7TtpA sql prompt, sql prompt tutorial, sql prompt alias, sql prompt crack serial, sql prompt crack, sql in command prompt, sql command prompt download, sql command prompt tutorial, sql server command prompt, sql prompt full, sql prompt for sql server 2017, sql prompt free, sql prompt in visual studio 2017, sql prompt keygen, sql on command prompt, sql prompt plugin, sql prompt shortcuts, sql prompt serial key, sql prompt suggestions, sql prompt tips, sql prompt visual studio, sql prompt 8 crack, sql prompt 8 serial number, sql prompt 9 keygen, sql prompt 9 full crack, sql prompt 9 serial number
Views: 769 Cambo Cloud
User defined functions are divided into 3 types, Scalar functions, inline table valued functions and multi-statement table valued functions. In this video we will learn about creating and calling Multi-Statement Table Valued Function. Difference between inline and multi-statement Table Valued Functions. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/multi-statement-table-valued-functions.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-32-multi-statement-table-valued.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 143657 kudvenkat
This tutorial shows you how to find your server name or instance for connecting to SQL Management Studio (SSMS). Step by step tutorial on how to check if SQL is installed on your machine using the services to check that Microsoft SQL Server has been started. Next how to find your instance name using SQL Server Configuration Manager using SQL 2012 or 2014 folder. I show you how to connect to the instance name in the Connect to Server SQL Sever 2014 box. The Server Name is made up of the following: ServerName/Instance Name 1: To find the Server name type the following into command prompt: SQLCMD -L 2: To find the instance name go to Microsoft configuration manager there you will see your version of sql server in my case sql server express as such I know my instance name is sql server express 3. Put the server name and instance name together as per the video SOPHIA-HP/SQLEXPRESS To request a video: http://itsophy.com/request-video/ More SQL Server videos: http://www.youtube.com/playlist?list=PLrTXCzXE7TKKhIhGtl65lYMAHP6xN5Wa4 My Blog: http://itsophy.com/
Views: 123785 ITSophy
SQL Server Multiply Two Value or Column with Select Query Column Command Line Management Studio.
Views: 72 Saidah Faulia
In this tutorial we will give you a quick introduction to linux and linux commands for aspiring linux students. Contents of this Course: 1 - Introduction to Linux 2 - Quick Overview of Linux Distributions or Distros, such as Debian or Ubuntu 3 - Using the Linux Terminal 4 - Basic Linux commands for navigation and file manipulation. We will go over 10 commands in this video, including: cd, ls, pwd, cp, rm, mkdir, rmdir, man and more. Stay tuned for more Linux Commands Tutorials for Dummies. -- INSTALL UBUNTU in VIRTUALBOX on Windows 7 -- http://youtu.be/CkDd6jClqEE --------------- SOCIAL MEDIA ----------------- Follow me on twitter : http://twitter.com/sakitechonline Follow me on facebook: http://goo.gl/R95Pq Google+ goo.gl/9ekGhq Website: http://www.sakitechonline.com
Views: 2106313 sakitech
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/quotename-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/quotename-function-in-sql-server_26.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss Quotename function in SQL Server. This function is very useful when you want to quote object names. Please use the SQL Script to create the table used in the example from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/quotename-function-in-sql-server.html Let us say, we are using dynamic SQL to build our SELECT query as shown below Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = 'USA Customers' Set @sql = 'Select * from ' + @tableName Execute sp_executesql @sql When we execute the above script, we get the following error Msg 208, Level 16, State 1, Line 1 Invalid object name 'USA'. The query that our dynamic sql generates and executes is as shown below. To see the generate SQL statement, use Print @sql. Select * from USA Customers Since there is a space in the table name, it has to be wrapped in brackes as shown below Select * from [USA Customers] One way to fix this is by including the brackets in @tableName variable as shown below Set @tableName = '[USA Customers]' The other way to fix this is by including the brackets in @sql variable as shown below Set @sql = 'Select * from [' + @tableName +']' While both of the above methods give the result we want, it is extremely dangerous because it open doors for sql injection. If we set the brackets in @tableName variable, sql can be injected as shown below and SalesDB database is dropped Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = '[USA Customers] Drop Database SalesDB' Set @sql = 'Select * from ' + @tableName Execute sp_executesql @sql If we set the brackets in @sql variable, sql can be injected as shown below and SalesDB database is dropped Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = 'USA Customers] Drop Database SalesDB --' Set @sql = 'Select * from [' + @tableName +']' Execute sp_executesql @sql So, the right way to do this is by using QUOTENAME() function as shown below. Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = 'USA Customers Drop Database SalesDB --' Set @sql = 'Select * from ' + QUOTENAME(@tableName) Execute sp_executesql @sql When we execute the above script we get the following error. SalesDB database is not dropped. The reason we get this error is because we do not have a table with name - [USA Customers Drop Database SalesDB --]. To see the sql statement use PRINT @sql. Invalid object name 'USA Customers Drop Database SalesDB --'. If we set @tableName = 'USA Customers', the query executes successfully, without the threat of SQL injection. Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = 'USA Customers' Set @sql = 'Select * from ' + QUOTENAME(@tableName) Execute sp_executesql @sql If you want to use sql server schema name "dbo" along with the table name, then you should not use QUOTENAME function as shown below. Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = 'dbo.USA Customers' Set @sql = 'Select * from ' + QUOTENAME(@tableName) Execute sp_executesql @sql The above query produces the following error Invalid object name 'dbo.USA Customers' Instead use QUOTENAME function as shown below Declare @sql nvarchar(max) Declare @tableName nvarchar(50) Set @tableName = 'USA Customers' Set @sql = 'Select * from ' + QUOTENAME('dbo') + '.' + QUOTENAME(@tableName) Execute sp_executesql @sql QUOTENAME() function Takes two parameters - the first is a string, and the second is a delimiter that you want SQL server to use to wrap the string in. The delimiter can be a left or right bracket (  ), a single quotation mark ( ' ), or a double quotation mark ( " ) The default for the second parameter is  QUOTENAME() function examples SELECT QUOTENAME('USA Customers','"') returns "USA Customers" SELECT QUOTENAME('USA Customers','''') returns 'USA Customers' All the following statements return [USA Customers] SELECT QUOTENAME('USA Customers') SELECT QUOTENAME('USA Customers','[') SELECT QUOTENAME('USA Customers',']') If you use a delimiter other than a single quotation mark, double quotation mark, left bracket or a right bracket, you get NULL. The following statement returns NULL. SELECT QUOTENAME('USA Customers','*')
Views: 14332 kudvenkat
Discussion of Table Variables in TSQL Command Line and why you never need to drop a Table Variable. Table Variables are extremely useful in some cases are a much better choice than Temp Tables. You never really need to drop a table variable unless you are attempting to do something very strange in a stored procedure or a script.
Views: 329 Dave Merton
Windows Firewall Configuration For SQL Server to allow remote connection
Views: 4366 Soft Solution
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 182850 Manish Sharma
How to create shortcut for SSMS and Connect to Default SQL Server Automatically - SQL Server / T-SQL Tutorial Scenario: You are working as SQL Server Developer with Car Insurance company as contractor. They have provided you name of SQL Server Instance and Database Name you will be working during your assignment. Every time you open SQL Server Management Studio, you have to provide Server Name and then choose Database Name to start work. You would like to create s shortcut for SSMS with default settings so you can connect to Database with one click. Solution: Step 1: Create SSMS Shortcut. Go to Search and type SSMS. Once see the SSMS, Right Click and choose Open file location. One you choose Create Shortcut, it will ask you Do you want to create on Desktop. Click that and you are done. Step 2: Change Shortcut Properties As our shortcut is ready now. Go to Desktop and right click on SSMS Shortcut and then go to properties. In Target, we are going to add some parameters to SSMS.exe. By default it is simply opening SSMS.exe. If I would like to open my default SQL Server Instance with Windows Authentication and user Database TestDB1, i can use below parameters -s . -E -d TestDB1 Parameter meansings -s The name of the SQL Server Instance to connect to (after -s, I provided Dot(.) that means I would like to connect to my default SQL server Instance. I could have provided Named SQL Server Instance if want to. -E User Windows Authentication to login to SQL Server. If you would like to use User Name and password, you can use -U for user name and -P for password. -d The name of the SQL Server Database to connect to. Hit apply. Now once you will open SSMS by using Shortcut, it will automatically connect to default SQL Server Instance and open Query with scope of TestDB1. Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 5786 TechBrothersIT
In this video we will dscuss 1. How to create a new angular project from scratch using Angular CLI 2. Run the app 3. Run unit and end-to-end test In this course we will use Visual Studio Code as the editor. Visual Studio Code is free and you can use it on any platform - Windows, Mac or Linux. If you have not installed it already, please install it by downloading from the following link. https://code.visualstudio.com/download To create a new Angular Project, open Command Prompt as an Administrator and execute the following command. This command creates all the required files and also installs all the required packages. Depending on your computer and internet connection speed, this command takes a few minutes to complete. ng new MyFirstApp ng is the Angular CLI new for creating a new application MyFirstApp is the name of your angular application There are several options that we can use with "ng new". We will discuss all these options in our next video. Once the above command has completed successfully you will see the following messages. Installed packages for tooling via npm. Project 'MyFirstApp' successfully created. So what did this "ng new" command do A new folder with name MyFirstApp is created All the required configuration and source files are created. All the npm dependencies are installed in node_modules folder Unit and end-to-end tests are created The Karma unit test runner is configured The Protractor end-to-end test framework is configured We will discuss unit tests, end-to-end tests, Karma and Protractor in our upcoming videos. Please note that all these code and configuration files are created by the Angular CLI out of the box while still following the angular teams best practices and conventions. Now, go to the folder (MyFirstApp) that contains our angular project, by executing the following command. cd stands for change directory cd MyFirstApp Now execute the following command at the command prompt to open the project folder in Visual Studio Code. Notice there is a single space and a DOT after the word code. code . At this point in Visual Studio Code you will see all the Angular project files. Also notice node_modules folder, that conatins all the installed packages. We will discuss, what all these files are and their purpose in our upcoming videos. To run the project using Angular CLI, type the following command at the command prompt. This command builds the application and opens it in our default browser. The flag --open, launches our default browser and runs the application. By default the application runs on port 4200. We can change this port number if required. We will discuss how to do that in our upcoming videos. ng serve --open At the moment, the angular development server is running in watch mode, meaning when a file changes, those changes are automatically detected, compiled and the browser reloads to reflect the changes. This is called live reload. We can turn this live reload functionality off, if required. Again we will discuss how to do this in our upcoming videos. To stop the server, press CTRL + C while you are on the command prompt and then "Y" and ENTER key. This will stop the server. To run all the unit tests, use the following command ng test To run all the end-to-end tests, use the following command ng e2e We will discuss Unit tests, end-to-end tests and all the options we can use to run them using Angular CLI in our upcoming videos. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/09/angular-cli-create-new-project.html Slides http://csharp-video-tutorials.blogspot.com/2017/09/angular-cli-create-new-project_27.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 56396 kudvenkat