Search Results

Search found 53054 results on 2123 pages for 'sql sample database'.

Page 123/2123 | < Previous Page | 119 120 121 122 123 124 125 126 127 128 129 130  | Next Page >

• Designing a game database

  - by Ronald

  I'm trying to design a database to record game histories for a game I'm working on. I have 3 different tables: users, gamehistories, and gamescores. Columns for tables: users: uid, displayname, email gamehistories: gid, pubID, start (datetime), end (datetime) gamescores: gid, uid, score I am trying to produce the following result set given a userID (uid): Opponent's displayname, my score, opponent's score, duration Any ideas? Is my design ok? How can I query these tables to get game histories for a given uid?

  Read the article

• SQL Server add a column constraint to limit data to -1 to 1

  - by Seth Spearman

  Hello, I want to constrain a SQL Server decimal column to only allow -1,0,1 as valid values. Can you show me the SQL syntax for adding such a constraint. (I would like to know how to do it in both the CREATE TABLE statement and/or the ALTER TABLE ADD CONSTRAINT). Or can this only be accomplished in a trigger? Seth

  Read the article

• How to rewrite this SQL statement to LINQ 2 SQL ?

  - by Shyju

  How can i convert this SQL query to its equivalent LINQ 2 SQL statement for VB.NET? SELECT COUNT(*) AS 'Qty', IV200.itemnmbr, IV200.locncode, IV200.bin, CAST(IV112.Quantity as int) as 'Qty2' , 'parentBIN' = isnull(MDS.parentBIN,iv112.bin) From IV00200 IV200 (nolock) inner join IV00112 IV112 (nolock) on iv200.itemnmbr = iv112.itemnmbr and IV200.bin = IV112.bin and iv200.locncode = iv112.locncode left outer join mds_container mds (nolock) on isnull(mds.locncode,'nul') = isnull(iv112.locncode,'nul') and isnull(mds.containerbin,'nul') = isnull(iv112.bin,'nul') where IV200.bin = 'MU7I336A80' group by IV200.itemnmbr, IV200.locncode, IV200.bin, IV112.Quantity, isnull(MDS.parentBIN,iv112.bin) order by IV200.itemnmbr

  Read the article

• Quickest way to fill SQL Table with Dummy Data

  - by Alex

  What is the quickest way to fill a SQL table with dummy data? I have a wide table with about 40 fields of different kinds (int, bit, varchar, etc.) and need to do some performance testing. I'm using SQL Server 2008. Thank you!

  Read the article

• Is this query vulnerable to sql injection?

  - by user294924

  $myq = sprintf("select user from table where user='%s'", $_POST["user"]); I would like to know if the above query can be exploited using SQL injection. Is there any advanced SQL injection technique that could break sprintf for this particular query?

  Read the article

• architect users feed in database

  - by islam

  dear i want to make architect for application like google reader so how i can architect -organize- users feeds(rss,atoms) in database with best performace way.

  Read the article

• Create Table by Copying Structure of Existing Table

  - by tyguy840

  I am trying to create a new table by copying an existing table in SQL Server 2008 using Management Studio. The existing table contains no data. I am using the following code but am receiving an error for Incorrect Syntax near AS. I am not sure what is wrong here. I am a SQL newb and any help would be appreciated. Thanks. CREATE TABLE Drop_Centers_Detail AS (Select * From Centers_Detail)

  Read the article

• "Access 2002 vs SQL Server 200*" as DB for sharepoint

  - by Jake

  I work with a team that has a sharepoint site currently runnning and its lists are linked to an access DB. My question is really on the investment level, what would be the reasons to upgrade DB to sharepoint if only a few 100 users access this site. Is there a real benefit to replacing the DB with a version of SQL Server, escpecially if about to replace Access 2002 with 2007 some day. I know SQL Server can handle more memory and traffic for more users, but I'm looking for more reasons than that if there are any.

  Read the article

• Non-Linear Database Retrieval

  - by pws5068

  I'm building an article system, and each article will have one more Tags associated with it (similar to the Tags on this site). The tables are set up something like this: Article_Table Article_ID | Title | Author_ID | Content | Date_Posted | IP ... Tag_Table Tag_ID | Name ... Tag_Intersect_Table Tag_ID | Article_ID Is it possible query an article and all of its associated tags in one database call? If so, how is this done?

  Read the article

• Can Visual Studio.NET 2008 integrate SQL 2008?

  - by burntsugar

  Visual Studio 2008 ships with SQL 2005. I would like to integrate SQL 2008. Are there significant reasons why one could not/ can not do this?

  Read the article

