How to Use dbForge SQL Complete for SQL Server to Increase Productivity

Here I explain the dbForge SQL Complete tool for SQL Server to boost your code productivity. SQL complete contains a lot of features to simplify the SQL server development. The tool offers excellent autocompletion capabilities as an add-in for Visual Studio and SSMS.


Promo Code for 10% Discounts : 10SQLCSHARPSPACE
URL: https://www.devart.com/dbforge/sql/sqlcomplete/

Subscribe to this channel
► https://www.youtube.com/csharpspace?sub_confirmation=1


🎬 All Playlist
https://bit.ly/3cHsXxO : ASP.NET Core
https://bit.ly/3jgyL2x : ASP. NET Web API
https://bit.ly/2MSpi5i : ASP.NET MVC
https://bit.ly/2LinGBm : ASP.NET MVC With Angular JS
https://bit.ly/39NZZuj : Social Account Login in ASP.NET MVC
https://bit.ly/2MyVgUq : ASP.NET Web Forms

🌟 About this Channel
Csharp Space provide simple and step to step video tutorials of different programming languages like ASP.NET, ASP.NET Core, C#, ASP.NET MVC,
Angular JS, JavaScript, jQuery, SQL ,Crystal Report.
This channel also provide How to and problem solving topics of the programming languages.
► For Sponsorship Contact here: vivek29417@gmail.com

🔗 Social Media Links
Blog : http://www.voidgeeks.com
Facebook : https://www.facebook.com/csharpspace
Twitter : https://twitter.com/csharpspace
YouTube : https://youtube.com/csharpspace

---

Closed Caption:

