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     
"Raymond D'Anjou (raydan)" wrote Ah, merci:)
08-25-2004 09:26 AM
Pike Go to last post
3 40
yea. you can set SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED -- Roji. P. Thomas Net Asset Management https://www.netassetmanagement.com
Roji. P. Thomas
08-25-2004 09:11 AM
Aaron [SQL Server MVP] Go to last post
5 49
I have a DTS package which has an ActiveX Task. I want to add a line into the ActiveX task that will run the folowing as if it were run from...
08-25-2004 09:08 AM
nh Go to last post
5 45
Hello I need to store small numbers with 2 decimals? 0.22, 0.44, 1.23, at most 2.00 which datatype would suite best? TIA /Lasse
Lasse Edsvik
08-25-2004 08:50 AM
Aaron [SQL Server MVP] Go to last post
10 63
Hello, What is the optimal way to insert multiple rows (around 1000) from a web application into a table? The user enters multiple lines into a...
Arsen V.
08-25-2004 08:41 AM
Toby Herring Go to last post
5 47
Is there any way to filter the following statement on the "Count" colunm? I try Where "Count" = 1 and I get an error, Invalid column name. select...
08-25-2004 08:39 AM
Tamas Bojcan - bojci Go to last post
15 64
In your INSERT statement, specify the column names. And in the SELECT statements, specify the column names. For both, do not specify the identity...
Tibor Karaszi
08-25-2004 08:34 AM
Toby Herring Go to last post
1 39
Hello, I want to format my float number to a precison of .5 i.e: 30.1 => 30 30.5 => 30.5 30.6 => 31 How is this possible?
Guy Brom
08-25-2004 08:21 AM
Erland Sommarskog Go to last post
5 33
Hi, I am trying to make a Resume Database. But there are some issues. I get resumes in word format. I want to store these resumes and be able to do...
08-25-2004 08:18 AM
Erland Sommarskog Go to last post
8 39
Hi all, I understand that when I am denied access from the table but given the right permission in a sproc accessing the table, I am still able to...
08-25-2004 08:07 AM
Dan Guzman Go to last post
4 33
Hi, I use in my data base smalldate data type. When I use select statement the date is like 8/24/2004 12:32:56PM (m/dd/yyyy time). Is it possible to...
Viktor Popov
08-25-2004 07:53 AM
KPiszcz Go to last post
4 51
Niall, The parameters to the method are also passed as the parameter to the sp. So the call should be EXEC @hr = sp_OAMethod @QMAcc, 'MakeKeys',...
08-25-2004 07:46 AM
Roji. P. Thomas Go to last post
3 52
Hi Is it possible to loop through the Files in a directory and delete certain ones based on there names. Would I use FileSystemObject for this...
08-25-2004 07:32 AM
Ian Go to last post
3 34
Hi all, I'm some combination of stupid and stuck in the DMZ between systems. I'm trying to set up a linked server in SQL Server into a Visual...
John Spiegel
08-25-2004 07:26 AM
John Spiegel Go to last post
3 48
Hi all! I have a Windows service, where I want to use a timer.. But i does not seems work?? It does not catch the Timer1.tick event ??? But the code...
Henrik H
08-25-2004 07:13 AM
Roji. P. Thomas Go to last post
1 38
Hi Why would this error stop the execution of my Stored procedure. Server: Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'Server1'...
08-25-2004 06:51 AM
Ian Go to last post
3 37
Hi, Maybe you can help me with following problem: I am running a VC++ program using ODBC to connect to a MS SQL-Server2000 instance (running on a...
08-25-2004 06:37 AM
Tamas Bojcan - bojci Go to last post
1 39
Hi, How to decrypt stored procs? We are using MS SQL Server 2000. Can some one let me know please ... Many thanks in advance, Harish...
Harish Mohanbabu
08-25-2004 06:03 AM
Narayana Vyas Kondreddi Go to last post
2 40
I need to read eventlog entries looking for login/logout events so that I could update a table that tracks the worked hours of the employees in...
David Lightman Robles
08-25-2004 05:46 AM
Narayana Vyas Kondreddi Go to last post
1 42
"exBK" <exBK (AT) discussions (DOT) microsoft.com> wrote It's very difficult to pull back adjacency lists in sorted order, which is why a lot of...
David Browne
08-25-2004 05:26 AM
Harag Go to last post
4 34
Should I explicitly drop temp tables that I have granted or should I let Sql Server handle that for me? My purpose is to release resources. Thanks .
08-25-2004 04:19 AM
Narayana Vyas Kondreddi Go to last post
2 38
declare @b datetime declare @e datetime set @b = '01/01/03' set @e = '12/31/04' select case when datediff(mm, @b, @e) = 0 then 1 else datediff(mm,...
Gregory A. Larsen
08-25-2004 04:17 AM
Roji. P. Thomas Go to last post
2 36
Hello all, What would the difference be between SQL 7.0 and SQL2000 ? The reason for my question is that I have been offered a contract to create an...
08-25-2004 04:16 AM
Jacco Schalkwijk Go to last post
1 49
im a newbie.. i want to learn using function in a stored procedure and query analyser.. any example or url can u offer me?
Savas Ates
08-25-2004 03:59 AM
Roji. P. Thomas Go to last post
2 51
Here is the DDL of my database CREATE TABLE . ( (18, 0) NULL , (18, 0) NULL ) ON GO I have an array of proxy_key (1,2,3,4)
Yaheya Quazi
08-25-2004 01:57 AM
Uri Dimant Go to last post
10 70
Hello, I have two tables named errorstarttime and errorstoptime. Errorstarttime has columns errorid, starttime and errorstoptime has erroridoff,...
08-25-2004 01:33 AM
Saron Go to last post
7 38
Is there an easy way to retreive just the integer portion of a number without using the FLOOR or CEILING functions? Thanks for the help. Derek...
Derek Ruesch
08-25-2004 12:38 AM
Steve Kass Go to last post
4 30
Thanks but passing the params to the SP is not a Problem. SPs balk at the .... AS StaffName, 0 AS ListItems, 0 AS ListComm, etc...
Henry Craven
08-25-2004 12:04 AM
Steve Kass Go to last post
7 37
sql2k sp3 Howdy. Im trying to return the year and quarter in a string inside a UDF and having data type issues. The desired output would be...
08-24-2004 09:24 PM
ChrisR Go to last post
3 43
This is a report & you should use your client side programming language or a report-writer to so such transpositions. SQL resultsets are virtually...
Anith Sen
08-24-2004 09:09 PM
Pike Go to last post
4 42
Hi, I have a web site that is choking when we do a search using the query that I built. I want to be able to use the Index Search from SQL Server...
Rafael Chemtob
08-24-2004 09:01 PM
John Kane Go to last post
1 62
I have the following script that if I execute one step at a time, works fine. However, if I try to execute it all at once, it does not at...
Robert Taylor
08-24-2004 08:06 PM
Tom Moreau Go to last post
11 77
Hi, Can some people tell me how they deal with apostrophe's in varchar column's At present I have created a couple of routines in my .Net code and...
Steve Lloyd
08-24-2004 07:55 PM
John G. Go to last post
2 53
Hello, I'm a bit confused as to what's been going on with the math in SQL Server. When numbers of high precision are being divided they can come up...
Bri Gipson
08-24-2004 06:58 PM
Bri Gipson Go to last post
3 27
I am more of a programmer than a database expert. I was asked the following question at an interview that I could not answer. The question was: Say a...
08-24-2004 05:36 PM
Paul Go to last post
9 35
On Tue, 24 Aug 2004 12:43:07 -0700, "James Ma" <James Ma (AT) discussions (DOT) microsoft.com> wrote: Hi James, Do I understand you correctly that...
Hugo Kornelis
08-24-2004 04:58 PM
David Portas Go to last post
6 35
Thanks for any help. -- Requirement: -- Create check constraint that verifies that newly inserted entries are not overlapping existing -- En entry...
08-24-2004 04:41 PM
news.microsoft.com Go to last post
4 34
Unfortunately you haven't told us which row you want from TableB. TOP without ORDER BY is meaningless and just returns an arbitrary row. Even though...
David Portas
08-24-2004 04:31 PM
David Portas Go to last post
3 53
I found a very strange situation when I was troubleshooting why one of my statements was running so slow for the Alert Service. Take a look at...
08-24-2004 04:23 PM
Tibor Karaszi Go to last post
1 40
Hi all, I have a problem when passing back the custom Error Messages from SQL Server Stored Procedure to VB.Net or VB 6. In my stored procedure , I...
08-24-2004 04:12 PM
Tibor Karaszi Go to last post
3 37
I'm new to the windows side of things and sql server. I'm trying to move a database in msde to sql server. The sql server is a shared hosting account...
Jay Donnell
08-24-2004 03:52 PM
Partha Mandayam Go to last post
3 39
Hi I have a table Create table tmp_name ( name char(15), sales float, yr char (4), mth char (2) )
08-24-2004 03:32 PM
ajmister Go to last post
5 54
SELECT INTO creates the target table. If TableB already exists, you would have to use: INSERT TableB (ColA, ColB, ColC) SELECT ColA, ColB,...
Adam Machanic
08-24-2004 03:14 PM
Roji. P. Thomas Go to last post
9 38
I have a SQL query question. How would i write a query to get the result as in the result section. I have to get all the columns in table 2 with ID2...
David Mohandas
08-24-2004 02:59 PM
David Mohandas Go to last post
6 52
Hi, I have a table like this: CREATE TABLE ( IDENTITY (1, 1) NOT NULL , (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , (50) COLLATE...
08-24-2004 02:52 PM
Tibor Karaszi Go to last post
1 50
Hi, I've got a table whith an index on the CarId column (IdentityIncrement). Now I'd like to write a stored procedure which inserts a new record...
Matthias S.
08-24-2004 02:50 PM
Matthias S. Go to last post
2 50
http://www.aspfaq.com/2501 Maybe some good info here too: http://www.sommarskog.se/dyn-search.html -- http://www.aspfaq.com/ (Reverse address to...
Aaron [SQL Server MVP]
08-24-2004 02:22 PM
Roji. P. Thomas Go to last post
1 38
I am trying to pass the date of 4/05/1955 to a smalldatetime field in SQL server. The value comes form a webform and is passed to a stored procedure...
Steve Lewis - Website Nation
08-24-2004 02:17 PM
Tibor Karaszi Go to last post
6 42
Okay, I'm pretty decent at working the Enterprise Manager GUI to get what I need, and even adept at using Query Analyzer to create and run queries,...
Jeff Cochran
08-24-2004 02:07 PM
Jeff Cochran Go to last post
2 44
Does anyone know if query optimizer (SQL Server 2000) care about cost of locking? The query analyzer shows the same execution plan (and cost) no...
Palmer Eldritch
08-24-2004 01:48 PM
Gert-Jan Strik Go to last post
4 40
Post New Thread

Display Options
Showing threads 52751 to 52800 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.