3,481 Topics
 | |
| | I'm currently converting an application that utilize sqldmo which has a feature .script that can just magically retrieve a script for a particular index for me. Is there a query I can write or a already built in stored procedure I can use to do similar things? Any help would … |
| | Look at this image: [URL="http://www.roflsaurus.com/users/durexlw_QuickUL/SQL_join5Tables.jpg"]http://www.roflsaurus.com/users/durexlw_QuickUL/SQL_join5Tables.jpg[/URL] I want to select everything of tblPersons where all taskorders are connected to that person and where tblSteps.done = 0 and where tblPersons.id = a certain ID... needless to say: my head hurts and I can't seem to figure this one out. Any help is … |
| | I have a form (Delphi 2010) that includes several data controls, including a DBImage. All these are hooked to a underlying MSSQL 2005 database and table. I'm using ADOConnection and ADO Table for ease of use. I need to include image data in this table, so I have set up … |
| | hello to all, i want to connect to mssql which is using windows authentication Can anybody help me with that... i know the server name |
| | hello i am working on this application where i need to import 60k+ user data and insert into different table. i have made a C# application which selects the database and inserts from a text file.like [CODE]insert into dbo.dbname ([user_name],[u_id]) values (a,b)[/CODE] but this apps hangs for 60K+ data so … |
| | Hi Im still quite new when using MS SQL but I have a pretty good understanding of it. -I am using Crystal Reports to retrieve and manipulate data from my database. -I am creating small tables for certain data. -This data is selected from a constantly updating table. So i … |
| | I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this … |
| | please help me on this making a payroll system using MSSQL.. i dont know how to start.. just a simple one.. please.. |
| | Hello, I don't have technical problem. I was just thinking the difference between arrays and SQL. I am currently learning OOP in java and C# but my employment history is based on SQL Server. So I was thinking about this subject in my head and I don't see why bother …  |
| | please help me on this making a payroll system using MSSQL.. i dont know how to start.. just a simple one.. please..  |
| | Hi, I got a question to check if a date time is within another date range (So as to check conflicting schedule) There are various possible types of schedule: 1: One time start - end event. Typically such schedules is like a tour / outing / camp event, and hence … |
| | Hello How can I clone a database in MS SQL 2005 Express? I have the original database and I want to create a new database that has to be the same as the original one. regards, Vedro |
| | When I try to design relation database using MSSQL Server 2008, I find that the MSSQL Server 2008 allow designer can create two relationships with one direction from a table to other table (for example, I have two table A an B, I can create two relationship from table A … |
| | Hello, for a database project (music festivals) several search options are to be included. While some search fields will be filled from a dropdown list (like "countries"), other will have a fuzzy option (like "song titles"). For this I want to use the full-text search (you may remember the words … |
 | Hi, I'm currently designing the schema of my database for an application. and there's this table that has a default content or records. i'm torn between what type should i use for its key, because im always using autonumber, i was thinking that because i have a default content for … |
| | Hi! I need some help please! I have to create a DB that has to be normalized to 3NF. I have a table 'Products' that contains info about all the products - product_ID, product_name, quanitity (left in warehouse), procurement_price, sales_price. And I have [B]TWO[/B] more tables that contain info about … |
| | I am trying to insert data from one column in one database into a column in another db. the tables already have the column in place. they both have a unique identifier column (userid) I wrote a little insert statement, but when I try it I get the following error … |
| | hi, let consider, A table has following fields, name amount date I know to get sum of amount based for particular date condition be.. select sum(amount) as val from table_name where date='06-16-2010' Same as I want to get list of name for a particular date. How can I achieve this.. |
| | I want to store a map that is drawn using Map info software, then store it into the database, but I have not known about spatial data in sql server I tried creating a table using geometry data type like: [CODE] use master go CREATE TABLE Districts ( DistrictId int …  |
| | hello all! Anyone know how to count all the constraints in a given table? I'm new to stored procedure and need it to finish some work. |
| | i try to insert data in database, but i have a problem. example: [CODE]double price = 12,55; mySelectQuery = "INSERT INTO order (total)" + "VALUES (" + price+ ");";[/CODE] now price are 2 values because the ",". now C# see 12 and 55. so a get a error that a … |
| | please tell me how i make a sql query for selecting data's from a table where that data repeated 4 times in that column |
| | Hi all, i want to transfer data one sql database to another database in same sql server. i try to insert into table2 select * from table1 , but this query useful for same database, but i want to use different database, in same sql server. help me here to … |
| | Hello, I have a table which has mail body...i.e. it has html code in the column ..i need to make changes to one of the rows in the mail body column. I have made the changes and when i am trying to copy and paste the column. I am getting … |
| | Hello, I have a SQL Server DataBase and have about 10,00,000 entries to be inserted into the database before the database becomes operational. I am currently performing an insert query for each entry, as they have to be read from a file and decided into which table they should be … |
| | Hello there, Im trying to write a query where if a query is run on a set of tables and the result of that query is null then i want it to run a different query based on different tables. i.e. [CODE]SELECT CASE WHEN (Resulting Value from this query is …  |
| | |
| | I have database for a project i'm working on. yesterday i restored it from an old backup and the schema changed back to a earlier state. but now all the sstored procedures , views etc are missing and the project system can't use it and work. so is there any … |
| | let output string will be, str="01/Mar/2010,02/Mar/2010,03/Mar/2010,04/Mar/2010,05/Mar/2010" Some manipulation, ******* Resultant string should be, "01/Mar/2010,02/Mar/2010<br/>03/Mar/2010,04/Mar/2010<br/>05/Mar/2010" Here I want to replace Comma (,) by <br/> Note: I want to replace even commas only. (before 03/mar/2010 & 05/Mar/2010..like) |
| | Hi, what would you recommend as the best book for someone *new* to SQL and SQL Server (specifically 2005, Developer version)? Thanks!  |
| | Hi guys, I'm learning basic SQL. I have a query I can't solve. Need to create a query named Task1D to list the last name, first name, number of matches, total number of points, for players who have played more than 10 matches and scored more than 330. A portion …  |
| | Greetings - I need your help. I have an SSIS package with a [icode]Data Flow Task[/icode] which has the following Data Flow tasks: [icode]Excel Source[/icode] -> [icode]Data Conversion[/icode] -> [icode]SQL Server Destination[/icode]. The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.) I'm … |
| | Hello I'm working a website that is going to be very,very critical. For now, there is one MSSQL 2005 database online. I'm trying to figure out how to setup mirroring for two MSSQL Servers. (Like two mirrored servers) I understand that you can setup a mirroring like "Server", "Server backup" … |
| | Hi everyone, Wondering if anyone can assist me with this; I've done some googling but haven't come across anything. We have a dedicated server running SQL Server 2005, express edition. I recently set up the server to allow remote connections to the DB engine and everything is working just fine. … |
| | Hi there! I´m with some difficult to do this query. I have this: [CODE]SELECT IDReport AS [ID Report], IDHardware AS [ID Hardware], DataHoraReport AS [Último Report], Versao AS Versão, DataInstalacao AS Instalação, DataUltimaActualizacao AS [Última Actualização] FROM Report[/CODE] in which result this: [URL="http://img189.imageshack.us/img189/6872/26352213.png"]http://img189.imageshack.us/img189/6872/26352213.png[/URL] How can i query those results to … |
| | Hi I have zero knowledge about sql,databases,mssql etc etc. I have installed MSSQL 2005 express edition. What i need i have two access files say data1.mdb and data2.mdb. i need to create a database database1 which has tables from both data1.mdb and data2.mdb. Please tell me how i can do … |
| | [COLOR="Red"]I can't login on the server giving error: 17892. I want to drop the trigger but , as soon as I tried to login, the trigger(Tr_ServerLogon) get executed and login failed.[/COLOR] [CODE] CREATE TRIGGER Tr_ServerLogon ON ALL SERVER FOR LOGON AS BEGIN INSERT INTO AuditDb.dbo.ServerLogonHistory SELECT SYSTEM_USER,USER,@@SPID,GETDATE() END GO /*Where … |
| | Hello again I have 1 well working function and one working stored procedure which counts the quantity of rows in table. Now I've created special table which has only two rows 1. Id (int null)(!++) 2. Rows(int not null) In Rows I want to store the quantity of rows from … |
| | Hi, I am having a table which contains emp_name, basic_pay, PF, other_info. Now i want to display as, emp_name1 basic_pay emp_name1 PF emp_name1 Other_info Like this, Instead of displaying in single row, i want to display in different row based on that emp_name. How Can I achieve this. |
| | I have an mssql database that I need to migrate to mysql. For some reason though any queries to any columns of type datetime are returned in French in the following format: 7/avr/2004 14:00 This also includes all the text of an SQL dump which not surprisingly makes mysql unable …  |
| | Hello All, I am new to SQL Server 2008.I was just wondering if there is any way to add a user as an admin in SQL Server 2008? Is it possible to do using SQL Server Management Studio? Thanks. |
| | I have a table having shop details where shop opening and closing time are available. My need is to find shops that are open in a time range supplied. For Example: Shop1 opens at 9 pm and closes next day at 4 am. Shop2 opens at 1 pm and closes … |
| | Hi I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anybody tell me how to … |
| | I have exported data from sql server to access but the views are exported as tables can you pls tell me how to convert sql server views to ms access 2003 queries please help...urgent |
| | I have tried to upload the xml file into a column with xml type of the database table I use sql statement like: [COde=sql]USE xml_tbl go INSERT INTO xml_tbl(Filename,DATA) SELECT 'file1' a,* FROM OPENROWSET( BULK 'C:\XML\file1.xml' ,SINGLE_CLOB) as a [/COde] or into the existing column: [COde=sql]update tbl_xml set data = … |
| | Hi, i'm using .Net framework 1.0 & MS Access 2003 database. Using ODBC connection, I want to list all tables in ms access database in a listbox....Please help me.... very urgent... |
| | Hello, I have a website (in development) with sql express 2005 db, and I want to upgrade to express R2 2008 version (mainly because of 10gb vs 4gb max db size), how do I do that?, I have win xp os do I need to upgrade to win7? Also I … |
| | When I edit the information from a database table from my program I have made, I get this error: [COLOR="Red"]Cannot update identity column 'ID'.[/COLOR] How do I [COLOR="Red"]SET IDENTITY_INSERT[/COLOR] To ON? |
| | Please someone can help me. I need a function which just returns the number of rows from known table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums int SELECT Count(*) FROM dbo.MainData where id=@id RETURN @rownums END [/CODE] But it … |
 | i have installed microsoft sql server 2005 that comes along with vb.net 2008 but after installing i couldn't find any option for ceating table and database can anyone help me |
The End.