SQL Server’s process command BULK INSERT to load data from a user-specified file format into database tables. Specified file format can have any column & row terminator, for instance – pipe, space & comma. Furthermore, this tech-recipes post demonstrates how to import CSV files using BULK INSERT in SQL Server.
How to Reuse Calculated Column with CROSS APPLY In SQL Server
APPLY operators (CROSS APPLY & OUTER APPLY) were introduced in SQL Server 2005 edition. Importantly, with APPLY operators, now it is easier to join Table-valued function to base tables based on the join condition. Although APPLY operators different from SQL JOIN. In the case of SQL JOIN, we can not join to Table-valued function. CROSS APPLY operator is also used to reuse calculated column.
How to Use Tap to Wake on iPhone
With a quick tap on your iPhone’s screen, you can trigger your device to turn on its screen and allow you to check your notifications, use your torch, or get access to your camera. Learn how to use Tap to Wake on the iPhone.
For the longest time, waking up your iPhone requires you to press on the Home or Power button. Now, you don’t have to press the mentioned buttons if you want to wake your iPhone’s screen. After having it on a few iPhone users’ wish lists, Apple now allows it to turn on the screen just by tapping on it. If you’d like to learn how to use turn on your iPhone’s screen with a quick tap, then check out the next sections.
How to Charge iPhone Using the MagSafe Charger
Arguably one of Macbook’s most-loved features, MagSafe is now available for iPhones. Learn how to charge your iPhone using the MagSafe Charger.
How to Use Slicers To Filter Data In Microsoft Excel
Slicers provide an interactive way to filter the data with list and buttons. It shows which filters have applied and a list of possible values in a presentable manner. Using the existing dropdown filter which lacks showing all the possible values on the sheet for presentation. Strongly recommended the feature Slicers when presenting data analysis to customers and stakeholders with an interactive dashboard.
5 Great Tech Skills to Learn During Lockdown
Just as every destruction breeds creativity, so has the COVID-19 pandemic these days. As devastating as its continuous effects are, it has also provided the masses ample time. Time to finish books one started but never got to read till the end. To take care of household fixtures one barely got to notice due to a 9 to 5 job. But mostly, the lockdown due to the pandemic has led many to start learning new skills. Luckily, once the pandemic is completely over, companies will be hiring just as rigorously. So, check out the following 5 great tech skills to learn during the lockdown and improve your chances of getting hiring post-COVID or to polish your already-existing work portfolio.
Best Games to Play On Zoom To Make Lockdown More Fun
If you associated words like work and/tiring with Zoom, reconsider. Your time on Zoom can be made fun and exciting, too. For right after you’re done with a meeting with, let’s say, work colleagues, you can ring up your friends and play games on Zoom. Due to its high quality and functionality, it’s peoples’ top choice for a happy hour app. The more, the merrier! There are so many types of games to choose from. Want some starters? Keep on reading to find out some of the best games to play on Zoom to make lockdown more fun.
How to FaceTime While Using Other Apps on iPhone
Are you jealous of your iPad-user friends who can FaceTime and browse their Instagram feeds at the same time? Now, you don’t have to. You can now FaceTime while using other apps on iPhone. If you think that’s interesting, then read on.
How to Free up WhatsApp Storage Space with Storage Manager (Updated)
Clearing space in your device is vital, but can be tedious at times. In fact, you’d be surprised to know how much junk files are eating space in your device. When it comes to WhatsApp, media files－GIFs, audios, documents, images,etc.－are stored in your device’s media library, where you can see them every time. This is unlike media files from other apps, which are neatly tucked away in some faraway folder in your device. Want to clear all the WhatsApp clutter instantly? Keep on reading to find out how to free up WhatsApp storage space with storage manager (updated) without deleting important chats.
How to Unlock an iPhone While Wearing a Face Mask
COVID-19 poses a new problem for iPhone users – how to unlock an iPhone while wearing a face mask. If you find it a hassle to take off your mask or input your iPhone’s unlock code, then you may want to check on this article. This article will help you unlock your iPhone without removing your face mask or inputting the unlock code.
Execute SQL Files Using SQLCMD
SQLCMD is a command-line utility to connect and execute SQL queries from the command prompt. Using SQLCMD we can only connect to SQL Server instances. Importantly we can run ad-hoc as well as interactive script plus automating SQL scripts execution. This utility is pre-installed with SQL Server installation. Instead of relying on SSMS for quick tasks, we can use SQLCMD utility to execute SQL queries through ad-hoc statements or .SQL files.
How to Schedule A Google Meet
During these COVID-19 days, the trend of Zoom meetings and conferences is not slowing down any time soon…but so is the case with Google Meets. Professionals, large conglomerates, home-based tutors, everyone alike is using it, all the same, to meet virtually. It’s just as simple and convenient－perhaps more so－than setting up a Zoom meeting. Keep on reading to find out everything you need to know about how to schedule a Google Meet, invite guests to join, set timings, time zones, dates, add additional notes for guests and more. The steps are for the desktop version; it contains more features.