2,935 Topics
 | |
| | 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 … |
| | 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 … |
 | Is there any way to know that there was an 'insert' into SQL Server's database without checking it like every minute (in C# / VB.NET)? Thanks in advance. |
| | 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 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 … |
The End.