dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

Discuss in the microsoft.public.sqlserver.programming forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.programming Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
given the field checked as a bit field, I want to flip the state of checked I would think set checked = not checked would work, but it...
Mac Davis
01-01-2005 10:17 PM
Mac Davis Go to last post
2 66
OK here goes... managed to restore a db to MSDE without the SQL Server client tools, used OSQL and all works well... thanks ! Now using OSQL I...
01-01-2005 09:15 PM
Andrew J. Kelly Go to last post
1 81
I often use a chain of queries to produce a final output. Eg to prepare aggregate data, or to set up generic queries which are then used in...
01-01-2005 08:55 PM
Nickl Go to last post
6 56
Hi, I have a very strange problem. I have one sql 7.0 box, and one sql 2000 sp3 box. An ASP app that we've been running off of the 7.0 is now...
01-01-2005 06:03 PM
Erland Sommarskog Go to last post
2 45
In case you haven't noticed:)
01-01-2005 05:02 PM
Steve Kass Go to last post
5 46
Could somebody point me towards some example cursor code that takes a list of numbers: 1, 2, 3, 5, 7, 8, 9 and formats it into a range of...
01-01-2005 11:53 AM
--CELKO-- Go to last post
10 93
I need a CSV output file with the columns themselves surrounded by quotes. I've tried -c -t"," which gives me the commas, but have not yet found...
01-01-2005 08:44 AM
Erland Sommarskog Go to last post
2 54
I get this message when executing SELECT statement in SQL 2000: Location: recbase.cpp:1374 Expression: m_nVars>0 S PID: 51 Process ID: 2480 Why?...
01-01-2005 08:38 AM
Erland Sommarskog Go to last post
3 46
If I have a table of customer products (let's say product A is a trial and Product B is a full version), how would I write a query that would...
Willie Bodger
01-01-2005 08:19 AM
--CELKO-- Go to last post
4 58
I was hoping for a more streamlined error handling now that we get try-catch but I seem to be running into a few problems. One very important idiom...
Alexander Jerusalem
01-01-2005 05:07 AM
Alexander Jerusalem Go to last post
3 52
Hi all, I've been having problems with an over night job since the 20/21st December, basically the import had been failing because of a problem with...
Rob Meade
01-01-2005 03:07 AM
mark baekdal Go to last post
3 53
I have a clean up project to delete a hundred million rows (from a table of 300 million) that are stale. These rows are children of about 500 parent...
12-31-2004 06:52 PM
Gert-Jan Strik Go to last post
3 61
sql2k. i've read it some where that transaction logs and the TempDb should be place on a RAID 1 (mirror) drive. I have two questions about the...
=== Steve L ===
12-31-2004 05:34 PM
=== Steve L === Go to last post
4 39
I have a table of student incidents, including absences from school, listing the student ID, the date of an incident, and whether it was an...
Nevyn Twyll
12-31-2004 04:33 PM
Nevyn Twyll Go to last post
3 45
I'd like SQL Server to email me on job failures. I've setup a profile through the mail icon in control panel and tested it successfully. When I go...
12-31-2004 03:40 PM
Chau Nguyen Go to last post
7 68
I have a partioned view called members. Partined based on status of the members. Tables : members_11 ( check status=1) members_22 (check...
12-31-2004 11:54 AM
Robert Harmon Go to last post
8 61
We have VB program who queries data (using stored procedure) from a SQL Server 2000 db. The database can grow as much as 10 million records. When...
Paul fpvt2
12-31-2004 11:35 AM
Paul fpvt2 Go to last post
16 97
Hi, I have a suspicion about using Bulk Insert/update on indexes tables whether they bogged down performance or not. Or dropping indexes and/or...
12-31-2004 11:23 AM
David Gugick Go to last post
4 45
Hello, On a users table I have a field which indicates if the user is authorized or not. Is there a Boolean type in SQL database 2000 or should I...
Miguel Dias Moura
12-31-2004 09:34 AM
Hugo Kornelis Go to last post
2 49
The first time the following script runs, it successfully updates permissions. Even if I change the database, the script fails the second and each...
12-31-2004 08:21 AM
garibaldi Go to last post
3 53
Hi all, I have experienced a problem over the last few days with an import job failing - this is being investigated, but I thought it best to setup...
Rob Meade
12-31-2004 08:17 AM
Rob Meade Go to last post
8 38
Hi, I Have the following bit of SQL in a stored procedure: SELECT DISTINCT ref FROM U_NFADHOC WHERE CONVERT(DATETIME,DATE) BETWEEN...
12-31-2004 07:31 AM
Tom Moreau Go to last post
1 53
Every time I startup Query Analyzer and connect a session to the database server, it always by default connects to a certain database. I would...
Mike Labosh
12-31-2004 07:29 AM
Tom Moreau Go to last post
6 57
need help resolving this concatenation error Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) Syntax error converting the varchar value...
12-31-2004 04:32 AM
Hugo Kornelis Go to last post
1 59
Hi Would it be possible for someone to check my code for the stored procedure shown below. I'm passing a date parameter into it, and then checking...
12-31-2004 04:27 AM
Hugo Kornelis Go to last post
1 40
Hi all, I have a problem with a conversion from some functions in Oracle to SQL Server (T-SQL). The functions are: to_char(time, 'dd-mm-yyyy...
12-31-2004 03:36 AM
Hugo Kornelis Go to last post
3 53
Hi! Is it possible to create an database in SQL Server generated in VBScript?? Kind Regards Mehran
12-30-2004 08:45 PM
Tom Moreau Go to last post
3 57
Thanks for the reply. I was able to find http://www.databasejournal.com/features/mssql/article.php/3339681 which looks promising. I got this to...
12-30-2004 07:10 PM
Aaron [SQL Server MVP] Go to last post
6 45
did someone move the thread "to bit or not to bit" to another newsgroup ?
John A Grandy
12-30-2004 05:44 PM
David Gugick Go to last post
1 54
Hello I have 3 tables CREATE TABLE #Players ( Player char(1) ) CREATE TABLE #Scores ( Score smallint NOT NULL,
Lasse Edsvik
12-30-2004 05:40 PM
Hugo Kornelis Go to last post
14 107
Hi all, Does anybody know of a way to perform UTF-8 conversion as part of returned SQL statement from an nText field? I'm dealing with a...
Rick Strahl [MVP]
12-30-2004 04:50 PM
Erland Sommarskog Go to last post
3 56
Hello! Error Message: "Operation is not allowed when the object is closed." What I have is a stored procedure on SQL server that goes and checks...
12-30-2004 03:49 PM
Bob Barrows [MVP] Go to last post
3 65
How can I get the result show below. The rules also showing below. Any help would greatly appreciate. Thank you in advance. IF...
Lam Nguyen
12-30-2004 03:25 PM
Lam Nguyen Go to last post
3 51
Here is my query and it is taking forver to run. Is it in an infinate loop or no? Thanks for an answers. Use...
12-30-2004 03:19 PM
Armando Prato Go to last post
1 149
when utilizing ADO.NET in vb.net or c# ....... is SQLDataReader.GetBoolean() the best way to retrieve a SQL-Server database column of datatype bit...
John A Grandy
12-30-2004 02:52 PM
John A Grandy Go to last post
2 85
Is there any way to get around the prohibition of 'create database' statements in triggers? What I'd like to do, ideally, is have an insert trigger...
12-30-2004 02:44 PM
Anith Sen Go to last post
6 49
Don't blame me for this table. I am just trying to code on it. The Table has 5 fields in it. I have an resultid, questionID, OptionTextboxValue,...
12-30-2004 02:07 PM
Ryan Go to last post
2 57
Hello, Is there a function to convert NULL values to zeros so that they can be used in arithmetic calculations? Any help is appreciated for this...
12-30-2004 01:32 PM
Barry Go to last post
3 48
Hi, I have created a view that uses union all for different fiscal years. example: select * from table1 union all select * from table2 I have...
12-30-2004 01:26 PM
ChuckD Go to last post
10 84
Hi We had some problems with the precision of large incomes in a swiss social security application using SQL Server 2000. So I did some tests:
12-30-2004 01:17 PM
James Ma Go to last post
6 74
I currently have a process where I get zip files with dbase tables. I then take the dbase tables and import them into a staging table. The issue...
12-30-2004 12:16 PM
Anith Sen Go to last post
1 52
I have a batch job that runs daily but is intermitently failing. The job seems to complete okay, but SQL catches an Exception during the execution...
Robert Taylor
12-30-2004 11:33 AM
Logicalman Go to last post
3 59
Hi, How can I determine that if user has installed SQL Server or MSDE on his machine before starting the installation of my app. Thanks in...
12-30-2004 10:45 AM
Leila Go to last post
2 60
Hi, I am in a terrable mess! I would really appreciate a hand. I am in the process of developing a program which has a number of stored...
12-30-2004 10:31 AM
Robert Go to last post
2 71
Hi I have a DB called 'test'. Its primary filegroup PRIM has two datafiles. These data files exist on diff hard drives. I want to restore database...
12-30-2004 10:17 AM
Brandon Lilly Go to last post
6 56
How do you check for the existence of an index on a temporary table without querying sysindexes directly? Brandon
Brandon Lilly
12-30-2004 09:33 AM
Brandon Lilly Go to last post
8 94
I have table of data (tblReport) and a lookup table (xTblReportTitles) that link through tblReport.titleID = xTblReportTitles.xReportID. ...
12-30-2004 09:32 AM
Steve Kass Go to last post
12 88
Whenever a new DB is created a script with several UDFs is run and the UDFs are added. All is done from inside my application. This has worked in a...
Yannis Makarounis
12-30-2004 09:31 AM
Steve Kass Go to last post
9 66
I have table with terms. trmID startDate ...
12-30-2004 09:27 AM
--CELKO-- Go to last post
10 115
Hello, I am in the process of creating a test database for a client. The database will be created out of the actual data in the production database,...
Andrew Clark
12-30-2004 09:27 AM
Andrew Clark Go to last post
5 59
Post New Thread

Display Options
Showing threads 47301 to 47350 of 69242
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.