hello friends welcome to c service page
today in this previous session we will
discuss about
how to increase your sql server
development productivity with a sql
complete tool
so let's start
uh here
this is the site where
you can download a sql complete david
or dv pose sql complete tool or
boost your productivity
this uh also provide a
uh trial version for
to checking the to try the features of
the sql complete tool
and here you can see the difference
uh features that is provided by the sql
complete uh like
you can increase your coding speed with
intelligence intellisense that is
provided by a sql complete and like
you can
get a quick info and overview for your
database beautify code and in
enhancement code qualities
and like eliminate
replicated coding set predefined snips
you can use like a
pre-defined snippets and you can reuse
your old codes
and like a
data analysis increase your performance
with productivity enhancements
and this is the express edition with
limited features to
uh to try the features of sql complete
and here uh
the different features
uh to
uh
to dv4 sql complete like a boost your
productivity reuse code improve code
quality
and it's like a unified standards like
you can write a code and then you can
format your query most in readable
formats
it's like a work safety like easier like
when sometimes your uh ssms is
uh accidentally shut down then you can
access your
uh systems
like your previous series you can easily
get it
and look his next features it's like
operate with data you can
select any uh any records from your data
and then you can export that record in
any formats like a csv json
and excel files
as per your requirements and there are
different features
that is not available in ssms
and
this is the uh different formatting
profiles this provider customized
formatting profiles
you can choose any formatting profile in
your tool we can see this in all in
uh sql server here
after
uh
while we writing a queries for this like
for example this is the
before formatting you write any
process and this is before formatting
and option after use collapse
uh formatting profiles this theory it
changed like this so this is the most
readable format and when you share your
query or process with in your any of
your colleges
then they can easily easily understand
and
the difference uh different profiles
according to you uh according to your
need so you can change it
that is different styles for formatting
and there is a difference
like uh
purchases and price details
so
now we
uh up after you can download this db
force this will integrate with your
widget studio or ssms studio
so i demonstrate the features about this
sql complete with uh
ssms
so
this is the uh demo dated database that
contain multiple tables
and procedures
so here's the number of tables
and here there are multiple processes
functions
so
now
like after after installing the
sql complete this will add a new tab in
your essence ssms
here like a different features like a
decibel code completions formatting sql
parameters
and there are different executions
history so we can talk about all these
features
uh in step by step
like uh i'm writing ssf then
this is the selected stop home command
so simply pressing tab so this will auto
uh write it here
and then we write like a table name
insert table cells like table
underscore cells then this will display
the intellisense for that matching
tables with their
column definitions
and their data type also so like i'm
selecting this
and press tab so it's automatically
added earlier's name also
like i'm pressing f5
so this will display the related records
you can also
import the report with different data
format like a copy dot s csb xml html
jsons
i could copy columns
uh column name only with comma
and here like a generate you can
uh generate the scripts like insert
so insert and insert into tem data
warehouse where and or update commands
like i'm choosing like this
insert so like click it
so this will create the insert command
for that selected rows
and you can choose and you can also
generate uh
scripts for single columns only so like
selecting that columns and then generate
script and then click on this so this
will create a insert command
is insert command pro into the time
tables for that selected columns only
and like i am writing like in ddl
commands dml commands like insert
so this the insert into
and then we writing like a column's name
sales invoice simple i'm pressing our
tab buttons
so tab does this will create a
insert statement for that
that particular table tbl sales invoice
and
when you hover your mouse on the table
name this will display all these columns
and their data types for that table
and when you
enter the records into these values then
this will also highlight that related
columns
like i'm enter once
and like get it and
then here it's payment type like it's a
cash
because
then this will uh highlighted that
related columns so this is a good
pitches for
you while entering the records
and like i'm also right update
so update
and then tables name
like a customer then press
tab buttons so this will
create the update command for uh that
customer table
so uh so you you can easily use their uh
previous snips and auto completions to
in boost your productivity
and you can also choose your execution
history
by executing commands that that you
executed the query and the recent so
click on this select control and text or
simply selecting
from this sql complete tab so go to
education execution history so here
you can get your recent security that
you executed so simply click on it so
this will uh copy to in a new query
window so this is
uh good for
uh
for your
productivity also so you can find your
recent
curious no need to again retype it
and like one more features like when
we're writing a alter
proc now you can use any like a pro
tables functions procedures like i'm
writing alter prop then this will
display the different process names like
i'm using that add company
and pressing a tab
and this will
get all the definitions for that
procedures
and one more features
is a document outline
so
simply you can get this from here
document outlines
so this will display the
current current query
for uh
structures of that
this display and the current close yes
like a begin and then insert commands
uh it's showing
structures of the current process so
this will be easy for developer to
identify the process structures and
you'll find any any particular line that
you need to
change it
and one more sessions one more features
for like uh document sessions
i like uh
when we using uh ssms and sometimes like
our sql server
uh crashed it so it's automatically save
the recent
recent your sql queries so you can
easily get it after
you opening your
ss message studio so simply click on
this and then you can
get your recent typed sql queries
and one more features like for findings
any record so simply select it and then
click on find
and like it's currently selecting hero
so this will highlighted the
written text here like i am writing like
18 then this will
find the 18 in all the
columns of that table
you can also format the documents by
pressing a ctrl k d
or
you can also choose this from here it's
a sql complete
and then it's for my documents then you
can choose it here and you can choose
your format document styles with this
customize options
so this will
provide the options for
your custom files for formatting the sql
queries
now this is a difference code snipped
for chords
and like execution history settings so
this should provide all the options
settings for that tv course sql complete
options
one more life saving uh features for
this sql complete is like
when we writing or delete
like we want to delete the records from
any tables without wear conditions then
this will
display a warning
for that like i'm deleting the records
from this customer table and pressing
effect then this will display
a warning message that you will delete
all the records from that table
so it's where if you want to executes or
don't execute
and one more pictures like
for going to the end of the block so you
can simply press
shift after so you will going the end of
this block like a beginning like a try
catch so you can simply go from start
and end of that block
and some more good pitches like
uh
you can choose your environments
according to your tap plus so you can
depreciate between like a development
productions and sandbox so simply choose
your color from here
so you can choose like a development
production sandbox test
so like i am highlighting this as a
production so
this query has a red mark
and one more things you can also find
your invalid object so simply
right click on that database and here
you can choose that and invalid objects
so you can simply find uh select the
database name and then click on analyze
buttons so this will analyze all the
inverted objects
for that
database so like my in this table
database i have this
invalid procedure so on the single click
you can find your invalid objects also
so if you want to try the features for
that sql completes you can download it
from here for to try the features of
that and if you want to purchase this
sql complete you can use my promo code
for getting the 10 discounts on purchase
and then your you can boost your
productivity and development for the sql
server
so that's it for today and if you have
any problems any questions
and then you can write in comment box i
will reply you soon
so thanks thanks for watching and also
more and if you want to getting the
latest updates so click on subscribe
button and for notifications also click
on
uh notification bell
so now we will meet in next video
session