im done using the server and it asks me to at the end close squirrel driver from pop up what does this mean ???????????...more >>

can i use a variable in the from clause of a select statement...more >>

I am using SQL-Server 2000 and have created a view namely VW_TEST for the table e.g. TBL_TEST and query in this view is "SELECT * FROM TBL_TEST". Now i ve changed the table design i.e. i ve added new column to table,and while i run the view VW_TEST again the out put of the view is as it wa...more >>

How can we install SQL 2000 on newly installed windows 2003 server while maintaining Server Collation: SQL_Latin1_General_CP1_CI_AS. ...more >>

I am trying to run a query on an SQL database that has a field with the name "LastUpdate". Because the fieldname has "UPDATE" as part of the name I keep gettting the error "Security Error - Cant do DELETE, UPDATE, INSERT, must do SELECT". I have no way of changing the field name. Does a...more >>

the MSSQL server service failed to start due to the ff. error. The sytem cannot find the specified path. What cna i do?...more >>

Hello Upto What size a Mssql 7.0 Database can have, and how much size or how many records a table can handle. please help ...more >>

I keep getting this error message on MickJagger.com, Microsoft OLE DB Provider for SQL Server error '80004005' [dbmssocn]General network error. Check your network documentation. \\64.119.202.29 \VIRGIN\VIRTUALHOSTS\MICKJAGGER.COM\WWW\../../public_script s/news/news_dsn.asp, line 9 c...more >>

Hi, I am trying to connect to database (SQL server 2000) using ASP which is running on IIS server. I am getting the following error when I run asp page. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not e...more >>

What is the SQL query to find the Primary Keys for each user table in a database? Regards, Alan...more >>

I am looking to fix this item: http://support.microsoft.com/default.aspx?scid=kb;en- us;814035 Do I really have to call in and pay for this fix? Has anyone else had this same bug?...more >>

