Merge statement- A simple way for DML TIP#105
When, I first saw this statement a Hindi proverb come to my mind which is “1 teer 2 nishane” . The...
2015-07-18
959 reads
Rajat Jaiswal-337252
Proper Aliasing will help you somewhere TIP#104
Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...
2015-07-09
466 reads
It is OK its NULL only TIP #103
We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we...
2015-07-15 (first published: 2015-07-06)
2,719 reads
Microsoft MVP–A dream came true
Dear All,
“Microsoft Most Valuable Professional “ – MVP is one of the prestigious tag. It is one of the dreams which came...
2015-07-02
484 reads
A myth about view TIP #102
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer...
2015-06-20
531 reads
Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101
Let’s consider a scenario where the end user require a CSV file of all the records in a table then...
2015-06-18
1,302 reads
Find all the dates in a date range ? TIP #100
It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really...
2015-06-22 (first published: 2015-06-12)
2,437 reads
How to hide my SQL Server instance in network ? TIP #99
In TIP #70 we saw how to find all the running SQL SERVER instance in a network or a machine....
2015-05-04
680 reads
I am not able to access my SQL server instance on another computer tip #98
On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server...
2015-05-11 (first published: 2015-05-04)
5,924 reads
How to send E-mail/E-mail with Attachments in SQL Server TIP #97
In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail...
2015-04-26
8,603 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCP Rawasari | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Rawasari Sel. No.24 A, RT.12/RW.9, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat,...
BCA KCP Taman Aries | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Taman Aries Blok E1 No. 2A & 2 B, RT.12/RW.8, Meruya Utara,...
BCA KCP Sumbersari | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Sumber Sari No.23 T 12, Babakan, Kec. Babakan Ciparay, Kota Bandung, Jawa...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers