Hi, I'm new to SQL Server, but an experienced .Net developer. I'm trying to accomplish a query the most efficient way possible. My question is if you can define a temporary variable within a query to store tables or fields. (Like the LET clause of LINQ) My query makes use of subqueries whi...more >>

I am working on a databse on my local box, my source data is on another. How can I link the database and table from one server to another? Currently I am using DTS to just transfer the records! ...more >>

We recently upgraded our MS SQL Server 2000 to 2005. Here is what we did: 1. Perform backup of the database from the old server. 2. Created a blank database in the new server. 3. Restored the database into the blank database located in the new server. After this process, there was an obvi...more >>

I was looking to improve the performance of an ASP.NET application by creating the an indexed view that could be used instead of some of the root tables. What I didn't realize is that it would affect any future conenctions to the root tables. This of course crashed the application on any ty...more >>

Hi, I have a large table with a 'datetime' column that has date and time values in it. The data is in this format: 2007-10-02 09:54:00.000 The table is called 'profile' and the column 'msgdate' I want to return only rows that match a specific date. So far I have the following query wor...more >>

Hi, SQL env: sql server 2000 Target column of insertion: varchar(15) Case, a var is made up of a character of the following characters (random selection): A,B,C,D,E,$,!,%,^,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,&,*,(,) and a few numbers (random selection), and then var = ran1&ran2 ...more >>

