Probably a noob question, but I'll go for it nevertheless. For sake of example, I have a Person table, a Tag table and a ContactMethod table. A Person will have multiple Tag records and multiple ContactMethod records associated with them. I'd like to have a forgiving search which will search among several fields from each table. So I...
Hello, It's my impression that schemas are mainly for organizing the tables, view, stored procedures, etc... in a SQL Server database. Do schemas play a bigger role (perhaps in database security, storage, etc)? Some clarification: I'm referring to "object" schemas. Sorry for the confusion. Thank you. ...
Guys, Today we had a very heated discussion at work regarding the availability of a 64 bit version of SSMS and BIDS with SQL Server 2008 64 bit. While I know for sure that such a thing does not exist for SQL 2005, I could neither convince nor prove that this does not exist for SQL Server 2008 64 bit. The lead developer who claims that ...
I am a bit of an SSIS newbie and while the whole system seems straightforward, I don't conceptually understand the process I need to go through in this scenario: Need to map Invoice and InvoiceLine tables from a source database to two equivalent tables in a destination database - with different identity values. For each invoice inserte...
I have a client who has a product-based website with hundreds of static product pages that are generated by Microsoft Access reports and pushed up to the ISP via FTP (it is an old design). We are thinking about getting a little more sophisticated and creating a data-driven website, probably using ASP.NET MVC. Here's my question. Since...
I have a client who owns a business with a handful of employees. He has a product website that has several hundred static product pages that are updated periodically via FTP. We want to change this to a data-driven website, but the database (which will be hosted at an ISP) will have to be updated from data on my client's servers. Ho...
We have a Visual C++ 6 app that stores data in an Access database using DAO. The database classes have been made using the ClassWizard, basing them on CDaoRecordset. We need to move from Access to SQL Server because some clients have huge (1.5Gb+) databases that are really slow to run reports on (using Crystal Reports and a different ap...
hi,guys: I have a stored procedure that named globalsearch. the stored procedure return some results. the problem is how should I get results that is returned stored procedure in sql server 2005.thanks! ...
i have one database, and it contains some columns. My requirement is that how to display each of the data that i stored in the databse on a text box? my code is shown below (after the connection string) conn.Open(); mycommnd.ExecuteScalar(); SqlDataAdapter da = new SqlDataAdapter(mycommnd); DataTable dt = new DataTable(); da.Fill(dt); ...
Hi, When a user enters arabic name and password I am supposed to retrieve data for that user.In java I am using utf-8 encoding I am supposed to retrieve data in the form of arabic text from the database.The database I am using is sql server 2005. and the column is set as varchar instead of nvarchar.Since the database is pointing to prod...
I have one database it contains some user information column including with is Admin column. My requirement is that the loggined user is an admin, then he has a right to see the first name and last name of the users that i stored in the database. If i use select clause, it shows only the loggined person's information. But i want to displ...
Hi all, i am inserting patient details to the database. but when i am submiting the details getting this error "Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query." Here is all my coding: PatientProperty.cs public class PatientProperty { private string Pdisease; priv...
Dear Friends.. Below is my SQL Query which takes more than 10 minutes and still running.... select DISTINCT Auditdata.ID,ns.ProviderMaster_ID as CDRComment from Auditdata AuditData inner join AuditMaster am on am.ID=AuditData.AuditMaster_ID inner join HomeCircleMaster hcm on hcm.Ori_CircleMaster_ID=am.CircleMaster_ID ...
Hi all, I am just confused with the execution sequence of sql query when we use GROUP BY..HAVING with WHERE clause. Which one get executed first?? Please help me. ...
Hi Can anybody explain me what I wrong I am doing in the following piece of code: DataTable dt=SmoApplication.EnumAvailableSqlServer(true); Server sr = new Server("Test"); foreach(DataBase db in sr.DataBases) { Console.WriteLine(db["name"]); } It gives an exception in sr.Databases that can not be connected. ...
Hi, I'm trying to get transactions working under SSIS (SQL Server Integration Services 2005) and Oracle with no luck. I'm using Oracle 10g. I have created a Sequence Container, set its TransactionOption to "Required" and put inside it a DataFlow Task with TransactionOption = "Supported". The server running SSIS has the MSDTC service ru...
In my web page i used a gridview. In this gridview it shows a group of users information. I just added one button from smart tag menu. And my requirement is that when i am hitting the button corresponding to each users, it will redirect to another page and shows the corresponding user's information. What i do for getting this type of out...
Hi, I am using the following query select SS.sightseeingId, SS.SightseeingName, SS.displayPrice, SST.fromDate from tblSightseeings SS inner join tblSightseeingTours SST on SS.sightseeingId = SST.sightseeingId where SS.isActive = 1 and SS.isDisplayOnMainPage = 1 and getting result like this 2 Dinner Cruise Bat...
hi all, I am creating a project which has its own database schema. The other projects which will use the DLL created by my project will have the same schema in their databse that the my DLL requires. But the problem comes if there is a need to change the schema for me, it's not a good option to say this to every client that make these a...
Hi, I usually defining size when declaring parameters in my SP, like : @myParam nvarchar(size) or when I casting or converting: CAST(@myParam AS nvarchar(size)) Recently I removed size from my CAST functions like: CAST(@myParam AS nvarchar) and I'm bit worried if that is going to come and bite me when least expected :-(, since I...