2,935 Topics
 | |
| | Hi, I am having a table with 16 lakhs records in it. Each record contains approximately 50 columns. I am using MSSQL Database. Basically the table contains details of the user's registration details. I have a application built in VB.net which will be selecting a random user_id and then searches … |
| | Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link … |
| | Ich transferiere gerade ein Hosting von einem alten auf einen schnelleren Server. Gleichzeitige Versionsänderung MS SQL Server von 6.5 auf 2000. Dabei habe ich mit einer SQL-Abfrage zu kämpfen. Und zwar sieht die folgendermassen aus: SELECT COUNT(*) AS nrecords FROM ABData WHERE (0=0) AND (MARKE='Dodge') AND (Rubrik='Autos') Cold Fusion meldet … |
| | Hi All, I want to save a large string (>8KB) in to a table feild. How can I do this,Pls help me on this |
| | hi if i have table employee with employee_id as a primary key [b]how can i assign the primary key to the columns firstname and lastname?[/b] table structure is something like this : employee_id int not null, firstname varchar(20) not null, lastname varchar(20) not null the problem is that there is … |
| | hey cna you please explain to me the following <" Because the database also stores all the data of the database itself, each database has a number of system tables. Each new database is created following the Model database model. The Master database keeps track of information about the other … |
| | Hi all, I'm looking for a nice query tool to query MS SQL and/or Sybase databases. Currently, I'm using Excel to do some minor query stuffs...and I don't mind using it but it get's repetitive when you have to do it for 70 different databases. So I'm looking for something … |
| | I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL. Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is … |
| | im working on a asp.net project, sorta like a web portal, which will need a user database. i have a very good understanding of sql. i just want some examples or tips on writing a good user database. ive create a few which i think are good, but could be … |
| | Hello have a good day is there a way to retrive top records by range , i mean like this "select top 15 to 20 record from Table name any condition" i dont mean top 15 or top 20, i mean records from 15-20 take care thanking u in advance …  |
| | trying to get a count of transfers from one account to another account within the same bank relevant columns: table transfers transferid, toaccount, fromaccount table accounts accountid, bank what i have now is select count(*) from transfers where toaccount in (select accountid from accounts where bank = @bank)and fromaccount in(select … |
| | Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye |
| | I got some experience working and managing ms sql databases, but now I am in a need to replicate 2 databases and I can't make it work. Please advise. If it's possible step by step. Thanx |
| | Hi, I've had a website built for me using asp and mssql. Im getting errors relating to the date format in queries being submitted. The asp is trying to insert dates in format dd/mm/yyyy, but after testing my mssql server is expecting the dates in format yyyy/mm/dd. Is there a … |
| | Hello every body, Iam santhosh .I need help.Iam using MS Sql server 2000.I have one database.In a column of one table i haved set that to identity property that property generating serial numbers for that table .But that table is not updating. Table 1 Sno SID Name 1 212 Klen … |
| | Does anyone know how to connect to an MSSQL View in syntax. If you know please right back asap. I need this project done quick. Thanks. |
| | Gallery database -------------------------------------------------------------------------------- Hello averybody I would like to know your opinion how do you design a database that will works as photo gallery, let's count there will be a lot of pictures. Do you save the pictures on the disk or directly on the database? Write please your ideas … |
| | For some reason i cant get the mssql function to be inabled. When i go to view the phpinfo.php that i made to view the extension that are enabled it gives me an error saying that it cant load the extension. So i try to enable the pdf.dll in php.in … |
| | while iam running a jdbc connection program iam getting the following exception : Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc. sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at DBCreate.main(DBCreate.java:7) plz … |
| | I have a value E101 as my empId in my employees table and now i need to increment this value, i.e. E102, E103...etc. How can i get this to work? I've used the procedure but it's not working what am i doing wrong? ALTER PROCEDURE CalcPrimaryKey AS DECLARE @numValue int, … |
| | [B][I]MSSQL Where Statement Problem[/I][/B] [COLOR=BLACK] [LEFT]I want to select all in a column if variable = null I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows … |
| | Situation table1 has 2 columns: userid and requiredInfo It will have an entry for every user table2 has 2 columns: userid and optionalInfo It will have entries for some users but not others Problem: need a statement that returns either userid, table1.requiredInfo, table2.optionalInfo --if table2 has an entry OR userid, … |
| | PLs could somebody tell me how in MS SQL set the default value of a column as the sum of 2 columns column3=column1+column2 where column3 is bigint column1 and column2 are int column1 is primary key with identity incresed by 1 if posibble column2 is a column from another table … |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
| | hi all i wanna to use sql server 2005 but i never use it or any sql server before can any one help me what steps i should follow to learn it i will use jsp . as i used it before but with access thank u |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
| | I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS … |
| | Hi, I have a database table which has a Field called birthday.I want to write SQL script which automatically search database every day and if someones birthday equal today then display a reminder(alert).how can I do this? can anyone help me? Thanks, aish. :o  |
| | I have asp.net C# web application I want to search jobvacancy details using jobrole. if user did not select any value I want to select all the details including null values. this Jobvacancy table has JobRole feild and it allow to insert null values, this is my stored procedure [Code] … |
| | hello i m using MSDE version with the web site i have developed for ASP but i m unable to create guest user for internet access, which is defult builtin account by windows plz help me this is very urgent issue for me take care bye |
The End.