3,481 Topics
 | |
| | Hello All: Yesterday, I believe, some malware/spyware somehow got into my computer. Windows keeps poping up some messages in ballons showing warnings that "windows has detected spyware" on my system. My desktop wallpaper also changed automatically displaying similar messages. I realized that these messages are not genuine windows messages so …  |
| | 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 … |
 | Hello one of the computers on our corporate network is infected with Antivirus 2009. I scanned is with Spybot 1.4 as I couldn't get the update do to it. I was finally able to install it and everything seemed fine. This was about 30 min to an hr ago. But …  |
| | Hey guys, I have made the unfortunate mistake of allowing an Active X install which has resulted in some sort of virus being installed on my computer. I have similar symptoms as I've read about online such as: [LIST] [*]no drives listed from My Computer [*]VIRUS ALERT! displayed in bottom … |
| | 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 … |
| | Hai, I am a VB programmer and i had developed an ERP software using VB and MSSQL as Backend.On that software i am facing some problems with its speed and data storage capacity.So iam [B][COLOR="Red"]seeking a best language and databse for developing strong high speed software that can use in … |
| | I've been trying to figure this out for months so if someone could tell me how stupid I am that would be great... The first php.ini file works for sharing sessions from domain to subdomain no prob... with the simple inclusion of session.cookie_domain = "mydomain.com" I've tried them both with …  |
| | 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 … |
| | Hi I have 4 comboboxes..and any value that I choose.. I get a whole set of fields displayed in my datagrid view.. I want to make a difference..the value that I choose in the combobox, has to appear green in color in my datagridview. How do I do this ? … |
| | I'm working on what i consider to be one of the hardest DB designs i've ever had to do in my 10+ years of programming/design/architecture. I really need to bounce my ideas off on other experts but i'm having trouble finding the right forums. 1) is this a good forum? … |
| | Hi, I want to select the part no(part_no), transaction date (curr_date), and in stock qty (cost_layer_qty) from table inv_tran where the product first goes into negative quantity. Do I use a group by for curr_date, or how do I do this? Thanks in advance |
| | I got a table that looks like this: ACCOUNT---------NAME------------BROUTE------------BACCOUNT-----------VALUE ---[COLOR="Red"]NEED[/COLOR] 111111................BILL...............77777777...............88888888...............345.34-- 222222................BOB...............77777777...............88888888...............0.0-------- 111111................BILL...............77777777...............88888888...............454.34------[COLOR="Red"]2225.67[/COLOR] 111111................BILL...............77777777...............88888888...............657.67---- 222222................BOB...............77777777...............88888888...............768.32-- 444444................JIM...............55555555...............66666666...............23.12---- 333333................TIM...............55555555...............66666666...............36.58-------[COLOR="Red"]685.02[/COLOR] 333333................TIM...............55555555...............66666666...............625.32--- There are over 62 thousand entries with different values for columns listed above. I want to use (BROUTE + BACCOUNT) as a primary key for this query. "Bank account + bank routing … |
 | |
| | Hi: I am writing code in VB but SQL is the major role here.. I am checking if MFG="DELL" in table1 and if that is there I need a msg box saying "DELL is supported" [QUOTE] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim con … |
| | Can a stored procedure be written with a column name? For Table1 with ColA, ColB, ColC, I want a query like: EXEC sp_Mine 'ColA', '100%' I want the results to be like: SELECT ColA, ColB, ColC FROM Table1 WHERE ColA Like '100%' I tried setting up this stored procedure, but … |
| | Hi! Is there any way I can save a database as an SQL file? Or at least save schema if saving data is not possible. Thanks in adv. |
| | Hi, I have the following data in a table called staging, and it is in the format. C1,C2 and C3 are column Headers. C1 C2 C3 41 te cc 51 te cc 42 te cc 41 te cc 51 te cc 42 te cc 41 te cc 51 te cc … |
| | Hey guys I've got the following code drawn up. But it doesnt work has I wanted it to and can't figure out why. If the user doesn't exist or if that username has been disabled then the query should return -1 otherwise it returns 0. Now that doesn't happen. It … |
| | I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date. When I store the time and then try to check it against the current time I'm runnig into problems. where (timeofevent = Convert(char(19),current_timestamp)) this doesnt … |
| | Hi. I first posted this in the Windows XP Forum, mistakenly. 7 days ago, we started getting redirected to arbitrary websites, our 'Windows XP Home' computer (with 6 separate profiles) suddenly got very slow, and we crashed alot. Norton Systemworks 2007 did not stop initially whatever hit us and could … |
| | Hi all, I m a newbie to sel server. I want to read transaction logs in SQL Server 2000 for doing some processing on them. I asked many persons reagrding this one told me that it can be doone by creating replication of database. so if anybody having any idea … |
| | Hi, Im running MSFT SQL Server Mgmt Studio 2005 and would like to export all the tables in a DB where the # of rows > 0. I would like to export all tables to individual XLS files. I've gone through BCP documentation to no avail. [B]Is there a simple … |
 | I have a table which counts messages sent to a particular department. the important structure is basically ID Department Message DateSent I want to be able to retrieve a resultset where that looks like this: Department MessageCount something like a SELECT COUNT(ID) Where Department=XXX but collect each individual department count … |
| | [code]strSQL= "SELECT ShowsPictures.ID, ShowsPictures.Show, ShowsPictures.LinkToWork, Works.*, Artists.ID, Artists.Surname, Artists.Name FROM Artists INNER JOIN (ShowsPictures [B]RIGHT JOIN [/B]Works ON ShowsPictures.LinkToWork=Works.ID) ON Artists.ID=Works.Artist WHERE ShowsPictures.Show='"&intShowID&"' AND ShowsPictures.PicOnShowsList=True"[/code] I wrote this SQL instruction and it does work with a RIGHT JOIN or a INNER JOIN as second Join (in bold), but doesn't with … |
| | when i want to execute the following expression [code=sql]INSERT INTO Birim ('erol', 'serbest', 'asfsda')[/code] it gives an error like that: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ')'. where is my mistake?  |
| | Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 … |
| | Hi I have table2 and table1. I want to check if table2 values exist in table1. If they do, I want them to be displayed on datagridview in a form. The table1 and table2 have same fields except that the primary key in each table is the serial number. Even … |
| | I want a button click event to do this: can i use "UNMATCHED" keyword in the same SQL Statment using a UNION ? pls help me with this!! table1 is my master Db and table2 is my work DB.. both have same columns expect that primary key in both tables … |
| | the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck … |
| | Or should I say just making sure all columns are created and proper. I have 6 databases I need to keep maintained to a similar level, all standalone. What is the best way to keep the schemas up to date without resorting to manually updating...? Obviously I cannot use DROP … |
| | hello, I'm kinda newbie in databases. I have a table like that: DB is MSSQL 2003 Name is varchar Fruit is int (i used the name just to avoid mess with numbers) the number and the type of the fruit is fixed (in real case are 1,2,3 and 4) Qty … |
| | I need to choose a value from a combo box and check if that exists in a table and if it does..i need to make a button glow green.. I am not sure how I have to check if the chosen value exists in that table.. can you please help … |
| | I have a table with 3 columns as follows: lower upper id 12 20 100 100 150 200 I want to select range of numbers based on lower and upper column. For example I want to display numbers between 12 to 20 or from 100 to 150. How to do … |
The End.