|
Foreign key is used to ensure data integrity. If you want to allow invalid entries, I cannot see the point in using foreign key.
|
|
|
|
|
Very new to SQL and I learn by example but cannot find anything like this after tons of searching.
I have an Excel workbook of software application names and versions. Many have the same 'root' name but different version number. e.g. root = "McAfee VirusScan"
sheet columns...
APP NAME -- VERSION # -- MANUF -- INSTALL COUNT
I think a View might be best(?) but no idea how to code it.
The View needs to SUM the INSTALL COUNTs for all similar APP NAMEs & VERSIONs(similar determined by using first few characters or something - options here?)
example:
McAfee VirusScan v1.01 21259
McAfee VirusScan v3.20 14234
... There are thousands of APPs. I will not know all the possible versions.
Anyone do this before and have some example code or could help?
Thx in advance!
|
|
|
|
|
How can I understand you your query should be something like this:
Select sum(Installcount)<br />
from Tablename<br />
group by version
If this don't help you then post your data how is stored on table and post result which you want to get.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Select AppName, Version, Sum(InstallCount)
From table
Group By AppName, Version
OrderBy AppName
|
|
|
|
|
Hello sir I am Convert Access Databse to sql server 2000 please tell me how to convert it
saurabh bhardwaj
|
|
|
|
|
Hi Saurabh,
Please follow these link. That may be helpfull.
Link 1[^]
Link 2[^]
Regards 
|
|
|
|
|
|
I am using Rank() function in my VIEW.
it working in sql2005 but not in sql2000.
Is there any alternative function for Rank() or Row_Number() in sql server 2000?
|
|
|
|
|
No
You can simulate it using a cursor and identity field
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Could you give a sample example for the same?
|
|
|
|
|
Sorry mate you are going to have to do the work yourself, I am willing point the way not do the work. Besides I use 2005 why would i code for 2000.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hey try this
Select IDENTITY(int,1,1) AS [Row Number], FieldName
INTO #Temp
from EMPtable
order by
FieldName DESC
SELECT *
FROM #Temp
WHERE [Row Number] = 10
hope this will help you.
Reasons are not Important but Results are Important.
Swati
|
|
|
|
|
I have a .sql file with sql statements to create tables and procedures likewise,
Now we have to use DB2(client insists) as the database,
Is there any tools or anything can convert SQLSERVER2k sql statements to DB2's?
Any help would appreciate!
|
|
|
|
|
you can use import statement,this means you can run .sql file and then and you must import .mdf file
|
|
|
|
|
I am getting the given below error when I am executing VIEW in sql server 2000.
Msg 195, Level 15, State 10, Procedure UVWCUSTOMERNAME_R171, Line 3
'RANK' is not a recognized function name.
Msg 170, Level 15, State 1, Procedure UVWCUSTOMERNAME_R171, Line 5
Line 5: Incorrect syntax near '('.
|
|
|
|
|
It is available only in sql server 2005
|
|
|
|
|
Is there any alternate way to do in sql2000?
|
|
|
|
|
I have a database "DB_01" whose table are in read only mode. I have another database "DB_02" which at present does not have any tables. I want to copy all tables along with their structure from DB_01 into DB_02. Please suggest SQL query or another mechanism by which this can be achieved.
Thanks in advance.
Ankit Jain
|
|
|
|
|
you can script out the tables, views and procs using management studio.
Use the Red-Gate sqlcompare to generate the script.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have created database in SQL server 20005 which I have detached and kept at a secured storage place. Now after formatting my system, and fresh installation of sql server 2005, when I am attaching this database table, it is adding in read only mode. Please suggest possible method to make it full accessible for all kind of operations.
Thanks in advance,
Ankit Jain
|
|
|
|
|
I have a .NET app I've written in VS2005. On a previous project I used MySQL, and managed to put together a silent install/config bootstrapper together. The installer was made using the Bootstrap Manifest Generator[^], which has worked well for me in the past. The config part was just a .exe I wrote that ran the MySQLConfig.exe with the appropriate arguments and started the service.
On my current project, we'd like to use PostgreSQL (the licensing works out better here). However, I can't get the bootstrapper to install it for me with a test app at all. It says "Installing PostgreSQL" then moves on to install my app, but PG never gets installed. I'm trying to install using postgresql-8.3.msi as my main file, and I've added the following files as "additional" files to my bootstrap package:
postgresql-8.3-int.msi
SETUP.bat
UPGRADE.bat
vcredist_x86.exe.
The only files I would think that I would need is postgresql-8.3-int.msi and postgresql-8.3.msi. Any ideas why it won't install? Is there something I'm missing here?
Thanks,
Dybs
|
|
|
|
|
Some additional information, when I tried installing Postgres as a bootstrapper project with my app, the logfile starts with the following entries:
=== Logging started: 8/21/2008 16:09:39 ===
Action start 16:09:39: INSTALL.
Action start 16:09:39: AppSearch.
Action ended 16:09:39: AppSearch. Return value 1.
Action start 16:09:39: LaunchConditions.
Action ended 16:09:39: LaunchConditions. Return value 1.
Action start 16:09:39: ValidateProductID.
Action ended 16:09:39: ValidateProductID. Return value 1.
Action start 16:09:39: CostInitialize.
Action ended 16:09:39: CostInitialize. Return value 1.
Action start 16:09:39: FileCost.
Action ended 16:09:39: FileCost. Return value 1.
Action start 16:09:39: CostFinalize.
Action ended 16:09:39: CostFinalize. Return value 1.
Action start 16:09:39: InstallValidate.
Action ended 16:09:39: InstallValidate. Return value 1.
Action start 16:09:39: InstallInitialize.
Action ended 16:09:39: InstallInitialize. Return value 3.
Action ended 16:09:39: INSTALL. Return value 3.
Then it lists all the properties that are set for the msi install. After all the properties, the log file ends with:
MSI (s) (D4:A4) [16:09:39:515]: Product: PostgreSQL MUI Wrapper 8.3 -- Installation failed.
I haven't had much luck finding anything about "PostgreSQL MUI Wrapper 8.3" unfortunately. Any ideas? Anyone? Please?
Thanks,
Dybs
|
|
|
|
|
I mostly have things working now. I can run a silent install from the command line just fine. Turns out it helps to have eht INTERNALLAUNCH=1 property set. My other problem was the CREATESERVICEUSER=1 property had to be set (default is 0), although the documentation online said this property only applied to v8.1, and I'm trying to install 8.3.3. Here's the command line I'm using now:
Msiexec.exe /i postgresql-8.3-int.msi /qn INTERNALLAUNCH=1 ADDLOCAL=server,psql SERVICEDOMAIN="%COMPUTERNAME%" CREATESERVICEUSER=1 SERVICEACCOUNT="postgres" SERVICEPASSWORD="admin" SUPERPASSWORD="admin"
However, running the installer as a bootstrap project still isn't working. It will create the postgres user account, but it still won't create the service, and doesn't seem to make any other changes to the system. It gives me a "User account <insert gibberish="" here=""> does not exist." This doesn't really seem to make sense, though, since I'm telling it to create the user account in the first place! Any other ideas?
Thanks,
Dybs.
|
|
|
|
|
I had originally wanted some information about embedding a database into my C# desktop application. After reading some other posts, I think I may have been under an incorrect assumption. Hopefully, somebody can help clarify it for me.
The original concept I was working under was that if I embedded SQLCE into my application, it would be part of the .exe file that is created and I would be able to access that database while it is still in the .exe file (and the end-user wouldn't have any access to that database, other than through the UI).
Now, it appears that although the database itself is, indeed, embedded inside the .exe file, the only way to use the database is to write it to disk. And, if any changes are made to the database, those changes can't be written back to the database within the .exe file.
Am I correct in my "new" assumption? If I want to 'hide' the database from the user, what are my options? So far, I've come up with:
1. Using a password on the database.
2. Encrypting the database.
Are there any others that might work for me?
Thanks.
Ron
|
|
|
|
|
Hi,
SQLCE is a "full" functional database although it is meant for single user desktop applications (as local datastore). This basically means that your application contains following elements:
- application and referenced assemblies
- referenced assemblies to use SQLCE
- actual database files
Changes to the database are always persisted to database files solely by database engine (SQLCE). So the fact that you "manage" the database file(s) through a Visual Studio project, doesn't mean that these files are actually embedded into the exe, but they are only registered as part of the project and can be for example deployed using ClickOnce.
Data can be added, modified and deleted to the database while creating the application and after the deployment by the application.
Then about the security. There are several techniques concerning database protection. Passwords are perhaps the simpliest. If the user can access the data files of the database (via file system) he can use them through different tools so connection password is one way to prohibit usage.
Hope that this answers at least some of the questions,
Mika
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