• Visual Studio 2005 doesn't support Sql Server 2008

  - by Erez

  I'm developing Reporting services on VS2005 and have to connect to SQL Server 2008. The following Error occurs: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later." I found on the net a patch for it, but it doesn't work (link to patch) "The upgrade patch cannot be installed by the Windows Installer Service because the program to be upgraded is missing, or the upgrade patch may update a different version of the program." what else can I do ? :(

  Read the article

• Is it possible to have a multilanguage Environnement in SQL Server 2008 ide

  - by Alexandre Jobin

  Hi! is it possible to install another IDE language to SQL Server 2008 Express like i can do in Visual Studio? In the options of Visual Studio, i can change the Environnement Language. Can i do the same with SQL Server 2008? alex

  Read the article

• SQL Error Locating Server/Instance Specified

  - by leen3o

  Having a problem moving a site from Win2003 IIS6 w/ SQL2005 Express to a Win2008 IIS7 w/Fill SQL 2005? I keep getting this error Desc : SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Can anyone point me in the right direction

  Read the article

• How to convert EER to SQL Table?

  - by Khajavi

  I have no problem with converting ER to SQL tables, but I don't know how can I convert EER to SQL tables? as you Know that EER has "is a" specification and inheritance, but I don't know how relational databases can connect with inheritance specification

  Read the article

• Varchar with trailing spaces as a Primary Key in SQL Server 2008

  - by cacaupt

  Is it possible to have a varchar column as a primary key with values like 'a ' and 'a', is gives always this error "Violation of PRIMARY KEY constraint" in MS SQL Server 2008. In Oracle dons't give any error. BTW I'm not implementing this way I'm only trying to migrate the data from oracle to sql server. Regards

  Read the article

• what is the difference between triggers, assertions and checks (in database)

  - by Am1rr3zA

  Can anybody explain (or suggest a site or paper) the exact difference between triggers, assertions and checks, and also describe where I should use them? EDIT: I mean in database, not in any other system or language.

  Read the article

• Create a user-defined aggregate without SQL CLR

  - by David Pfeffer

  I am planning on deploying a database to SQL Azure, so I cannot use the SQL CLR. However, I have a need to create an aggregate function -- in my case, I need to STUnion a bunch of Geography objects together. (Azure is expected to support Spatial by June.) Is there another way to accomplish this, without making use of the CLR, in a query? Or do I have to create a UDF that will take a table as a parameter and return the aggregate?

  Read the article

• Database Table of Boolean Values

  - by guazz

  What's the best method of storing a large number of booleans in a database table? Should I create a column for each boolean value or is there a more optimal method? Employee Table IsHardWorking IsEfficient IsCrazy IsOverworked IsUnderpaid ...etc.

  Read the article

• Alter Sql table (Change foreign key to Second primary of the table)

  - by vix

  Hi, I've a sql table with a primary key(Auto Incremented) and a foreign key.Now I need to modify the table by modifying the foreign key to second primary key so that its values are not allowed to duplicate. How do i alter my table without affecting the data? Need the sql code. Regards, Vix

  Read the article

• Access denied when starting SQL Server Express from command line

  - by Brettski

  Windows 7 computer running SQL Server Express 2008 (sp1). When I try to run net start mssql$sqlexpress I receive an error: System error 5 has occurred. Access is denied The SQL service is running under "Network Service" account The service starts fine if I use the services window. Could somebody help me figure out why I am receiving this error?

  Read the article

• How to get parameter values for dm_exec_sql_text

  - by Ted Elliott

  I'm running the following statement to see what queries are executing in sql server: select * from sys.dm_exec_requests r cross apply sys.dm_exec_sql_text(r.sql_handle) where r.database_id = DB_ID('<dbname>') The sql text that comes back is parameterized: (@Parm0 int) select * from foo where foo_id = @Parm0 Is there any way to get the values for the parameters that the statement is using? Say by joining to another table perhaps?

  Read the article

• SQL Express 2005 to SQL 2008 Workgroup for Sharepoint WSS 3.0

  - by smacca20

  I am trying to migrate sharepoint wss 3.0 databases from SQL Express 2005 to SQL 2008 Workgroup edition. I have backed up the database, but not sure how to best attached/restore them to the new version and get up and running again. Thanks

  Read the article

• How to import data in SQL Compact Edition?

  - by Peter

  I don't seem to find a tool for it, nor an odbc driver. Thanks UPDATE : I'm aware of the sql scripting possibilities. But than again : how to script a sql 2k table? (not just ddl, but data also?) Of course you can write this all by yourself, but importing data into CE cannot be such a hassle, or can it ? UPDATE2 : I don't seem to be able to choose the right dialect for inserting

  Read the article

• Please tell me what is error in my date comparison sql query

  - by Rajesh Rolen- DotNet Developer

  Please help me to find out error in my SQL query. I have created this query to compare dates select * from Joinplans jp where cast(convert(varchar,GETDATE(),103) AS datetime) BETWEEN CASE(convert(varchar,jp.planstartDate,103) AS datetime) AND CASE(convert(varchar,DATEADD(DAY,jp.planDays,jp.planstartDate),103) AS DATETIME) It's giving me the error: incorrect near 'AS' I am using SQL Server 2005.

  Read the article

• Database design for heavy timed data logging

  - by user293995

  Hi, I have an application where I receive each data 40.000 rows. I have 5 million rows to handle (500 Mb MySQL 5.0 database). Actually, thoses rows are stored in the same table = slow to update, hard to backup, ... Which king of scheme is used in such application to allow long term accessibility to the datas without problems with too big tables, easy backup, fast read / write ? Is postgresql better than mysql for such purpose ? Thanks in advance BEst regards

  Read the article

< Previous Page | 119 120 121 122 123 124 125 126 127 128 129 130  | Next Page >