In this article i will show you you how to get data from sql server in excel by run stored procedure in Microsoft Excel. 1. Open Microsoft Excel. 2. Go to Data tab. 3. Then Go to Other data source menu in it. 4. 5. Fill your details in pop-up box as shown in […]
Categories
How Data is stored in Sql server
Data in sql server is stored in Data pages.Pages in a SQL Server data file are numbered sequentially, starting with zero for first page in data file. Each file in a database has a unique file ID number. To uniquely identify a page in a database, both the file ID and the page number are required. […]
Categories
How many types of files in sql server
Sql server mainly consist of three types of files:- Primary File :- The primary data file contains the startup information for the database and points to the other files in the database. User data and all objects can be stored in this file or in secondary data files. Every database has one primary data file. […]
Read Receipts in Microsoft outlook Whenever you send a mail, you can request a Read Receipt or a Delivery Receipt. You can do this for individual or for all your mails. This applies to Outlook 2000 and Outlook 2003. 1. Open Outlook. 2. Click on New Mail Message. 3. Write down you Mail and then […]