Diffrence
Apr 26, 2007What is the diffrence of MS SQL 2000 to MS SQL 2005?
View 3 Replies
ADVERTISEMENT
DBO Or MDF Whats The Diffrence?
May 11, 2008]First of all here is how i created my SQL database and established a connection in visual studio 05. I go into the server explorer and right click on the data connections node and and select "create new SQL database". A window then prompts me for a server name and data base name. Under server name I write "localhostSQLEXPRESS" and under data base name I put in whatever. This totally worked and the database was asigned the extension of .DBO
I can now insert, select and delete information with some simple ADO coding. The only problem is that using this method makes it seamingly impossible to FTP my database onto my host server. I am aware that I can create a data base in the APP folder by simply right clicking it and selecting " new database".
This would simplify the deploying process but I cant seem to establish a connection this way. Ive also noticed that when I use this method that it saves it as a .MDF instead of a .DBO. What is the difference? Why does my .DBO work but not my .MDF in my app folder? Im so confused over this issue that I am problably not even asking the right question. Bottom line is that I have a small web application with a .dbo database that works wonderfully in my isolated visual studio environment and I need a solution to deploy it on the world wide web. Please help with any information I would be very thankfull.
Why There Is A Diffrence In Speed In That Way ..
Jun 23, 2008Hello all,
I am very astonished about the following (recplus has 4.2 Million records).
if I do this :
select sum (quantityInKg) from recplus where element_ID in (160,
161,
162,
164,
165,
166,
1756,
21707,
22052,
22063)
it takes about 2 seconds.
If I do this
select sum (quantityInKg) from recplus where element_ID in (select element_2_id from element_element where element_id = '159')
it takes 1 second. (select element_2_id from element_element where element_id = '159' gives the same list as in the previous query)
Now, why is there a speed diffrence, or better, why in this way? I would have expected it to be the othere way around !
Thanks for your feedbacks.
Regards,
Fabianus
my favorit hoster is ASPnix : www.aspnix.com !
Diffrence Between Replication And DTS
Sep 20, 2007Hi Experts,
Please tell me the diffrence between the replication and DTS.
If possible plesae provide me the link.
Thanks,
Msrs
Thanks&Regards,
Msrs
Diffrence Between Local And Localhost
Jun 18, 2008 <add key="con" value="Data Source=localhost;Initial Catalog=master;User ID=sa;Password=sa123;Max Pool Size=305;Timeout=30"/>
<add key="con" value="Data Source=local;Initial Catalog=master;User ID=sa;Password=sa123;Max Pool Size=305;Timeout=30"/>
I found the 2 way to connect to database, in first one it uses Localhost but in another it uses Local.
Please tell me which is the better way and what is the difrence between both?
Diffrence Between Metadata Function And Transact-SQL
May 3, 2006Dear all,
I want to know difference between Metadata function and Transact-SQL. When to use metadata function and when Transact-SQL like
To know database exists in SQL Server we have two options
through Transact-SQL
if not exists(select * from sysdatabases where name = 'Testing')
through Metadata function
if db_id('Testing') is not null
When should I use Transact-SQL and when metadata function.
Thanks,
Ashok
In ADO What Is Diffrence Between Cursortype Enum Values
Nov 25, 2006hi
what is the diffrence between the cursor type of the recordset enumeration values in ADO
dynamic
openkeyset
static
forwardonly
thanks in advance.
Diffrence Between Views And Stored Procedures
Jun 18, 2007Hi
what is the diffrence between views and stored procedures in sqlserver 2005
thanks in advance.
Diffrence In Handling Dates Between MSDE 2000 And SQL Express
Apr 27, 2007I have a query that worked fine on MSDE 2000. The query evaluates a date using which is written between ''. Ex '1-1-1970'
Now I detached and attached the database to a SQL Express instance and ran the query but it fails with the error:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
When I remove '' around the dates in the query, all works fine. Is this because of a diffrence between MSDE 2000 and SQL Express?
By the way. I am using the sql.net library which 'creates the query for me'.
Diffrence Between Roles, Accounts, Login, Users Permissions And Groups?
Dec 20, 2000I have jsut started using SQL server 7 and am having problems with accounts permissions, users,roles, groups, owners etc what are the differences?
View 1 Replies View Related