2,736 Topics
 | |
| | hai friend's ny question is about the database storage , in my project i created database for school , in that i create table for attendance for the school so while they enter the atttendance per day it may be 1000entry per day so for a month i will be …  |
| | could u please explain me d difference between 'not exists' , 'not in', 'not all' in detail. Thank You. |
| | I have a database created in Microsoft SQL 2000 Enterprise Manager. I need to change the datatype for a column name EngrMultiplier in the table ProjectReCapParameter. The current datatype is INT and I would like to replace it to FLOAT. What should I do? Write a query or change the … |
| | This code demonstrates how age might be calculated and filtered using the DateDiff method in SQL. Also, note that both the parameters are set to NULL by default, hence making them 'optional' to a certain limit. |
| | I have a users table that has a table titled 'DOB', of format DateTime in MSSQL. Now, I would like to filter rows for all users who are over 30. till now i used this code: [CODE=SQL] SELECT * FROM [User] WHERE [User].DOB > = DATEADD(YEAR, @ageFrom, GetDate()) [/CODE] this … |
| | Hello, can anyone help me find a document explaining a general way to design "Live" tables in SQL? i have an application linked to a db that contains live tables in it (tables that have records always updated, inserted, deleted and many applications read/write in it) my biggest worry is … |
 | File under FAIL: social network widget maker RockYou has fallen victim to a SQL injection flaw and as a result some 32.6 million users are being urged to change their passwords as a matter of urgency. Security specialists Imperva discovered the problem at social networking development site Rockyou.com and issued …  |
| | Hey guys! I seem to be posting here a lot the past few days but as I am new to SQL Server I am finding to quite a pain to get used to! I am having a problem referencing foreign keys. I did post another thread about this but this … |
| | Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record … |
 | my project needs an implementation of supertype-subtype, however, we haven't tackled that topic yet at school. i know the concept of supertype-subtype, but i don't know how to write it out on mssql. i even don't know how to insert data using supertype-subtype. here's the reqs's: * there is a … |
| | Dear members I have a challange. I want to update my CRM database (MSSQL) with turnover numbers from our ERP database. I can retreive the data in different file types from my ERP database so they can be importet as a flat file. But does anybody have a good idea … |
| | I have two databases with the same table name and identical schemas and no duplicate entries. How would I merge the information? SQL 2008 |
| | |
| | Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is the lower case form such as "math" or "science". Since the … |
| | |
| | What I need is the SQL code to display the last business day - usually will be one day prior, but I want that if I run this code on Monday that, instead of Sunday's date, I get Friday's date. This is what I started with [CODE] - Automatically generate … |
 | Hello, I need to make a cursor, which would call a stored procedure to do something for me... but the procedure needs dynamic parameters. first one, it has to retrieve existing ID number from a table and the second parameter will be new value updated... so, for every row, I … |
| | Please see and find out what was the problem. It's seem OK on me but it doesn't work on vb code using SQL Server 2000 [code=sql]"SELECT qry_close_month.Item_code, T_ITEM.item_name, " & _ "Sum(IIf(qry_close_month.Bulan='January',qry_close_month.Stock,0)) AS Jan, " & _ "Sum(IIf(qry_close_month.Bulan='February',qry_close_month.Stock,0)) AS Feb, " & _ "Sum(IIf(qry_close_month.Bulan='March',qry_close_month.Stock,0)) AS Mar, " & _ "Sum(IIf(qry_close_month.Bulan='April',qry_close_month.Stock,0)) … |
| | Hello, I have a big web-site(ASP.NET) with a huge data-base(MS-SQL) and i searched for a good way to use paging in my web-site. I found two good way's to do it but i have a little problem to decide which paging way to use, [U]The first way to is to … |
| | Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), … |
| | Hi everyone, I am currently trying to retrieve data from 3 Access related tables that have been imported into VB2008 DataSet designer. I am not sure whether or not I still need to join the tables. [Code] SELECT R.CustomerID, C.FirstName, C.LastName, R.ExpiryRenewalDate, R.StartDate, R.MailboxID, R.RentalID, M.BoxSize, RT.Personal, RT.Business FROM Receipt … |
| | When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is … |
| | I would like to update 2 fields values from one record to a set of records in the same table: I tryed this: [CODE]UPDATE dd SET dd.comment = y.comment, dd.author = y. author FROM Table1 dd LEFT OUTER JOIN (SELECT * FROM Table1 WHERE Idx=1234) y ON dd.vin = y.vin … |
| | Hi I have a problem where dot is used in a table's column name. Say that there is a column called 101.name in a table t1. How do i reference this column in the following: select ... from table t1, table t2 where t1.101.name='test' This doesn't work because of the … |
| | I have the following query in MS Access 2007 [CODE=sql]SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9 FROM Projects GROUP BY Projects.BIMinspector HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));[/CODE] How do I get it to return a result of zero if no records are found?? Any suggestions would be great. Thanks,  |
| | I am trying to deploy a report to the Reporting Services Server but keep running up against this error: [QUOTE]An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection) Could not obtain information about Windows NT group/user … |
| | Hello, I've got some weird database issue, and I can't figure it out myself, so I'd like to ask for your help. My problem is the following: I've a working ASP.NET solution which relies on a MSSQL 2008 database, Express Edition. Now, I'm working on a WPF version of the … |
| | Hello, We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this? Thanks a lot for your help. |
 | Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER … |
| | last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems] thanks  |
The End.