| SQL Server 2000 Interview Questions |
|
|
When i give a browser based application with ASP / HTML as front end and sqlserver 2000 as back end, the ASP coding gets pirated from the computer on which the application is run or from the server in local area network. Any method to keep it safe? Any other platform where coding is safe and application still runs in web browser? will working in ASP.net or VB.net solve my purpose?
|
|
|
|
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
|
|
|
|
Hi, I just graduated from Information Systems Engineering, and I was wondering where my career path should go from now on. I worked as a computer programmer before for a research lab. in my university, it wasn't nothing complicated, just ASPX, Visual Basic .Net and SQL Server 2000, I didn't like it that much and I don’t feel myself as a master programmer, even if with practice comes the mastering I'm not so sure. Is there some IS professional who can tell me which are the possible career options for an IS engineer and that has a nice or very good remuneration.
|
|
|
|
I have an MSSQL SP "t1" which returns resultset contains 10/100 rows. i want to insert them into a temp table in "t2" SP.
ex
Create PROCEDURE t2
DECLARE @TEMP TABLE (val int)
--Get the rows
EXEC t1 @i_id
now i want to insert the rows returned by t1 SP into @TEMP table
in the t2 SP.
Im using MS SQL Server 2000
Please let me know if any one has a solution.
|
|
|
|
i want to copy the selected checkbox from checkedlistbox and want to display it in textbox , and data in checkedlistbox must be retrived from database,
Front End : VB.NET
Back End : Sql Server 2000.
|
|
|
|
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
|
|
|
|
Can I Use Oracle 10g on it?
Can I Use SQL Server 2000 on it?
Can I Use Java on it?
Can I Use Visual Basic 6.0 on it?
Can I Use Crystal Report 8.5 on it?
|
|
|
|
When I try to upload a bunch of tables, the upload fails and throws an error on one of the tables.The error says "Table '<tablename>' already has a primary key defined on it." What could be the possible fix?
Am working with MS SQL server 2000
|
|
|
|
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 using Microsoft SQL Server 2000 (MSDE) and Microsoft Access 2003. I am using the onNotInList event for a combo box on a form. i got a snippet of code that allows you to add a value to a combo box/table if it does not exist. The problem is there is a line of vbcode from the snippet that says "Dim db As Database". "Database does not exist! The combo box is based on a table. Can anyone please show me either how do i get this snippet to work or show me a snippet that allows me to add new values to a combo box/table.
|
|
|
|
i want to copy the selected checkbox from checkedlistbox and want to display it in textbox , and that data in checkedlistbox must be retrived from database,
Front End : VB.NET
Back End : Sql Server 2000.
|
|
|
|
Hi all, i have a problem regarding format of Crystal report, where im displaying data from Sql Server 2000 table.
Table has following fields- date, col1, col2, col3.
Now, the data in report should be displayed as:-
Date1
col1 col2 col3
Date2
col1 col2 col3
Date3
col1 col2 col3
can anyone sort out this problem??
thanks in advance
|
|
|
|
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?
|
|
|
|
Hi guyz! Just wanna ask how to solve my problem regarding the Runtime Error: 20599 - Unable to open SQL Server? I already configure my ODBC connected to the SQL server and it was successful. But the error always appear eventhough I change my p2sodbc into updated version. what seems to be the problem why I cannot execute print preview? I used VB6, SQL Server 2000 and Crystal report 8.5
|
|