3,481 Topics
 | |
| | Hi guys, im trying to insert data in different tables one after another, the first table is "Account" with P_key "Username" then have another table called "Student" with P_key "Alumnus_no". Username is a foreign key on "Student" table meaning in order to enter records on Student table Username must exist …  |
| | Hi I have proble to figure up how create databaze schema for text localization. My problem is like i have table with Towns and i need to localizate it to diferent language. Something like London - Londin and so on. Problem: The problem is that i cant create FK to … |
| | hello everyone. i'm a newbie to ms sql but i understand the basics of adding tables and linking them. i have two tables tables that i have linked; Department and Employee. The Department table is the main table with a foreign key in the Employee table. now from by basic … |
| | Hey Guys, Can you please tell me which version of SQL Server is compatible with Vista. I have a Vista Home Premium Service Pack 1. |
| | It has been a long time coming, but Microsoft has finally announced the release to manufacturing of SQL Server 2008. "Microsoft developed this release of SQL Server with the customer in mind," said Ted Kummert, corporate vice president of the Data and Storage Platform Division at Microsoft. "SQL Server 2008 … |
| | [B]Gripe about Microsoft Sql Server Management Studio[/B] I just wasted a day because of sql 2005. I just updated (i know late) but can't believe how buggy it still is. I had set my 'set rowcount' option under to 100 hoping that it would limit the rows i was viewing … |
| | class_db.php is a database class that provides methods to work with mysql, postgres, and mssql databases. Other database types can be easily added. The class provides a common interface to the various database types. A powerful feature of the class is the ability to cache datasets to disk using a … |
 | Good Day All I have SQL 200 and a SQL 2008 in one Machine. At First there was SQL 2000 and i install SQL 2008. Now we have a ilog Application written in C++. am not sure what that developer uses to connect to the SQL. Now the Application can … |
