Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
Retrieve Records In Reverse Order
I would like to get the records out starting with the last in first and so on. Is there a way to do that with using Order By.<br><br>My select statement is as follows:<br><br><div class="msgQuoteWrap">...
I would like to get the records out starting with the last in first and so on. Is there a way to do that with using Order By.<br><br>My select statement is as follows:<br><br><div class="msgQuoteWrap">...
answer(4) view(675) status(
)
)
help me!!
How to input "New" image if a record is new
How to input "New" image if a record is new
answer(2) view(362) status()
)
Urgent!!! Help! --Update records in database
Haiii......<br>I have an error like this--><br><br>Error Type:<br>Microsoft JET Database Engine (0x80040E14)<br>Syntax error in UPDATE statement.<br><br>I want to update records in my database......
Haiii......<br>I have an error like this--><br><br>Error Type:<br>Microsoft JET Database Engine (0x80040E14)<br>Syntax error in UPDATE statement.<br><br>I want to update records in my database......
answer(1) view(222) status()
)
help on random from database only...
sorry guys!!! me just manage to change something to my code... so please help me on the randomize part... i am not good on randomize... whenever i clicked on refresh all my item seem to change place... sorry thanz... <br>my code<b...
sorry guys!!! me just manage to change something to my code... so please help me on the randomize part... i am not good on randomize... whenever i clicked on refresh all my item seem to change place... sorry thanz... <br>my code<b...
answer(0) view(340) status()
)
Synchronizing 2 databases
I have a MS SQL server database.<br>I want to synchronize this database with the Microsoft Outlook database <br>(The synchronizing program should access the Outlook database using the Outlook API provided by Microsoft).<br>...
I have a MS SQL server database.<br>I want to synchronize this database with the Microsoft Outlook database <br>(The synchronizing program should access the Outlook database using the Outlook API provided by Microsoft).<br>...
answer(0) view(783) status()
)
MSSQL 7.0 on Windows Server 2003
Anybody have any ideas if MS SQL 7.0 is compatable with Windows Server 2003?
Anybody have any ideas if MS SQL 7.0 is compatable with Windows Server 2003?
answer(1) view(246) status()
)
Internal server error 500
Hello, Any one here can help with a SQL prblm ? The setup is a Windows2000 with IIS cluster and a BE SQL DB The following message appears on clients browser: "Internal server error 500" "Exception:Exception" ...
Hello, Any one here can help with a SQL prblm ? The setup is a Windows2000 with IIS cluster and a BE SQL DB The following message appears on clients browser: "Internal server error 500" "Exception:Exception" ...
answer(4) view(328) status()
)
Login and authentication problem.
Login and authentication problem. Currently, I have two seperate mssql db's, one of which supports the primary functions of my website, and another which is solely for a forum I have recently decided to add. I did this so that one db wo...
Login and authentication problem. Currently, I have two seperate mssql db's, one of which supports the primary functions of my website, and another which is solely for a forum I have recently decided to add. I did this so that one db wo...
answer(1) view(715) status()
)
Info.
I want to learn MS SQL SERVER 2000. But I have no idea where to start from. Could someone plz. let me know if I can make reports and create forms in MS SQL Server. Also if you could suggest a online course and recommend me a book on ...
I want to learn MS SQL SERVER 2000. But I have no idea where to start from. Could someone plz. let me know if I can make reports and create forms in MS SQL Server. Also if you could suggest a online course and recommend me a book on ...
answer(1) view(522) status()
)
How do I convert Access into SQL DB
Hi <br><br>I am running a website driven by a database. Its an Acess 2000 DB. It obviously isnt powerful enough as i am getting errors about connections etc & am told its because there are too many hits for access to cope wi...
Hi <br><br>I am running a website driven by a database. Its an Acess 2000 DB. It obviously isnt powerful enough as i am getting errors about connections etc & am told its because there are too many hits for access to cope wi...
answer(10) view(754) status()
)
Compare ADO, OLE DB, ODBC, SQLHELPER
Hi, I am a newbie to database, I read there are many connection ways such as ADO.NET, OLE DB, ODBC, SQLHELPER. What are their difference in connecting to a MS SQL 2000? What criteria to decide to use which one? Thanks
Hi, I am a newbie to database, I read there are many connection ways such as ADO.NET, OLE DB, ODBC, SQLHELPER. What are their difference in connecting to a MS SQL 2000? What criteria to decide to use which one? Thanks
answer(2) view(383) status()
)
Saving (') appostrophe in DB
hello, i am building an asp page that saves an 5000 + char through a form in a varchar field. This field dosent accept appostrophe (') and i have tried all other fields. They interpret this appostrophe as a command i think. Is ther...
hello, i am building an asp page that saves an 5000 + char through a form in a varchar field. This field dosent accept appostrophe (') and i have tried all other fields. They interpret this appostrophe as a command i think. Is ther...
answer(2) view(237) status()
)
SIMPLE open, write, close example anyone?
SIMPLE open, write, close example anyone? Hi - just wondering if anyone had a SIMPLE example of html page with asp code opening, getting name, writing name, close ???? I need a SQL (not Access example). It would be much appreciated.
SIMPLE open, write, close example anyone? Hi - just wondering if anyone had a SIMPLE example of html page with asp code opening, getting name, writing name, close ???? I need a SQL (not Access example). It would be much appreciated.
answer(1) view(17) status()
)
Select Query
ok try this<br><br><br>SELECT MAX(salary) AS Expr1 FROM employee WHERE <br>(salary NOT IN ((SELECT MAX(salary) AS Expr1 FROM employee<br> WHERE (salary NOT IN (SELECT MAX(salary) AS Expr1 FRO...
ok try this<br><br><br>SELECT MAX(salary) AS Expr1 FROM employee WHERE <br>(salary NOT IN ((SELECT MAX(salary) AS Expr1 FROM employee<br> WHERE (salary NOT IN (SELECT MAX(salary) AS Expr1 FRO...
answer(2) view(329) status()
)
Determin SQL Syntax from ODBC connection
How can you determine from the ADO/ODBC connection what identifiers are used in the SQL Syntax. <br>I want to know after the connection has been made to the database what I should encapsulate <br>column and tables names with tha...
How can you determine from the ADO/ODBC connection what identifiers are used in the SQL Syntax. <br>I want to know after the connection has been made to the database what I should encapsulate <br>column and tables names with tha...
answer(2) view(161) status()
)
Error: Invalid object name
I have this error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Cajas'. /sanjose/ventas/tira.asp, line 14 The object n...
I have this error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Cajas'. /sanjose/ventas/tira.asp, line 14 The object n...
answer(1) view(739) status()
)
Inputing a date into a database(Access 2000)
Hello just hoping that someone could help<br>i am trying to input a date into my data base but it won't accept it <br>i have the format saved as ShortTime<br>and this is my code for it to be placed into the db which is Acc...
Hello just hoping that someone could help<br>i am trying to input a date into my data base but it won't accept it <br>i have the format saved as ShortTime<br>and this is my code for it to be placed into the db which is Acc...
answer(3) view(149) status()
)
date problem
hi all... here is my code Set con = server.creteobject ("ADODB.Connection") con.Open "mydb" resultupdate = "INSERT INTO db (date) VALUES (#"&now()&"#)" con.Execute resultupdate ...
hi all... here is my code Set con = server.creteobject ("ADODB.Connection") con.Open "mydb" resultupdate = "INSERT INTO db (date) VALUES (#"&now()&"#)" con.Execute resultupdate ...
answer(2) view(245) status()
)
Stored procedure returns unpredictable results through OLEDB
Can anybody suggest a reason why a stored procedure would behave differently depending on whether it was executed from Query Analyzer, or from an ASP page via OLEDB? Identical parameters are used in each case. Through Query Analyzer t...
Can anybody suggest a reason why a stored procedure would behave differently depending on whether it was executed from Query Analyzer, or from an ASP page via OLEDB? Identical parameters are used in each case. Through Query Analyzer t...
answer(1) view(599) status()
)
dsnless problem
What Am I doing wrong with this?<br><br><%<br>' FileName="Connection_odbc_conn_dsn.htm"<br>' Type="ADO"<br>' HTTP="false"<br>' Catalog=""<br>' Schema="...
What Am I doing wrong with this?<br><br><%<br>' FileName="Connection_odbc_conn_dsn.htm"<br>' Type="ADO"<br>' HTTP="false"<br>' Catalog=""<br>' Schema="...
answer(1) view(112) status()
)
Error Saving Database Diagrams
Hi, I was wondering if there were other people that had experienced the same problem as we are presently experiencing. I was trying to save a database diagram on one of our development servers, when a pop-up window appeared stating that ...
Hi, I was wondering if there were other people that had experienced the same problem as we are presently experiencing. I was trying to save a database diagram on one of our development servers, when a pop-up window appeared stating that ...
answer(1) view(228) status()
)
SQL server user account
Hi Listers, I have a MSSQL 2000 database on a hosting company server! they provided me one SQL username which has the Administrator permissions! I am publishing the database using XML forms (Access Data Pages) I was wondering how can I ma...
Hi Listers, I have a MSSQL 2000 database on a hosting company server! they provided me one SQL username which has the Administrator permissions! I am publishing the database using XML forms (Access Data Pages) I was wondering how can I ma...
answer(3) view(391) status()
)
connect via Enterorise Manager Sql server
Hi listers, I just signed up to this forum and I have a problem that I hope you can help me. I've developed a MSSQL server 7.0 database. I have a host company supporting MS SQL server databases. I'd like to connect to that database from m...
Hi listers, I just signed up to this forum and I have a problem that I hope you can help me. I've developed a MSSQL server 7.0 database. I have a host company supporting MS SQL server databases. I'd like to connect to that database from m...
answer(3) view(785) status()
)
SQL Server 2K inserting a new column
I am trying to positionally insert a new column into an existing table via a script I want to write. I know I can do this through the design mode in Enterprise manager, but how can I enter a column, say in position 6, of a current table, u...
I am trying to positionally insert a new column into an existing table via a script I want to write. I know I can do this through the design mode in Enterprise manager, but how can I enter a column, say in position 6, of a current table, u...
answer(1) view(303) status()
)
sp_who
Hi! I exec. in query analyzer SP_WHO and in the column named CMD apear NOP. Someone cant help me to know what means. Thanks.
Hi! I exec. in query analyzer SP_WHO and in the column named CMD apear NOP. Someone cant help me to know what means. Thanks.
answer(1) view(44) status()
)
Saving Files
Hi, How can I save any file (.doc, .pdf, .txt) any file to the Sql Server 7.0 database. Thanks in Advance. Kamliesh Nadar
Hi, How can I save any file (.doc, .pdf, .txt) any file to the Sql Server 7.0 database. Thanks in Advance. Kamliesh Nadar
answer(1) view(379) status()
)
Schedule a Stored Procedure on a HOSTED DB???
I need to run a stored procedure (on a hosted server) every 24 hours. The hosted server won't allow me to store jobs, so that is out.... I do have a local SQL server, is it possible to store the job on the local server, but have it run on ...
I need to run a stored procedure (on a hosted server) every 24 hours. The hosted server won't allow me to store jobs, so that is out.... I do have a local SQL server, is it possible to store the job on the local server, but have it run on ...
answer(2) view(56) status()
)
Update ... from ...
Hello. I am a little lost... in the use of update ... from ... Let us assume I have something like this: UPDATE parts SET id_geometry = b.id_geometry_duplicate FROM parts a INNER JOIN fn_duplicate_parts(@id_project) b ON a.id_p...
Hello. I am a little lost... in the use of update ... from ... Let us assume I have something like this: UPDATE parts SET id_geometry = b.id_geometry_duplicate FROM parts a INNER JOIN fn_duplicate_parts(@id_project) b ON a.id_p...
answer(2) view(394) status()
)
truncated ADO record return
I managed to upsize my database from Access. Even have my ADO / ASP pages redirected and working -- almost. My last problem is... I'm calling a recordset, and then displaying record contents in a table, looping through each individual re...
I managed to upsize my database from Access. Even have my ADO / ASP pages redirected and working -- almost. My last problem is... I'm calling a recordset, and then displaying record contents in a table, looping through each individual re...
answer(1) view(802) status()
)
SQL server DB and ASP
Hi all, Here is a strongly ASP related question for you guys. I have a SQL server database on my host company server. I need to develop an application (ASP based) to let the user update the tables via Internet! I was wondering if it i...
Hi all, Here is a strongly ASP related question for you guys. I have a SQL server database on my host company server. I need to develop an application (ASP based) to let the user update the tables via Internet! I was wondering if it i...
answer(1) view(983) status()
)
Programming
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved