Importing and exporting data from flat files is a common task among developers & DBA. Different methods are available to import-export flat file data in SQL Server. Well-known methods include – BCP, SSIS Packages, OPENROWSET, BULK INSERT queries, and tools. However, the simplest one is doing it within SSMS (SQL Server Management Studio). Using Import Flat File data wizard in SQL Server.
How to Pin Comments on Instagram
Pinning a comment on a post makes it live at the top of all the hundreds or even thousands of other comments made on that post. It’s a way of curating a conversation around a post, any post. You can set a certain kind of tone to your post(s) by pinning comments. You could, for instance, pin only positive or some sort of informative comments, while negative and/or abusive ones stay at the bottom. This way, you can also add follow-up information on your posts. So, keep on reading to find out how to pin comments on Instagram and receive all the perks on the Facebook-owned sharing app.
How to Create Instagram Reels
Instagram has recently released an exciting, creative feature, Instagram Reels. The feature, within the app and released in the US and 50 other countries so far, is becoming the new Instagram-fed drug for IG users. It takes Instagram stories and boomerangs to the next level; there are more features associated with Instagram reels. Basically, reels are 15-second video clips with featured audios, coupled with intriguing editing features. Anyone can create, view and share reels on Instagram; nothing short of short film making! Keep on reading to find out how to create Instagram reels in easy steps and quickly reach a global audience fast.
How To Change the Color of Your Messages on Instagram
Having bright, vibrant colors and gradients against a dark theme in apps is perhaps everyone’s choice these days. However, unlike most social media platforms today, Instagram has gone a step further than its rivals and introduced an even more exciting feature in its chat section. There, you can select themes as well as colors and gradients for your chat board and messages therein. The colors are nothing less than delicious, eye-catching shades in brights. Following is the super-easy method of how to change the color of your messages on Instagram in just under 10 steps!
How To Import CSV File Using Bulk Insert In SQL Server
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.