| | Hi, please I need a query that performs the following: I have a table like this: set_id | rec_id 10 | 1 10 | 25 10 | 32 20 | 61 20 | 90 30 | 77 Now I have suppose rec_id = 61 and rec_id = 90 I need … |
| | I'm using mysql as database . I use odbc connector to use the database , it's working fine with select statements ,but when I use insert statement with parameter it is not working. may I know if the command parameter property works with mysql or it only works with mssql.  |
| | I've only written one stored procedure in the past and I'm being tasked again to write another one. The purpose of this SP is to do a bulk insert from a .txt file and then to move the file to an "archive" when it's done with the bulk insert. The … |
| | Hi I have a program that i need it to be a portable prog i meant in destination system there isn't sql server and without it i need my program work successfully but this program used sql server they said me i have to change my database into SQLEXPRESS ,before … |
| | Hello, I have an append query in my access, that is linked with sql server 2005. I want to use an append query that I maked in access, i want to use it in sql server so it can append the records to a specific table. My query is as … |
| | Hello I'm having a problem to calculate the sum of digits from a field. Example: 1234 I want to sum 1+2+3+4, in order to obtain the result 10. Using the following query I obtain the result, but only by mere coincidence: SELECT model, CONVERT (NUMERIC(6,0), SUBSTRING(model,1,1)*1.0+SUBSTRING(model,2,1)*1.0+SUBSTRING(model,3,1)*1.0+SUBSTRING(model,4,1)*1.0) FROM product The column … |
| | I need the query which will fetch the data from DATE_TIME1 to DATE_TIME2 with interval of 2min or 3 min or 15 min which is variable. The DATE_TIME data is available in the table in the interval of 1 min. ex in the table: 29-Aug-2009 10:00:00 29-Aug-2009 10:01:00 29-Aug-2009 10:02:00 … |
| | This has puzzled me for more than a week now. I have been trying to develop a web site for managing a sports league. On of the pages I have is used for changing things like scores and dates and times for games. It is very simple stuff. I have … |
| | I am having a problem restoring my clients MSSQL database onto my desktop using Enterprise Manager. Apparently the database itself contains information about where the original database was backed up from & irrespective of what alterations I make in Enterprise Manager the restore fails. Is there some other program I … |
| | Hi, I have a project in asp.net which includes mssql database. when i tried to back it up simply by copying the folder, I then tried to open the project through visual studio, but it did not open. So how can i back up my project ? also my operting … |
| | How to make a constraint to check if the entered time is in valid form? |
| | How to set the default value of an attribute to the value of another attribute in another table using Visual Database Tools? |
| | |
| | hi, how to save an image into database. ie how to insert an image into database and how to get the image back. i am using the asp.net(C#.net) and mssql server 2000 . so can u tell me the solution. |
| | this open source thing I am using uses typical contains formsof inflections. I will post the exact syntax if you want. However, it does not do partial word search. How do I incorporate wild-card search with contains formsof inflections? |
| | I have this form, and this antinjection. I have checked for anti injection in three places and it still is quite easily injectable. Code: [code]<?PHP $sql_server = "localhost"; //<-- MSSQL server address/ip $sql_user = "sa"; //<-- MSSQL username $sql_pass = "sa"; //<-- MSSQL password $sql_data = "database"; //<-- MSSQL database … |
| | I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used [code=sql]Select * from Table1 Where Name LIKE @Name[/code] but it didnt work. Can you help plz? |
| | How can I add a check constraint to make sure that a date is equal to Today or within the last year and another check constraint to ensure that dateA is equal to dateB or earlier by a maximum of 3 days ? |
| | So, i'm working on VB.NET application but I'm having problem with one MSSQL query. [CODE]SELECT ISNULL(Sezona.NogSezona, '') FROM Trener LEFT JOIN Licenca ON Trener.BrTrenerskeIskaznice = Licenca.BrTrenerskeIskaznice LEFT JOIN Sezona ON Sezona.IDSezona = Licenca.IDSezona AND Licenca.IDSezona=3[/CODE] This is the code I've been using 'til now, but it's not working as I … |
| | I've got the following tables : Em_table Em_No nchar(3) Primary key Em_type nchar(20) , (values it can be inserted into that column are 'P', 'T' and defaults to Work_table(w_type)) . . Work_table w_No ...... w_type nchar(20) values it can be inserted into that column are 'P', 'T' ) . . … |
| | Hi All, Re-doing a giant, old, crusty sp. So here's a questions for all of you. I have two temp tables: #temp_acct_codes and #temp_hour_tracker. #temp_acct_codes contains these two columns in addition to a slew of others: week, hours, date_worked. #temp_hour_tracker contains week, hours_already_worked, 1_0_hrs, 1_5_hrs, 2_0_hrs, diff_hrs, eper_hrs, loc (different … |
| | Hi, I have a table which was holding values in a text field in ISO-8859-1 format. I am wanting to convert this data to UTF-8. I started by changing the field type to ntext. Should I also need to pull out the data, re-encode it in UTF-8 and put it … |
| | hi guys I want know that whether is it possible that to implement Client - Server architecture by using SQL SERVER 2005 EXPRESS EDITION as a main server and on other client PCs also I have SQL SERVER 2005 EXPRESS EDITION . So can i connect to main server from … |
 | I am working with a third party program that sends data and files to a web based repository for our customers. I have rewritten the ASP side of things and cleaned that up but we have run across a problem. The internal (3rd party) software when sending files to the … |
| | So Im editing a page on my site, and I tried to edit a code, because I got an error... cant remember what it is right now, but anyways, I changed it and got another error, something about unexpected T_DNUMBER? Well I decided to change it back, and now I'm …  |
| | I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain queries and updates, but can't seem to find the trigger listed under [QUOTE]MyDB->Programmability->Database … |
| | Hi All! I am working with an MSSQL DB which stores images as blob's. When I pull out the blob it seems to be cut off at a fixed length. Every image only displays the top 1/3 or so. My query is very basic and has no limitations in it … |
| | I want to create a procedure to update a table. It takes number of input parameters(one of them is the @pID) and updates four columns which have the pID=@pID and only one of these four columns can be updated if the value of another column='F' in addition to pID=@pID. How … |
| | I have been reading up quite a bit on the topic of Stored Procedures (SPs) and keep coming across contradicting opinions from various 'SQL experts' on whether or not they should be used. Sometimes it's a downright 'No' ([I]Frans Bouma's[/I] Blog for example -- google the term for the article), … |
| | hello i want two table records in substring query table1 name (membermaster ) column names [B]mficode,centercode,membername[/B] values ex [B]045323,1061,shanthi[/B] table2 name (memberloanmaster) column names [B]loanrefcode ,centercode,closedate[/B] values ex [B]045323/1,1061,2009-04-03,[/B] both tables mficode and loanrefcode and centercode as comman, how do i select mficode and centercode and membername, compare with loanrefcode … |
| | Hi I need to generate a CSV of names and address from a table and I would like only one result (it doesn't matter which) per distinct email address. If possible, they also need to be ordered by DateAdded descending so I can select just the most recent 1000 results. … |
| | I used COALESCE with LIKE in my query: [code=sql]WHERE Column1 LIKE '%' + COALESCE('Togas', Column1) + '%'[/code] apparently the rows with "[" and "]" characters are excluded from query result. is it possible to include those rows in the result? thanks in advance! |
| | Hi I have three MS SQL 2000 Servers distributed as follows: (img Server 1: Name: JBCB_SRV1 OS: Windows 2003 SE DB: MS SQL 2000 Server SE MS SQL Replication: Publisher Source DB: Northwind Server 2: Name: WEB OS: Windows 2000 Server SE DB: MS SQL 2000 Server SE MS SQL … |
 | Is there a way to isolate the nth record from a table using [U]sql queries alone[/U]? The table is a [U]non relational[/U] one and you cannot use any temporary tables...Do u think there is a possible solution for this in MS SQL Server 2000? Otherwise tell me whatever you know? … |
| | Hello everyones, I want to delete where my id has unique identifier in the table in my database.... how can I do it? Thanks |
| | I need to create a table to store matched pairs that I can query and get a count of how many times a particular matchup was entered. For example "5" might be paired with "6", but "6" might be also paired with "5". (Quotes are for clarity - not to … |
 | Hello all, I want to create a custom login form for SQL Server 2005, which will have 2 textboxes(Username,Password). When the users clicks the submit button then i want to check the SQL Server users with that username and password,if exist. I need this to be answered asap! Thanks in … |
| | Dear everybody hope someone can help me!! Im trying to SUM data from 2 different tabels without any ID connection between and I what to subtract the results from eachother afterwards.. how do i do that. lets say i have tabel1.costs and tabel2.profit I would like to SUM the data … |
| | hi. i have to print the time table in database .. like rows and columns. for example like this 1 2 3 4 mon tue wed thu fri sat so ,how to write the query and how to insert the rows and columns .can u tell me the answer.. |
| | hi, i need to print the last row of the table in the data grid form .i am using the sql server and c#.net.. i want to print the recently inserted row of the table.. can u tell me the answer.. |
| | I am trying to do this with sql code without using a cursor. I have table A with two cols and no PK ID Data I have table B with three cols the first two make up the PK ID PK SEQ PK Data If I have the following data … |
| | I have a table with 2 fields category_ID Category_name 1 india 2 china 3 japan 4 africa 5 france I bind these data into grid in aspx page and in that i have given delete command and when i perform delete operation and if i delete china and japan i … |
The End.