2,736 Topics
 | |
| | i tried to add a database file to an exsiting Website project. i get this error. "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly." installed products are visual studio 2008 sp1 sql server 2008 however creating a data connection to a database attached with … |
| | Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer] int. Example data: [Date] [ServedTime] [TotalCustomer] 8/9/2008 12:00:00AM 8/9/2008 9:23:00AM 12 8/9/2008 12:00:00AM 8/9/2008 9:27:00 AM 7 8/9/2008 12:00:00AM 8/9/2008 9:37:00AM 9 8/9/2008 12:00:00AM … |
| | Hi, i have a problem with SQL, im verry new to it and in the beginner guides and tutorial you can't learn anything of the special tricks. I have developed a Access db, and i need to use the INSERT INTO statement to insert the current record id of a … |
| | Hi Friends, can some body help me in designing the below scenario: MY QUESTION IS HOW WOULD THIS INTERFACE LOOK LIKE? Objective: To design an interface for the following scenario. See attached image for visualization. Scenario: 1. There is an Application X (May be a VB or Java application) and … |
 | I have a datetime column in a T-SQL table that I need to sort desc. However, when I do this the NULL values for that field will show up at the bottom. I need them to be at the top of the list, while still having everything else sorted in … |
| | Hi, I have a question. Am aiming to install sql 2005 in one server and connect my applications which are put into another server to it. My applications are built in .NET2003 with .NET framework 1.1. Now I know that to install SQL2005 I need .NET framework 2.0.My question is, … |
| | Help - I am fairly new at MS SQL, but understand the concepts and have looked at the code in MS Access many times. But here's my problem: I need to create a complex query across multiple tables within the same database, but I'm just not sure how to do … |
| | We have a need to see if data exists in a field based on an ID and Date. The data we have exists in a table as follows: ID DATE ISSUE 903 01/15/08 3,2,1,,,,1, 903 01/15/08 3,,1,,,,,1, 903 01/16/08 ,,,,,,,,1,, 903 01/16/08 ,,5,,,,4,,, 903 01/15/08 ,,,,,,,,, 904 01/15/08 ,,,,,,,,, 904 … |
| | Hello, i'm very new here in these forums. I'm making a webpage for registration for my online game's server. My problem is in the registering part, i've got the query to register the new user on the database, but first i need to check if the name of the account … |
| | My database knowledge is pretty limited but im hoping this will work...... The idea is to have a database for customers who have their grass cut fortnightly. The database will be mail merged to form bills every month or so... So far I've constructed a database with the following tables: … |
| | I'm writing a program determine employee's working hours in a day by entry and exit clock in classes. In sql, I have a table, there are 4 field like : classID, cardID, date and clock. Teacher come to class and every teacher have an unique card. Card reader read this … |
 | Hi, I want to create a DataBase Diagram using MS SQL Server Management Studio 2005. But on context menu of DataBase Diagrams Folder, I am not able to see New Database Diagram menu item for any of the Database. I am getting only two menu item "Working with Sql server … |
| | Hi, I want to join a table with itself to get all possible combinations of the variable Name in two columns. My first attempt was this: [CODE] SELECT P1.Name, P2.Name FROM Pairs AS P1 INNER JOIN Pairs AS P2 ON P1.Group = P2.Group WHERE P1.Name <> P2.Name [/CODE] The thing … |
| | how do i select data from a table by sorting the first word from a column? for example: "user1 hello" "user2 one two three" "user3 where are you" "user1 im fine" how can i select all the data starting with "user1"? |
| | So, I've been poking around in MS SQL for a while and it kinda looks like Access a little, but it seems harder to enter data, change data, etc. Not very user friendly to a person used to Access. I've been using Enterprise Manager and Query Analizer, but it takes … |
| | I did find a thread that kinda answered this, but it was from last year, so I thought I'd start a new thread about this: In Access the data type is memo, what is the 'memo' data type in MS SQL? I might possibly need to have space for 15,000 … |
 | I've developed a software using VB6 and MSSQL 7.0. Now I need to create a backup-restore program on behalf of my software. For this I need to fetch down all the table names located inside the database used in the software. My database name is -->BILLING_SYSTEM and I've also created … |
| | Hi, I need help on this sql. I have a table a and b and i need to select where a.id=b.id and b.mid=1 and few hardcoded a.id which does't exist in table b. i used left outer join but its still listing all in a table. Can anyone help pls. … |
| | Hello to everyone! I'm developing a C# application that manages an Access database. In order to perform a word search within the database registers, I have used a SQL command based on the 'LIKE' condition. I attach the complete code below: [code] myConnection.Open(); OleDbDataAdapter adapt_pregunta = new OleDbDataAdapter(); string query_c … |
| | Hi all, Does anyone have any experience with a PHP Web-based form builder/administrator that's designed to use MS SQL? I know there's a lot of PHP/MySQL-based products out there, but I have to use MS SQL. I need to be able to create Web forms relatively easily with a Web-based …  |
| | |
 | Can MS SQL can convert accented characters to non-accented characters? Ex. Ã -> A Thanks |
| | Hello everybody,, I'm developing a web application using ASP.NET and i'm new in databse (basic knowledge:) ) ,,and i have to create a table that stores any changes made in the database tables includes (insert,update and delete) ,,i googled about how to do it and i found many articles about … |
| | Hey guys I have installed SQL Server 2005 Developers edtion and I have noticed that I dont have SQL Management Studio feature available. I am currently in the process of reinstalling just incase I missed out an option during installation. What concerns me is: Is Management Studio available on SQL … |
| | Hi, i juz wanted to know how to write this following codings in app.config. In ASP.Net in web.config: [Code]<configuration> <appSettings> <add key = "stu" value = "database = Gred; trusted_connection = yes; server = (local)"> </appSettings> </configuration>[/COde] N in codings part: [COde]Imports System.Data.SqlConnection Dim con As New SqlConnection (ConfigurationSetting.AppSettings("stu"))[/COde] Now … |
| | I have 2 tables, a table with header records and a table with detail records. If I run the following, I am shown that I have 96 duplicate rows. select item_id,count(*) from in_qty_price_bracket_hdr where item_id is not null group by item_id having count(*) > 1 The item_id field is not … |
| | hii i wanted to insert questions, options and correct answer in the database(Multiple choice questions). I have around 8000 questions to be inserted. I tried with copying entire content from word into notepad and provided delimiters for questions and answers but the entire question appears in a single line(it is …  |
| | Hello all, I'm having a problem with converting a script from MySQL to MSSQL .. the problem is within this query: [CODE]select * from data where name LIKE '$name' AND spot LIKE '$line' AND piret LIKE '$piret' [B]AND timestamp >= '$before' AND timestamp <= '$after' ORDER BY timestamp DESC[/B][/CODE] the … |
| | I am new to MS SQL. I would like to create a table variable and insert some and and get the data from a java file. I am able to declare and table variable and insert the data into the table. But when i try to get "Must declare table …  |
| | Hello, Before posing question I have googled on pivot query,pivot sql query but none of the sites explained the syntax abut making a new table from a pivot query .And that's the reason I asked the question .I know the pivot query but how make a table of the results … |
The End.