A company C # engineer's test question! (Ask the experts)

prince_zxb

The following are the test questions. I ca n’t write the storage process, and of course I wo n’t call it. Others will. It ’s not easy to find a job after graduation. This company ca n’t get in, but I also ask experts to help me with a simple storage. Pass the code, (as long as, 1.3 and 4.1\4.2) give me a code example, class, call me, but for the sake of convenience, I posted it together / thank you,


＜A＞ Write SQL script with Notepad. Features:
 1.Create a SQL Server database on this machine
 2. Create a data table t, which includes three fields: A, B, and C. The A field is a variable-length character type with a length of 10 bytes; the B field is an integer type; and the C field is a floating point type.
 3, write stored procedures prT_Add, prT_Cha, PrT_Del, the function is to add, modify, delete records on the table T, respectively.
＜ 二 ＞ Dreamweaver design user interface for operating data table t
＜ 三 ＞ Write a function with Javascript_ to verify the correctness of the data entered by the user.
 1.The content of field A cannot exceed 10 bytes
 2. The content of field B cannot be character data, and the data cannot overflow
 3. Field C cannot be character data or integer
＜ 四 ＞ Write C # WEB program (B / S structure). Features:
 1. Write classes Add, Cha, and Del to call stored procedures (prT_Add, prT_Cha, PrT_Del) to access the database.
 2.Call the corresponding classes (Add, Cha, Del) in the corresponding event procedures.

entwine

Always write something ready
@_@

wy2400

create database test
GO
use [test]
GO
create table t
(
A varchar(10),
B int,
C decimal,

PRIMARY KEY CLUSTERED
(
A ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
create proc t_Add
@A varchar(10),
@B int,
@C decimal
AS
insert into t values(@A,@B,@C)
GO
create proc t_Update
@A varchar(10),
@B int,
@C decimal
AS
update t set B=@B,C=@C where A=@A
GO
create proc t_Del
@A varchar(10)
AS
delete t where A=@A
GO

ccba2660

Such a boring test question,
Now people like to come up with some silly questions to show their skills

sunnyppp

The company shouldn't have such questions

The most important thing for programmers is not how to write code!

personal opinion

jetliqb

What broke the company, don’t they use IDE?

Can these basic questions be tested by engineers?

crasis

Haha, all the posts upstairs are out

sami520119

Is it for the fresh graduates? ? sweat! !

codealxe

Ha ha, there is no need to write code by hand

wdh3139593

Okay I will