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     
There's no guarantee that a query of the form select <stuff> from T where <conditions> will return the same number of rows as select <columns from...
Steve Kass
08-19-2004 04:03 PM
Steve Kass Go to last post
1 33
Hello, I want to show all the missing data by comparing 2 tables. For example, Table 1: 1 2 3 Table 2: 1
SQL Apprentice
08-19-2004 03:58 PM
Tinoco Go to last post
1 39
I know that Null does not equal anything. Does that mean that I cannot do a join where column A has values and column B may have Nulls...
Robert Taylor
08-19-2004 03:42 PM
Robert Taylor Go to last post
7 39
Is there any way to change all columns that are nvarchar to varchar? I have upsized about 12 Access DBs to SQL Server and all of the text fields...
Drew
08-19-2004 03:24 PM
Aaron [SQL Server MVP] Go to last post
1 49
I would like to run a backup daily using the backup command. However I want the file to be named after whatever day it is. Monday, tuesday,...
Jon Glazer
08-19-2004 03:22 PM
Jon Glazer Go to last post
3 38
I am using the DateAdd function like this: SELECT ShopCart.productID, ShopCart.imgsrc, ShopCart.href, '{6DB4A1C9-CEF0-4826-82D7-92B61911ADC4}'...
Sam Miller
08-19-2004 02:55 PM
Sam Go to last post
3 70
Hi all. I have a column of type NText, that usually holds big amounts of text. How do I update that column, given certain criteria? For...
John Francisco Williams
08-19-2004 02:40 PM
John Francisco Williams Go to last post
3 59
All, How this trigger should be fired if I insert for example 400-500 records? I suspect that the trigger will be fired only once when all records...
Just D.
08-19-2004 02:37 PM
Alejandro Mesa Go to last post
1 49
Hi, Can you store an office doc, like a word or excel document in a SQL field, and then somehow search within the contents of the office document...
aussie rules
08-19-2004 01:58 PM
Vishal Parkar Go to last post
3 30
THANKS very much simpler than the subfunctions that I was trying to do! I even modified it for the past 30 days. Now, anyone want to take a stab at...
Dennis
08-19-2004 01:33 PM
Itzik Ben-Gan Go to last post
6 38
anyone have or know of a nice sql script to do a luhn check for credit card numbers and bank routing numbers???
JT
08-19-2004 01:32 PM
Partha Mandayam Go to last post
1 42
Hello, Do you have any idea how a database set itself to read only mode? One of my database keeps getting set with read only mode. I look everywhere...
SQL Apprentice
08-19-2004 01:18 PM
Narayana Vyas Kondreddi Go to last post
2 40
I have a table with one column. For example Create table table1 (TestId int) INSERT INTO table1 SELECT 1 UNION SELECT 2 UNION SELECT 3
Tesh
08-19-2004 01:06 PM
Itzik Ben-Gan Go to last post
5 60
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 44
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...
CJM
08-19-2004 10:18 AM
Gregory A. Larsen Go to last post
2 42
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
Mohan
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 54
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 36
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...
simon
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...
mkarja
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...
Ian
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 -----------
angus
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
VADOR
08-19-2004 04:38 AM
Tamas Bojcan - bojci Go to last post
4 66
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...
Ed
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...
Mike
08-18-2004 11:27 PM
Dan Guzman Go to last post
1 42
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 43
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 49
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...
John
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
Samuel
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 *...
Locus
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...
Raterus
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...
howard@nospam.nospam
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...
Jeff
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...
Harag
08-18-2004 05:34 PM
Chris Hohmann Go to last post
5 68
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...
Anya
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...
Drakis
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 *...
priyanka@radiotime.com
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...
Ed
08-18-2004 04:46 PM
Andrew J. Kelly Go to last post
1 37
Post New Thread

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