2,935 Topics
 | |
| | Hi all. I have setup phpbb3 successfully in the past with MYSQL. Fast and easy. But my friend has a server that only supports MSSQL. The phpbb3 setup programs states only that "MSSQL Server 2000+ via ODBC is available." I have been spoiled using all the tolls Godaddy has to … |
 | Hi- Here is my question. People, where I work, friends of mine, other programmers, etc. are always talking about "best practices" in application design. Specifically, people are taught/told to minimize the number of SQL queries sent. Now, here is the thing, I am personally under the impression that it doesn't … |
 | |
| | Hi, If someone can help me with this I'd really appreciate it! I installed SQL Server 2000 Standard Edition on Windows Server 2003. This server is due to take over from our present Windows 2000 Server. It was my first time doing a SQL install, so I ended up calling … |
| | hi, I have a table with two columns. i want to insert into first column the values of 2nd column where it is between 7 and 10. the table is #temp as well. so i can not use views... i need to make a function. can you guys please help …  |
| | Hi, I have two table like this: [QUOTE][B][COLOR="Red"]quote_tb:[/COLOR][/B] [B][U]ID item vendor quote[/U][/B] 11 a v1 100 11 a v2 200 11 b v1 400 11 b v2 300 11 c v1 555 11 c v2 777 22 a v1 122 22 a v2 222 22 b v1 322 22 b … |
| | Hi, Wondering if anyone can help me overcome this curious problem... I suppose its both a maths problem and SQL problem... If anyone can help with the Maths OR the SQL would be very helpful! Synopsis: Capture the value of the current 'credit' of a user. Similar to that of … |
| | select myColumn from myTable1 union select myColumn from myTable2  |
| | I have two tables - products and productpropertyvalue I need to select multiple fields from the productpropertyvalue as it corresponds to the product id. The script I am using is select a.id, a.productname, a.siteprice, b.propertyvalue from product a, productpropertyvalue b where a.id = b.productid and propertyid=590 This allows me to … |
| | select CASE WHEN FirstColumn IS NULL THEN '' ELSE FirstColumn END + ' ' + CASE WHEN SecondColumn IS NULL THEN '' ELSE SecondColumn END as ResultColumn from myTable |
| | today i came across to an sql problem from one of the threads in the database forum : to solve the problem i created a table named "names" having these columns : PKID | name | lastname and i entered some rows having the same values for name and the … |
| | hi everyone, I need to know what are the services that sql server has. e.g. reporting etc. can you guys give me a list of these services. thanks  |
 | Here is data EnqSrNo 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 11 11 11 11 11 11 11 11 11 11 … |
| | Hi, Is it possible to install SQL 2000 and SQL 2005 server on a single server? If yes then will it create any problem? Thanks, Kailash |
| | In Turkey we use "." as thousand seperator and "," as decimal seperator. If you are working with currencies in sqlserver, and if the money columns is of type "money" then the problem occurs beause of the seperator issue since in its default mode sql server accepts "," as thousand … |
| | How to insert big html markup with white spaces(i.e. line breaks) and single and double quotation marks to sql server : To insert that big html markup to ms sql server, i tried to copy the markup and paste it to the sql server table cell first. It didnt work, … |
| | Hi I want to write a query which will return me Sum(MarkU) and also the avg. Which is something like (Sum(Sum(MarkU)))/5 in mathematically operation or TotMark = Sum(MarkU) AvgMark = TotMark / 5 I hope you get an idea what i need. How to write this type of query in … |
| | Hi there. i would like this procedure to delete all rows in 'sale' where date_modified < (getdate() +0.02) and all the related rows from 'sale_detail' and 'sale_address' i have written the code below, but ti think this might only delete one row from sale and its related rows in the …  |
| | Hi, currently I have a shared web hosting with MS SQL server 2000 database. I have already implemented the database, with all the data inside the database, on the server. Now I wish to copy the whole database (.mdf) down to my PC, in case I wanna change hosting or … |
| | Hello all. This is my first post. I'm a software engineer with a general knowledge of SQL, but am no where close to an expert, let alone an intermediate. My current issue is I'm working on a query which combines 2 tables: TableA UniqueID Auto Increment ProjectName String <Extra Data> … |
| | I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result. I'm wondering if that is any way to make it simple. My queries looks like this: [CODE] SELECT (A + B) AS C, (D + … |
| | |
| | Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank … |
| | Hi, I'm a newbie in MSSQL. But i already tried using mysql. How can I create a database in mssql. I mean what would be the first step. I had installed Microsoft SQL Server 2005 along with Microsoft Visual C# Express Edition. The following are the tools found in Start>Program … |
| | hi there guys ,, im have just a idiot asking ,, i have sql server 2005 express but im confusing for data work , where can i install that , into server or client , or both>>.??? i know how to basic program in SQL but configuring its merely little … |
| | I am trying to work on a database with 3 tables. To make it easier I have created a couple of temp tables to work out the syntax. CREATE TABLE #owner ( [NameId] tinyint IDENTITY(1,1) NOT NULL, [Name] varchar(50) NOT NULL ) INSERT INTO #owner VALUES ('Thanatoid'); INSERT INTO #owner … |
| | Hi all I have a table in which I save a record each time when a user checks in and checks out the office through a time in/ time out device(this device takes thumb impression of user, thus inserts record) table definition is as follows: checkInOutID (PK,int,not null) employeeID (FK, … |
| | Hi Folks, Just a quickie - can wildcards be used in CASE statements? I have inherited some code and wondered if this: [code] (case substring(anownedby,0,charindex('/',anownedby)) when '2361' then 'GOD' when '2361c' then 'GOD' when '2361d' then 'GOD' when '6206252' then 'BIL' when 'bil' then 'BIL' else 'XXX' end) as branch … |
| | HI I am software tester and want some small project which made in MS-sql server 2000 for the testing even if you have some corrupted file (not virus infected)please provide me . THANK YOU |
| | I have installed a VS 2005 that has a MSSQL Server. When i was about to try running the SQL Server i can't find anything except Configuration tools. I don't know if its express edition or not. Is SQL Server 2005 like this? how would i know that the SQL … |
The End.