How to get a record value instead of aggregated value with GROUP BY? Assume that I have a PRODUCT_COMMENT table defined as below. It logs the multiple comments for products. A product may have multiple comments logged at different time. CREATE TABLE [dbo].[PRODUCT_COMMENT]( [COMMENT_ID] ...more >>

I'm running a PHP call to MS SQL to automatically look in sysbojects and syscolumns to get each table name in realtime so I can make a list and execute it. That part's fine. I'm having problems though getting the name of the first column, so we can use that as the default sort. Can anybody hel...more >>

I know this is a way-out question, and I'm not confident of a positive answer, but I'd like to know whether it is possible to protect/secure a View so that it can only be used as a TARGET in a join operation, as opposed to being used for direct SELECT. for example: SELECT * FROM MyView -...more >>

Hello! I have a problem, and I looking for help if someone can handle this. I use asp.net 2.0, and I create web site which support users from internet (Web Site Administration Tool) and with that option i get database named ASPNETDB.MDF. When someone via page is creating account, database c...more >>

A few collation questions on SQL Server 2005 SP2, which I'll call SQLS. The default collation for SQLS is apparently SQL_Latin1_General_CP1_CI_AS. I wish to use a variation of this, SQL_Latin1_General_CP1_CS_AI collation, but there is no such collation returned from fn_helpcollations(). A...more >>

Good day! Currently I am using MS SQL Server 2000. I wish to delete all data in the database table except data in login table and security table. Furthermore, TRUNCATE is done on stand-alone and child tables, else DELETE is done if table has any foreign key references (normally refer to par...more >>

Hi, How can we execute SQL Scripts using Batch file??? i think Batch file should contain Username,Password,Database and Scripts... Using that file scripts should run... How can i give UserName,Password,Database and all those things? Plz send me details how to do that...if possible with...more >>

Hi at all, I'm trying to bulk insert a uniqueidentifier column from unicode file. In my file I have guid generated from c# application and they are formatted in this way (separated by "|") : guid | field1 | field2 fc0c0c42-438e-4897-96db-8b0489e873ef|field1|field2 In my destination table I...more >>

I have an application providing me with multiple headers which I have mergerd into one big header (below), this header my not always be the same but I need to be able to extract a periodstart and periodend from it. The periodstart will always be the third substring from the end (or 3rd from righ...more >>

Hi, I want to connect to Sql 6.5 server database server, What clientTool should I use to connect it? And also Is it possible to update records in the Sql 6.5 using ADO.net 2.0? Thansk In Advance ...more >>

Hi all, I was wondering if I could get some experienced opinions on SQL hardware to run an ERP app on SQL 2000. The app does not yet support SQL 2005. The ERP app has 25 users and likely won't exceed 30 users for several years. All traffic is on the LAN. The ERP clients basically submit S...more >>

hello everyone. I recently changed the database of a project from Ms Access to SQL server and had to make a lot of adjustments but there's one here where I can't figure it out how to do this in SQL server. I was using the following to create an excel file based on the select from Ms Access....more >>

Sorry newbie question... I have made two different search queries on the same table that both retain the identical column information. $resultfirst = @mysql_query ("SELECT company, address1, address2 FROM table1 WHERE category=active ") $resultsecond = @mysql_query ("SELECT company, addre...more >>

Hi all, i'm using MSSQL Server 2005 Standart Edition. i created ASP.NET application without MSSQL Server 2005 Express. every time i Run my app always show these errors : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may b...more >>

Could Full Index option only be configured during installation? When I try sp_fulltext_table on a table, I get the message that full text is not enabled for the system. --sharif...more >>

Hi all, I want to migrate databases in microsoft sql server 2005 express edition to mysql, please anyone can tell me how can i do this.. i tried installing mysql migration toolkit, but i am getting error, please can anybody tell is there any prior software to be installed to work with migrati...more >>

I'm probably forgetting something basic, but right now I'm stumped. We are moving a database to a new server. bcp'd out the login accounts and bcp'd them into the new server. Restored the database backup and everything was working fine yesterday testing out the application -- this is a 3rd par...more >>

Firstly I consider myself quite an experienced SQL Server user, and am now using SQL Server 2005 Express for the main backend of my software. My problem is thus: The boss needs to run reports; I have designed these reports as SQL procedures, to be executed through an ASP application. Basic, ...more >>

Let's say I have a result set (records) containing numbers such as: 0 1 2 3 9 16 21 45 100 101 102 103 104 105 106 How might someone write a procedure to get the next lowest number in this sequence? In this case it would be: 4. Some combination of Select, Min & When, I am sure,...more >>

We are in the early (development test) stages of upgrading from SQL200 to SQL2005. We have noticed that our backups, created with the append option, are not stored as individual .bak files when viewed through Windows Explorer. From time to time, we have to create disk space by deleting backup ...more >>

I' d like to list all inactive clients. Inactive client is a client who hasn't had invoice for 2 months. I use INNER JOIN to join invoice view (vwDok4FSFZGrid) and clients addresses table (adr_Nazwa). I skip empty values (adr_Ewid.adr_Nazwa ! =''). I select only invoices with date after the in...more >>

I have a client who has been receiving hundreds of SQL timeout error messages in their error logs. Specifically, the message looks like this: MESSAGE : System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the ser...more >>

is it possible to install ms sql 2005 developer edition databse server on window XP professional version 2002 with SP2 or just allows install client version? ...more >>

I have a strange issue and was hoping somebody could explain. The below query gives an ambiquous column name error on an install of SQL 2005 Standard, sp2. This same query works fine on another install of SQL 2000 Standard sp4 and SQL 2005 Workgroup. The order by clause is causing the err...more >>

We have a sql server 2000 sp3 server on a win2k3 server standard edition. This is on dell hardware with a dell scsi dasd enclosure directly attached. We want to duplicate the hardware and replicate or mirror the database to the backup server and do a manual or automatic failover in case of out...more >>

I have an asp site connected to an MS-SQL database, I need to export the database and import it in to a MySQL database? How would I be able to do this? My only way of communicating with the MS-SQL database is via asp scripts. Thank You Ben Sagal PS. i have no problem fixing the SQL code ma...more >>

At the risk of asking a stupid question - Is anyone familiar with either a query against the systables or maybe an outside tool that will provide a list of the most common joins that have been made in user created views? I'm not talking about table relationships that are established at the data...more >>

Do you get any performance improvement by using a Simple recovery model? Full backup run each night, loss of 1 days data is acceptable. This is an ERP app (accounting, inventory, order entry, etc) so a mix of reads and writes, 20 users. SQL 2000 Standard, Windows 2000 sp4, 2gig ram, RAID1 for O...more >>

Hi, I have a situation where I am loading data into a staging table for multiple data sources. My next step is to pick up the records from the staging table and compare with the data in the database and based on the certain conditions, decide whether to insert the data into the database...more >>