Search results for query: *

Hi Everyone, I have a problem when I am trying to update the a page which is created based on the items user selected from previous page. and in this new page(second page), user can change the quantity of the items they selected, and press the update button. After the update button is clicked...

Hi Everyone, I just started learning ASP and wrote my first .asp file in FrontPage...But When I tried to do the preview, the part which was written by using ASP did not show and I did not have either compile error or run time error. I could not figure out why. Can anyone kindly take a look at...

Hi, I create a web page with list of items, the user can select the items and click on "continue" button and go to the next page. In the new page, the items user selected will be listed. I have a update button in the new page, which user can use to cancel the items they selected. All...

Hi Everyone, I don't know if my question should be posted here. But I thought I give it a try. I am trying to use VBScript to develop a webpage (this is a just a way for me to learn VBScript and I never develop any webpage before, therefore, I thought I may learn them all together). My...

Hi Everyone: I have two exact the same databases in the same server with different names, Now I want to transfer one table's data from one database to the other. I know I can use dts to do the data transfer. But I want to know what other options I have to transfer these data? Can it be done by...

Hi Everyone: I am adding a job to MSDE. But as I understand, in order for the job to run, agent must be started and running. Since MSDE does not have EM, how can I tell if the agent is running? if it is not, how to use T_SQL to start the agent? Can anyone kindly give me some help? Thanks alot

Hi Everyone: I need to modify my database, such as adding some columns and moving some data among tables...I have written T_sql code to do this...my question is that when I am running my sql code, I need to stop all current connections to my database and stop user from reading from or writing...

Hi Everyone: I have a table,which has been used in several queries. I have created one non clustered covering index,which covers all the columns retrieved for all the queries,besides the clustered index on the table...for each query, this nonclustered index is used. But for some queries, query...

Hi Everyone: I have a question which may sound silly, but I'd really like to know to answer. My question is that if Transaction log can be reviewed,like the way we review data we write into the database? By review, I mean to open up .ldf file and see what is in it? if yes, how? if no, why?

Hi Everyone: I have a table, which use Uniqueidentifier as a Primary Key. Currently, I have two indexes on the table, one is clustered Index on the PK and the other is nonclustered composite index, which covers the rest of columns in the table....As I have learned that Setting Clustered Index...

Hi Everyone: I have add one column into my table and I want to set the value of this column based on another column in the table,and the following is the code how I do it...but it didn't seem to work...and Can anyone kindly take a look my code and let me know what is wrong? Thanks alot Declare...

Hi Everyone: I have a table which has 7 columns. But this table becames really really large. I am thinking that I should split table into smaller table, based on the one of column,called "Item Name".So each Item Name will have its own table with same columns. But in that case, I have...

Hi Everyone: I have one empty table with two column([Name] varchar, [LookupId] uniqueidentifier default newid()) and I am trying insert data which retrieve from other table into this table... the code is as the following: Insert into [Detail Name Lookup_2][([Name], default)] Select distinct...

Hi Everyone: I am trying to put a quotation mark on a variable, and I did as the following: @SQL = 'select ....from.... where [Detail].[Detail Name] = ' + ''' + @DetailName + ''' but it does not work. and Can one please kindly tell me how to put quotation mark around a...

Hi Everyone: Can anyone please tell me if Null value in the column will take up the whole bytes, which the column data type will allocate. Say I have a column which has data type float (8 bytes),if this column is Null, does SQL allocate 8 bytes to hold this Null value,or does it just allocate...

Hi everyone: I am trying to ceate many tables on the fly with different names. I am using GUID,which I retrieved from another table as new tables names..code is as the following...but SQL keeps giving me syntax error, where @VariableName is being used...Can anyone please kindly take a look at...

Hi Everyone: I have encountered a very wired problem...I have two tables, they both have varchar datatype as primary keys and foreign keys. When I accidentally wrote uniqueidentifier data into this primary key and foreign key columns, I did not have any problem, which is understandable, but...

Hi Everyone: I have created composite index by using Query Analyzer. Because the total bytes of this index exceeds 900 bytes,I got warning message...but index has been created...my question is that if anyone know what will happen if I am writting data into the table and the total bytes of...

Hi Everybody: I have created a DTS package to transfer data between Access and SQL...But I run this package, it generates a large log file...I don't really need to log this transaction...Can anyone please tell me what I need to do to stop SQL writting the transaction to the log file?...Thanks

Hi Everybody: Does anyone know if Enterprise Edition of SQL Server 2000 runs faster than Standard Edition of SQL 2000 if they both are running in Win 2000 Server with same number of CPUs(2 or 4)? I know that you sure can do more stuffs with Enterprise Edition,but in terms of speed, I am not...