View in sql server

By -
Referred as "Virtual Table" Can not store data (except for indexed views) rather than only referto data present in table. e.g. Create View vwsample [optional] With Encryption OR With Schemabinding [/optional] AS Select Cid, CName FRom Customer GO With Encryption - You can see view query (its encrypted) With Schemabinding - You are not able to alter table on which it's created.

Comments

Post a Comment

Popular posts from this blog

Fiserv Interview Questions.

By -
1) For edit functionality in DataGird specify Column name 2) Why you may not want to use Paging funtionality in data grid 3) Function of SqlCommanBuilder in code. 4) Find the error in code . Its related to database connection. I think that connection sould be closed in finally instead of try. 5) What is the relation between src='' & Inherits='' in <@ Page > directive 6) What is derective in the user control page & its extention of file 7) Question related to 404 error code Error page & Default error page. 8) Its related to Autherization in web config related to folders 9) Related to definition 10) not remembred with question but answer is cookiless = true related question 11) Page is posting the 2 times why is it so 1) user control load 2) some control call load 12) describe !Page.PostBack Select Options 13) Question related to Session mode = SQLServer 14) Some question related to validation control - compare validator 15) Some question ...
Read more

Dependency Injection

By -
Image
Replace dependencies with Dependency Injection to make your classes easier to reuse and test. The dependency injection pattern, is one of the most popular design paradigms today. It facilitates the design and implementation of loosely coupled , reusable , and testable objects in your software designs by removing dependencies that often inhibit reuse. Dependency injection can help you design your applications so that the architecture links the components rather than the components linking themselves. Samples used for this presentation:  DI_Demo.zip
Read more

How to get motherboard serial number, Processor ID, VolumeSerialNumber using C#?

By -
Add using System.Management; namespace in your application then //Get motherboard's serial number ManagementObjectSearcher mbs = new ManagementObjectSearcher("Select * From Win32_BaseBoard"); foreach (ManagementObject mo in mbs.Get()) { textBox1.Text = mo["SerialNumber"].ToString(); } //Get Processor's Identity mbs = new ManagementObjectSearcher("Select * From Win32_processor"); foreach (ManagementObject mo in mbs.Get()) { textBox2.Text = mo["ProcessorID"].ToString(); } //Get Network Adapter Configuration mbs = new ManagementObjectSearcher("Select * From Win32_NetworkAdapterConfiguration"); foreach (ManagementObject mo in mbs.Get()) { textBox3.Text = mo["MACAddress"].ToString(); break; } ...
Read more