i have the error to start SQL200 OVER WNT4 (udoopen: operating system error 5 (acces is denied.) during openeing of physical device Masrter.mdf...more >>

When scheduling a db Maint. plan for backups, I receive the following error: Operating system error 32. The process cannot access the file, because it is being used by another process....more >>

Where can I get the hotfixe specified in the article? It looks like it should be a 'free' hotfix but the options all cost $$$. Please advise. Thank you. REF: Microsoft Knoledge Base Article 830767....more >>

Is ther a way to change the first column of every table to an identity column. NOT create a new column but change existing first column ? tia...more >>

Hi folks, I've been having a debate with colleagues about precedence rules over AND and OR, regarding how compound conditions are evaluated where no parentheses (brackets) have been used. The real question is "Are there industry standards over the precedence rules for AND and OR?" Take, for exa...more >>

These queries: select ascii('╝'); select ascii('+'); select char(43); return "43, 43, +" respectively. These queries: select * from tbl where field = '╝' select * from tbl where field like '╝' select * from tbl where PARTINDEX('╝', field)>0 return results as ...more >>

I need to create a script to remove the Identity property from a table. Can I do this without dropping and recreating the table? Is there a sp_ stored procedure that would do this? ...more >>

Hi, I am trying to copy a database from a server to another. Both server have sql server7 with SP1. After copying the files to the correct folder c:\sql7\data\ i try to star the sql server but i receive th following error at the even viewer: 17052 : Could not attach the database because the...more >>

Hello, I am trying to break one column into multiple columns based on the content of a key column (I call it a crosstab report). I am using a query that works in Query Analyzer but when I attempt to create a View I get the ERROR: "The Query Designer does not support the CASE SQL cons...more >>

I keep getting this error when preforming a query against a particular column. Anyone know how to get around this? Syntax error converting the nvarchar value '76499A' to a column of data type int. thx...more >>

Hi everyone. I need help with the syntax of a query I'm using to pull data. Here's what is looks like: SELECT studyID, Studydate, Booked, Cancelled FROM Appointment WHERE studydate = 01/20/04 AND booked = 1 Since the database I am querying against has multiple line entries for a...more >>

I am a Network Administrator for my company. We have a few SQL servers in the building but we have no DBA's to take care of them. So I am creating disaster recovery plans in case the server goes down. We are running NT 4.0 with SQL Server 7.0. I backup the Server and SQL DB's using Arc...more >>

How can I append data to a table without having to know the columns in the from table. For example in XBASE I was able to "use" a table and then "append from" another and XBASE would match the field for me. If the used table had 10 fields in common with a append from table then only thos...more >>

I am trying to outpu some records using WHERE. I want only records where employee contains name1, name2, name3, name4, name5, name6 AND approved = No. I can get either all records where approved = No or all records where employee contains name1...., but not both. Here is my query: ...more >>

how do i copy/move data from 1 column to another in the same table for a particular number of rows where data has been entered into the wrong field...more >>

Hi all, Sql server 7 Is there anyway to findout if list of tables that has been modified after august 2003 in a database. Waiting for ur reply. TIA ...more >>

dear sir , i have two table test1 and test2 with same tabel fileds. create table test1 (route char(6) NULL, Driver int NULL) create table test2 (route char(6) NULL, Driver int NULL) in test1 i have date as follow route driver 101 00...more >>

Can I join together tables from different databases. For Example: Test.Customers LS.Shipping If so do you just need to make sure that the full path is specified in the entire query? Thanks...more >>

How do I convert the following to ANSI SQL 92 i.e. use LEFT OUTER JOIN etc SELECT TP.Period TP.SiteId SA.TillId CP.ProductTypeID CP.ProductID CP.CountryProductId IsNull(P.OpenBa, 0.00) as OpenBal IsNull(P.LastShiftClose, 0.00) as LastShiftClos INTO #PosThisPerio FROM NewPositi...more >>

Hey, I need to update a table with the most current date in a table that has just been populated with data from a mainframe where the date is stored mmddyyyy ('12311997') a DTS package inserts the dates into a varchar field. I have tried UPDATE ArchiveControl SET ThruDate = (SELECT CO...more >>

i have various database in our company and would like the others (client pc) able to enter/modify data to the central database in the server. what kind of setup should i plan to have? network setup: multiple pcs 1 server (plan to install ms. sql 2000) do i need special program such as...more >>

I am trying to get infomation from a field that is storing dates. I need to using a date find out what records were processed on that date. Someone told me I could use datediff and I can't quite get the syntax right. I tried Use wss Select * From cartonlist where closedtime>= dated...more >>

drop table mytes g create table mytes sn int code varchar(8) ins_no varchar(6) g insert mytest values(1, '01', 'A' insert mytest values(1, '01', 'B' insert mytest values(2, '02', 'A' insert mytest values(2, '02', 'D' insert mytest values(3, '01', 'A' insert mytest va...more >>

Is it possible, after running a SELECT statement, to print the results pane? I have been cutting and pasting into Excel, but if there is a way to get it to print directly, it would save me some time? T...more >>

We use MSDE in multiple languages. In our MSDE database, we have several DateTime columns. In English MSDE, we format the date in a string as ' %B, %d, %Y %H:%M:%S', so the string comes out like: ' March, 25, 2003 00:00:00'. This works just fine. In using our system with French, we r...more >>

How can I get a list of all of my column names and associated tables in a given database? TIA Mike...more >>

I have been going nuts trying to figure out the correct syntax to update from one table to another. Here is what I have.... Table1 ServerName IPADDRESS BUILDNUM (and a few others) Table2 ServerName IPADDRESS BUILDNUM (and a few others) WHat I am trying to do, is to take ...more >>

H I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem TIA Arrun S...more >>

I have available the month and year integer. I need to generate a query that will get all records where startdate falls in the month and year supplied SELECT * FROM vwEvent WHERE StartDate .... [month] and [year] is the same as the 2 integers I have.... Am I making sense??...more >>

I need to run a query in Query Analyzer that pulls data from three different tables. I need every row from Table 1. I need the corresponding rows from Table 2. Table 2 does not contain a row for every row in Table 1, so I need it to return "null" wherever Table 2 does not have a row corresponding...more >>

Hi, I have a table with multiple date fields per row: NAME PLDAT1 PLDAT2 PLDAT3 Name1 15-12-2003 11:00:00 16-12-2003 16:00:00 16- 12-2003 20:00:00 Name2 15-12-2003 10:00:00 16-12-2003 18:00:00 15- 12-2003 08:00:00 Name3 15-12-2003 18:00:00 14-12-2003 13:00:00 00:00:00 I would ...more >>

Hi all I have a query that looks like so SELECT GLDCT AS [Doc Type], GLDOC AS DocNumber, GLALID AS Person_Nam FROM F091 WHERE (GLAID = '00181913' However by stipulating that GLAID = GLAID I cannot get the person_name as not all the GLALID fields are filled in. from my reading ...more >>

How do I write a query in sequel which will return the date and time of when a row was written to a table. Thanks in advance...more >>

what are the different type of constrains available in SQL server2000...more >>

My Director of IT has just upgraded our old 2000 server to 2003. Now my database, running on a SQL 7.0 platform doesn't work-- it's not compatible. Luckily this is just a Terminal Server and not our live server. I've checked around and see that even SQL 2000 isn't compatible with Serv...more >>

Dears, I have a table with SQL Commands in it, and I want to create a result set with the values powered by these commands. I'm intending to create a stored procedure with a temporary table with that values and use it as a result set. Is it possible to make it using EXECUTE (@SQLCOMMAND...more >>

How do you establish which version or service pack of SQL Server 2000 is installed?...more >>

How do I format a stored number to the required number of decimal places in SQL For example, I have the number 200.357 I would like to display the number, showing two decimal places only i.e. 200.3 any help would be greatly appreciated Regards Wes...more >>

Can anyone help me? I would like to create a stored procedure that is retrieving data from some table. But the 'table name' and 'column name' must be variable, so I can change them. Example of what I mean: ------- declare @mycolumn varchar(50) set @mycolumn = 'TIME_DATE_1M' declare...more >>