Interview Questions for programmers in a company

1. About ms SQL 2000

1. Server 1 has a database server1.data1 and data1 has a table Table1. Server 2 has a database server2.data2 and data2 has a table Table2. How can we implement inner join between two tables?
2. If you use a complex SQL statement from the ms SQL database to extract all the field names, types, constraints of a table?
3. How to extract all constraint names of a field?
4. How can I save a text file to the IMG field and read it out?
5. Implementation of full-text retrieval and how to implement full-text retrieval after a custom binary file is saved to the IMG field? 6. Implementation Method for checking the constraints between different records in the same data table.

2. NET Programming

The 1..net component is embedded in the IE browser and displays an interface. the. NET Component interacts with the Javascript script to implement. NET components to call JavaScript Functions and JavaScript to call. net public attributes and events.
2. Automatic deployment of. Net plug-ins on the client, including automatic download and automatic security settings.
3. Generate and display caret on a panel for how to implement. Net call to Win32 API.
4. How to obtain the user's sessionid from WebService?
5. How does one start or call win service on the server through WebService and implement the security mechanism?
6. Generate a PDF file using. net.
7. How can I transmit big data from 1. aspx to 2. aspx without using seesion and application?

Iii. About Javascript

1. Can I rewrite a javascript-based Web page with built-in simple word processing controls?
2. dynamically generate menus on the webpage.
3. XML + XSL custom webpage.
4. In the web page, use a script to call Word and Excel, and pass the server-side data to Word and Excel?

In fact, it is not difficult. Maybe everyone thinks too complicated. I entered the recruitment process that time, and these questions were actually used!

When I got it, the first thought was BT's difficulty. 1/3 was okay, and 1/3 was okay. 1/3 was very difficult. But after carefully searching for it for a long time, I consulted some experts and finally got it done. maybe doProgramWe still need to put an end to impetuousness !!

Some of my answers at that time are as follows. please correct me!

1. About ms SQL 2000

1. Server 1 has a database server1.data1 and data1 has a table Table1. Server 2 has a database server2.data2 and data2 has a table Table2. How can we implement inner join between two tables?

Select C. *, O .*
From isystem.dbo.info _ data as C inner join
OpenRowSet ('msdasql ', 'driver = {SQL Server}; server = 192.168.0.94; uid = sa; Pwd = pop', isystem.dbo.info _ data) as O
On C. ID = O. ID
There are several other practices

2. If you use a complex SQL statement from the ms SQL database to extract all the field names, types, constraints of a table?

Select syscolumns. Name,
Policypes. Name
From (syscolumns inner join sysobjects on syscolumns. ID = sysobjects. ID), policypes
Where sysobjects. Name = 'pxzx' and sysobjects. xtype = 'U'
And syscolumns. xtype = policypes. xtype
Union
Select sysobjects. Name,
'Constraint'
From sysobjects
Where sysobjects. xtype = 'C'
And sysobjects. parent_obj =
(Select ID from sysobjects where name = 'pxzx ')

3. How to extract all constraint names of a field?

-- Extract all constraint names of fields
Select sysobjects. Name
From syscomments inner join sysobjects on syscomments. ID = sysobjects. ID
Where text like '% field name %' and sysobjects. xtype = 'C'

4. How can I save a text file to the IMG field and read it out?
When saving text files, you can directly write the IMG field;
If the content is not very long, read and convert the Data Type twice.

5. Implementation of full-text retrieval and how to implement full-text retrieval after a custom binary file is saved to the IMG field?

Performing full-text search in a given database involves the following tasks:
The table and column that you want to register for full-text search.
Index the data of the registered column and fill the full-text index with non-Irrelevant words.
Full-text indexes filled with the registered column query.
The subsequent changes to the data in the registration column should be ensured to be transmitted to the index to maintain full-text indexing and data synchronization.

You can create custom filters to create full-text indexes for storing custom binary files to IMG fields. The process for creating a custom filter is as follows:
Description Filter Structure
DLL implementation and output entry point
Implement filtering Class and Class Factory
Inherit COM interface
Implement the COM interface

6. Implementation Method for checking the constraints between different records in the same data table.

DBCC checkconstraints

1. the. NET component is embedded in the IE browser, and an interface is displayed. the. NET Component interacts with JavaScript scripts to implement. NET components to call JavaScript Functions and JavaScript to call. net public attributes and events.
Javascript is output directly from. net, and the latter can use the <Object> tag...

2. Automatic deployment of. Net plug-ins on the client, including automatic download and automatic security settings.
You can generate an OCX control and use the <Object> label to generate a certificate for deployment.

3. Generate and display caret on a panel for how to implement. Net call to Win32 API.

The class libraries used in C # Are all hostedCode(Managed code) files, while Win32 API function files are all unmanaged code files. This makes it impossible to directly use the functions in these unmanaged code files in C. Fortunately, in order to maintain compatibility with the. NET Framework, and to make full use of previous resources, the interoperability is proposed. Through interoperability, Win32 API functions can be called. Interoperability not only applies to Win32 API functions, but also can be used to access hosted COM objects. In C #, the interoperability of Win32 API functions is achieved through the "dllimport" feature class in the namespace "system. runtime. interopservices. Its main function is to indicate that this attribute method is implemented as the output of an unmanaged DLL.

4. How to obtain the user's sessionid from WebService?
[Webmethod (enablesession = true)]
Public String GETID ()
{
Return session. sessionid;
}

5. How does one start or call win service on the server through WebService and implement the security mechanism?
Reference: system. serviceprocess namespace. You can use the servicecontroller class to connect to a running or stopped service, operate on it, or obtain information about it.
Using system. serviceprocess;
.......
[Webmethod]
Public String getserinfo ()
{
Servicecontroller SC2 = new servicecontroller ("Telnet ");
If (sc2.status. Equals (servicecontrollerstatus. Stopped ))
{
Return "STOPPED ";
}
Else
{
Return "started ";
}
}
Security mechanisms need to begin with web services, that is, identity authentication and authorization;

6. Generate a PDF file using. net.
Implemented, code too long

7. How can I transmit big data from 1. aspx to 2. aspx without using seesion and application?

In the form field: For a domain that needs to send big data, split the data into several copies smaller than the quota before submitting the form, put them in several den domains, and empty the original fields, then formally submit the form. The server still uses request. Form () to read data from various den domains, and then concatenates them in order.

Or server. Transfer, pass a public class to the past

Iii. About Javascript
1. Can I rewrite a javascript-based Web page with built-in simple word processing controls?
I have rewritten

2. dynamically generate menus on the webpage.
So easy

3. XML + XSL custom webpage.

So easy

4. In the web page, use a script to call Word and Excel, and pass the server-side data to Word and Excel?
Javascript can be used to implement functions similar to Web Services. Microsoft. XMLHTTP activexobject is used.