Interview Question in sql server |
|
|
|
This is a sample objective type test on MS SQL Server 2005 with interview questions. The topics covered in the test are Indexes, SQL Queries, Database Structure and Normalization for Software Engineer, DBA Database Developer.
You can try the test here: http://www.wiziq.com/online-tests/9120-sql-server-interview
|
|
|
|
|
|
please i really confusing with this new structure of visual web developer compare to the old one visual studio.net 2003.
|
|
|
|
|
|
visual studio .net 2003 and sql server 2003..
are they combatible ?
please tell me the steps in installing sql server 2003
i wish to develop ASp.NEt web applications .. i have windows XP Pro. is there anything important to note while installing SQL like installing IIS for the .NET ?
thanks anyway..
|
|
|
|
|
|
visual studio .net 2003 and sql server 2003..
are they combatible ?
please tell me the steps in installing sql server 2003
i wish to develop ASp.NEt web applications .. i have windows XP Pro. is there anything important to note while installing SQL like installing IIS for the .NET ?
thanks anyway..
|
|
|
|
|
|
plz help me to slove connection time out problem.
i am executing query from sql sever 2000 itself
e.g. "select * from tablename".
its taking too much time and continuously remains in execution mode and
then gives time out error.
but when same query execute again its giving me result in 0 second.
what could be the reason. why sql server not giving response some time.
i m excuting query from sql server studio so there is no matter of sql connection.
pls help me out...............
|
|
|
|
|
|
iam making a college project using asp.net & vb.net & sql server 2000 as database....
pls tell me in detail how to create a sessions for each user that exists in database...
i have created a regsitration form & its working where a user can register himself on the website...
now i want this user to enter his/her uers id & password & when he/she click on the LOGIN the session begins until he cliks on the LOG OFF button & also time out for these users if they exceeds the time...
pls tell in detail & more easily to grab it easily....
thank you...
|
|
|
|
|
|
|
I work in a bpo. My company has put out a notice for software support. They are asking people with vb, sql server 2000, asp and visual interdev skills. Does any one know the kind of questions I am supposed to get during the interview? What can I expect?
They have dialers, and most of their software applications deals with database as long as they deal with operations support. They also maintain employee profile. I means these are the things that the varous things that the company does; now can you figure out some questions they'd probably ask?
|
|
|
|
|
|
|
i have 50 mb of databse in my server. which datatype is better for name and address of my customers (char or varchar)in sql server 2000. which datatype occupy less space in my 50 mb. thanks in advance
|
|
|
|
|
|
|
i doing one application in .net1.1 with sql server 2000 along with share point 2003. my application is that it should monitor user or employee logon and log off detail from server. for that i get that from event viewer its working fine but it also want to capture user idle time.please give me suggestion to solve it . i don't want any s/w for it it should calculate automatically.i don't want any application or s/w to calculate it.and user are connected in lan connection.my server is windows 2003 sp2
|
|
|
|
|
|
what is the use of apache.
what do i need to for installing apache.
How to use it.
i have sql server 2000
|
|
|
|
|
|
|
I am working on a web application in ASP and sql server 2000. I have made an enquiry form to store visitor's data base in sql server 2000. I want send him an Automated "THANKS" email on the email id entered by him on the said enquiry for. How to do This? What is the exact coding for it?
|
|
|
|
|
|
if I install j2se on my computer, must i install jdbc driver on my computer separately?
or if i have sql server 2000, has it jdbc ? and no need to install?
|
|
|
|
|
|
i am using vb.net and sql server 2000
create table mytable(country varchar(20),city varchar(20))
insert into mytable values('Ethiopia','Mekelle)
insert into mytable values(('USA','newyork')
insert into mytable values('England','Chelsea')
dim str as string
str=select * from mytable where country=' "&txtcountry.text&" '
then when I enter country name from the textbox
let me enter, Ethiopia, USA, England, it works fine becuase these values are available in my table but when i try to enter values that don't exists on my table, i want to transfer it to other textbox or to dispaly as error message,
let me try to enter, kenya,then since 'Kenya' is not my table ,i will expect error message so how can i do this?
|
|
|
|
|
|
|
i am using sql server 2000. the application is made in vb & database is ms access please can some one tell me what is the problem.
|
|
|
|
|
|
|
I'm having trouble converting Datetime from Character string with sql server 2000 any ideas?
|
|
|
|
|
|
hi,
I am developing a web site with 2 pages in asp.net.the first page requesting a username and pass and then second page will show some information about the logged in user from sql server 2000. I want to make this page accessible for users of my organization's domain. I do copy my project in wwwroot folder but I don't know how should I access it and run it from other computers.
|
|
|
|
|
|
Hi
Well i created a desktop application using dot net technology and sql server 2000 as a backend database server.
i want my application to run over network but the data should be store in the main server. in simple words i want a client server communication of my desktop application with one server and different clients
|
|
|
|
|
|
|
i hve sql server 2000 installed on my pc...i want to load a database by using the mdf file but when i m trying to execute the attach command it is showing an error that "could find row in sysindexes for database id 9,object id 1,run dbcc chktables in sysindexes"....how can i rectify this reeor and load the database from mdf file plase provide detailed information
|
|
|
|
|
|
i'm creating stored procedure in sql server 2000 that take data/row from two databses and display output ,i'm using asp script to display output.
i've 2databse namely vishal& vishal1,each databse there is 1 table ,iwant to take 1 row from vishal & 1 row from vishal1 & disply it using asp.
|
|
|
|
|
|
|
do mysql has GUI feature like sql server 2000? Where can I create database in mysql?
|
|
|
|
|