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     
What is the best way to capture the unique id used on an insert from with in a stored procedure? I need to write it into a field in another table. ...
Andrew Jones
08-19-2004 12:56 PM
Andrew Jones Go to last post
2 39
Hi, Can I have serial numbers in in my select result. Like the serial# in PL/SQL -hari
G Harikumar
08-19-2004 12:47 PM
Itzik Ben-Gan Go to last post
3 41
I need to modify a column, keeping only the numeric portion, and discarding all else, e.g. retaining ' 41.2' where the original value was '41.20...
08-19-2004 10:18 AM
Gregory A. Larsen Go to last post
2 40
You should be able to find out how to do that in this article I wrote. Look on the third page under "Deleting All But the Most Current...
Gregory A. Larsen
08-19-2004 09:52 AM
Louis Davidson Go to last post
5 35
Hi, I'd like to ask you if you know how to substitute NULL values in the result set. When I do a select statement I have a column in which I have...
Viktor Popov
08-19-2004 09:47 AM
Viktor Popov Go to last post
3 60
Hi This question has probably been answered numerous times before, but my very limited experience with SQL has not enabled me to find the...
Aslak Ege
08-19-2004 09:39 AM
Uri Dimant Go to last post
2 38
Table: t1 col1 col2 100 null 101 null 100 null 102 null Table: t2 col1 col2 100 150
08-19-2004 08:34 AM
Hugo Kornelis Go to last post
1 42
I have the following stored procedure @Name nvarchar(20) = 'Smith' AS SELECT ContactID FROM Contacts WHERE (ContactLastName = @Name)
Nikolay Petrov
08-19-2004 08:05 AM
Tibor Karaszi Go to last post
5 53
I have built the stored procedure below but when i try and get it to return a resultset using dates i get Server: Msg 241, Level 16, State 1,...
Steven Scaife
08-19-2004 07:43 AM
Steven Scaife Go to last post
3 35
I have table1 with ID1 AND ID2 as primary key. Then I have table2 which include also ID1 and ID2. I would like to have all records from table 1...
08-19-2004 06:48 AM
simon Go to last post
2 46
I have a table with two columns Date and Time I have made their default values to GETDATE() How can I format the date in this columns so it inserts...
Nikolay Petrov
08-19-2004 06:47 AM
Uri Dimant Go to last post
2 48
Hi, Is there a way to get just an empty result from a int column that has a NULL value inserted into it ? When I try using ISNULL I get number 0 as...
08-19-2004 06:43 AM
Mika Karjalainen Go to last post
4 42
Hi Do database options such as SET NOCOUNT ON have a life. If I set it on in one stored procedure and forget to switch it off does that affect all...
08-19-2004 05:55 AM
Wayne Snyder Go to last post
2 38
Dear SQl Experts, I am getting following error while ececuting the Sp. "SqlDumpExceptionHandler: Process 14 generated fatal exception c0000005...
Akash Uday
08-19-2004 05:26 AM
Tibor Karaszi Go to last post
1 42
Dear All, i have a table called test_table if we "select * from test_table" then name -----------
08-19-2004 05:10 AM
angus Go to last post
3 36
groups.google.com/groups?selm=2869101c46445%24d8673520%24a401280a%40phx.gbl -- Anith
Guy Brom
08-19-2004 05:03 AM
Itzik Ben-Gan Go to last post
6 44
Hello, please show me an example (real t-sql code), how to retrieve multiple rows in each fetch from rowset using t- sql cursors. Regards
08-19-2004 04:38 AM
Tamas Bojcan - bojci Go to last post
4 64
Hi, I want to insert a large number or rows (say 100,000) into a table of 4 columns. Each column will have identical values except for one (which...
Steve W
08-19-2004 03:04 AM
Mingqing Cheng [MSFT] Go to last post
2 39
Hi all I need to send reports using xp_sendmail I wnat the mail to have a csv attachment so it can be double clicked and then be opend in...
Reg Besseling
08-19-2004 02:40 AM
Reg Besseling Go to last post
3 36
Hi: I can't figure out how to do a select for a particular table and was wondering if someone could help. Table structure: Client int Product...
Martin Hart - Memory Soft, S.L.
08-19-2004 02:15 AM
Martin Hart - Memory Soft, S.L. Go to last post
2 39
HI, I have two identical databases on the same server. How am i able to create one stored procedure that can be run on both. Is there somthing...
08-19-2004 01:59 AM
John Bell Go to last post
1 43
SQL 2K / WINDOWS 2003 SERVER I have a box with 2 SQL INSTANCES and each instances with few databases. Memory is setup to 'Use a fix memory size' and...
MS User
08-19-2004 01:49 AM
John Bell Go to last post
1 44
Help help me create script that I can backup the database on four segments. The reason I am dividing the backup in four segments so that I can copy...
08-18-2004 11:27 PM
Dan Guzman Go to last post
1 40
I have a dataset pulled from three tables I am presenting to a web page. Of course, when I push it to a datagrid, the first three columns are...
Steve W
08-18-2004 10:54 PM
Erik Grob \(MCP\) Go to last post
1 40
I have a database with millions of records in a table. I want to count them regularly but it seems that as the database builds doing a...
Jon Glazer
08-18-2004 10:34 PM
Jeff Fiegel Go to last post
4 46
I have been trying to figure out permissions and how they work on my Sql Server. I have gotten quite a bit of help and think I understand most of...
Thomas Scheiderich
08-18-2004 10:19 PM
Thomas Scheiderich Go to last post
3 46
Hi, I have 2 tables: Table1 and Table2. Table1 and Table2 have the same columns Date Name Value Table1 contain original data and has the primary...
08-18-2004 08:34 PM
John Go to last post
6 37
Hello everyone, I would like to know if it is possible in Access to save the username of sql server in a field. Greetings, Sam
08-18-2004 08:16 PM
Mark Go to last post
4 45
If the query joins 2 tables from a linked server, the performance seems very bad: EXEC sp_addlinkedserver 'SEATTLESales', N'SQL Server' GO select *...
08-18-2004 08:15 PM
Go to last post
2 39
Hello, Here is my problem, I'm trying to "upgrade" a table to not allow null values, but this has introduced an issue into some SQL that I use to...
08-18-2004 07:55 PM
Bernie Yaeger Go to last post
9 40
What is a good way to insert a specified number of rows into a table, where in each row one field contains a sequence number, and the rest of the...
08-18-2004 06:37 PM
howard@nospam.nospam Go to last post
3 58
I am asking this here, because I don't see a general sql NG. Onlt for SQL server. Anyway, This is for Access DB. This query works, I would just like...
08-18-2004 05:48 PM
Jeff Go to last post
4 43
Hi All MS SQL 2k - Dev ed. I got the basis of the following stored Proc from somewhere (can't remember, think it was aspfaq.com) and have incresed...
08-18-2004 05:34 PM
Chris Hohmann Go to last post
5 63
Is there a way to declare an fk contraint that would reference a composite primary key in another table? For example, I have table_1: create table...
08-18-2004 05:18 PM
David Portas Go to last post
3 44
Hi ! I have to acces multiple column (just like Periode1, periode2, etc.) of a table in a FOR LOOP. I would like use something like this : FOR i...
08-18-2004 04:56 PM
Dandy WEYN Go to last post
2 30
Hi All, I having trouble with this query declare @ExecStr varchar(2000) declare @country_no int set @country_no = null set @ExecStr = 'select *...
08-18-2004 04:47 PM
Hugo Kornelis Go to last post
3 45
Hi, How am i able to check if the temp table (##TempTable/#Temptable) already exists in TempDB using T-SQL since I am already in user...
08-18-2004 04:46 PM
Andrew J. Kelly Go to last post
1 37
Hi folks, I am building some fairly complex insert statements in order to perform a major data conversion from a legacy system. It has about 150...
Jami Bradley
08-18-2004 04:33 PM
Jami Bradley Go to last post
7 35
I have a stored proc that runs this command "Update SVC00300 set svc00300.ITEMNMBR=rtrimsvc00300.ITEMNMBR)+'-U' from SVC00300 where svc00300.itemnmbr...
08-18-2004 03:57 PM
Janet Go to last post
4 47
Say I want to store labor-tracking data in SQL. Each employee submits one timesheet per week, which will have some header information associated...
08-18-2004 03:54 PM
Anith Sen Go to last post
1 28
Is there any MSSQL tool like TNSPing for Oracle I just want to check whether i can ping to a running instance of sql server on network.? Thanks!!!
08-18-2004 03:29 PM
Tibor Karaszi Go to last post
1 51
Set ANSI_WARNINGS OFF but be cautious....
Might Help
08-18-2004 03:29 PM
Toby Herring Go to last post
6 67
Hi, We would like to distribute a ready SQL server to our customers, with our installation. We create the msi installation file with WiX and can...
08-18-2004 02:33 PM
Helene Day Go to last post
7 43
Hi, I am using following query - select * from t_act_fact_table where SUB_PRODUCT_ID like ( case @xyz when 'LCL' then (select from...
08-18-2004 02:28 PM
Adam Machanic Go to last post
1 37
When a script is run against a table with INSERT and UPDATE triggers, and QA returns x number of records updated then y number of recrods updated, is...
Robert Taylor
08-18-2004 02:24 PM
Robert Taylor Go to last post
2 33
I'm trying to do a simple comparison on 2 decimal fields. if @TempKPIValue > (@LastKPIValue + (@LastKPIValue * @TrendPadding)) Begin if...
Doug @ APCI
08-18-2004 02:16 PM
Louis Davidson Go to last post
2 35
The command you are referring may be SET PARSEONLY ON But that will affect all the statements. Also see SET FMTONLY ON -- Roji. P. Thomas
Roji. P. Thomas
08-18-2004 02:00 PM
Louis Davidson Go to last post
1 43
Is there a way to query a table and pull out a field data type and length? That is, length as defined, not length of the data in the field. ...
Andrew Jones
08-18-2004 01:52 PM
Andrew Jones Go to last post
2 46
Hi, I would like to know how to create a stored procedure but not let the user edit it in Enterprise Manger like system's procedures. With the...
08-18-2004 01:42 PM
Heriberto Go to last post
8 50
When user clicks SAVE button, it creates a new order with some products. I open connection, set isolation level on adXactIsolated(1048576) -...
08-18-2004 01:42 PM
Louis Davidson Go to last post
10 72
Post New Thread

Display Options
Showing threads 53001 to 53050 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.