We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we allow the data field to accept null.We think it will not affect anything. Actually , at some point this is not always true. According to Microsoft NULL is an Unknown value. It is not …
Dear All, “Microsoft Most Valuable Professional “ – MVP is one of the prestigious tag. It is one of the dreams which came true today. Today , I got the E-mail that I am an MVP in SQL SERVER. I am speechless but would like to say a big thanks to everyone who provided …
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer will roaming around like so Can you update record using View? or Can you delete record using view ? I hope everyone who is reading this article will be aware of what is …
Let’s consider a scenario where the end user require a CSV file of all the records in a table then BCP is one of the simplest way. BCP stands for Bulk copy program. By the name you got the feeling of lots of data . Although, there are various options & parameters available with …
It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really sorry for that. Now , Lets talk about the scenario sometimes we need to generate a report of total sales in particular date range but the condition is you need to show all the …
On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server machine in the office through his machine. I think this is generalized problem and might be faced by many of us. So to begin with default port of SQL SERVER is 1433 , …
In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER. Sometimes we need to send mail for different requirements like 1) Notification mails like data inserted /updated/deleted successfully 2)Send data reports like no of amount earned, failed transaction etc. for this …
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL Server provides E-mail functionality using “Database Email” feature. We can setup any E-mail in few simple steps. Let’s follow below steps Step 1:- Open “Management” option of object Explorer in SQL SERVER …
Although , It is out of box but I would like to share here. I am very choosy in food. When my mother/wife cooked food and I didn’t like the taste then I explicitly said I didn’t like but when food taste was awesome then I didn’t say a word. My mother taught me “You …