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     
I have managed (Not sure how) to do something to corrupt my database, but I can't seem to identify the corruption using DBCC. The problem I have is...
David Brunning
09-01-2004 02:59 AM
Tibor Karaszi Go to last post
3 58
Hello Can I connect on sql server using sql ports in connection string? Thanks
Alen Gurovic
09-01-2004 02:59 AM
Tibor Karaszi Go to last post
1 63
select top 2 * from (select top 5 * from users where userid>10 order by userid DESC) as pele why i must use here AS statament.. it refers inside...
Savas Ates
09-01-2004 02:27 AM
John Bell Go to last post
1 52
I am having an issue with bcp when I specify a field terminator while using the -w (nchar data type) switch. I am exporting data as a csv file so...
Clint Colefax
09-01-2004 02:19 AM
John Bell Go to last post
1 31
When attempting to run the following query to generate and then execute dynamic SQL I am getting the error message "Syntax error converting datetime...
rzirpolo
09-01-2004 02:02 AM
Tibor Karaszi Go to last post
10 61
Hello All, Would anyone know how to convert the hexadecimal value of the first & root column of the sysindexes table. I need the decimal equivalent...
rgn
09-01-2004 01:53 AM
Kalen Delaney Go to last post
2 82
Dear expert, I create a view as below: Code: Select Studn as NAME, Studs as SEX, Studca as , Studea as FROM Student_Record : :
Devil Garfield
08-31-2004 11:00 PM
Dan Guzman Go to last post
3 48
Hi, Is there anyway to override the 8k rowsize limit in SQL Server 7.0 service pack 4.0. I have a Query with several nvarchar fields. The same query...
SS
08-31-2004 08:36 PM
Kalen Delaney Go to last post
4 37
All, How can I get the string with Initials? I'm having for example 2 columns with varchar and I need to create a value for a new column with the...
Just D.
08-31-2004 07:42 PM
Abhinav Kumar Go to last post
3 48
Hi I wrote one stored procedure which accepts ServerName as parameter, then I used sp_addLinkedServer to connect that server and I wrote a query...
Anitha T
08-31-2004 06:51 PM
Anitha T Go to last post
1 38
I am trying to replace a text string using like but can't seem to get it to work. SQL won't accept the first instance of like. What I have so...
moido10025
08-31-2004 05:41 PM
Go to last post
4 34
Please help...this is what I have so far... Creating a temp table to hold all the ids from table1 that match my criteria. Then would like to delete...
ANN
08-31-2004 05:34 PM
oj Go to last post
1 42
Hi, I have a table with 2 text fields (A, B), I need to write a query, one of the condition is to list records which have different value of A and...
Hardy Wang
08-31-2004 05:13 PM
oj Go to last post
1 35
We've been using Application Roles for more than 6 months. Up to few days ago it worked very well. Suddenly it got very slow. We tried to connect to...
UnkleVo
08-31-2004 05:02 PM
Unkle Vo Go to last post
2 34
Hi, I was testing the Beta Release of SQL Server 2005, error when detach database from sql server 2000 -> i attached database to SQL Server 2005 ->...
Bhagvan
08-31-2004 04:46 PM
Erland Sommarskog Go to last post
1 43
You might be affected by the 'parameter sniffing'. http://tinyurl.com/4w4gc If you post simplified codes here, someone might be able to give...
oj
08-31-2004 04:41 PM
oj Go to last post
1 29
I can only comment, if you can show us how the 'key generating' table is accessed. You can also get specific information on the deadlock, by turning...
Narayana Vyas Kondreddi
08-31-2004 03:55 PM
David Browne Go to last post
2 39
Hi, I just tried to restore a "last night backup" to a point in time. The backup has been made at 2am. The transaction log backup has been made at...
Jochen Daum
08-31-2004 03:40 PM
Jochen Daum Go to last post
2 38
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an...
mjuricek
08-31-2004 03:15 PM
Hugo Kornelis Go to last post
9 39
varchar (Multi-page thread 1 2 )
"payyans" <payyans (AT) discussions (DOT) microsoft.com> wrote If you mean variables in memory, yes, I believe it does allocate the full 8000 bytes...
payyans
08-31-2004 03:00 PM
Hugo Kornelis Go to last post
12 92
I have various UPDATEs and INSERTs that I would like to "test run" before I execute them "for real" in order to at least see that them are touching...
Larry Woods
08-31-2004 02:26 PM
Harag Go to last post
10 69
I'm in a quandary. I have an application where one row of a table needs to be related to zero-to-many two-character state codes. One idea that has...
Toby Herring
08-31-2004 02:23 PM
David Browne Go to last post
3 35
Query cost and execution time are not the same! -- http://www.aspfaq.com/ (Reverse address to reply.) "Victor Feng" <VictorFeng (AT) discussions...
Aaron [SQL Server MVP]
08-31-2004 01:54 PM
Gert-Jan Strik Go to last post
3 36
Hi, in one of the tables I have a column of image data type where data is stored in binary format (encrypted). Is there a way of converting it to...
Mirna
08-31-2004 12:57 PM
Adam Machanic Go to last post
3 35
Hello, As im exploring SQL Server, ive run into something that seems quite odd, so i just wanted to ask the experts, and find out if this is...
A Traveler
08-31-2004 12:56 PM
Adam Machanic Go to last post
14 57
Using an SQL statement, I need to know whether a field in a table is: a) been autoincremented b) the increment amount (1,2,etc) c) the seed (what...
Les Hughes
08-31-2004 12:39 PM
Aaron [SQL Server MVP] Go to last post
5 49
I would like to conactenate data from 2 numeric columns into a 3rd field with the following fixed format: XXX-XXXX Here's my syntax: update...
Bill Nguyen
08-31-2004 12:22 PM
Bill Nguyen Go to last post
3 32
On SQL Server 2000, can you pass a table variable as a param to a stored procedure as either input or output?
Robert E. Flaherty
08-31-2004 12:05 PM
Graeme Malcolm Go to last post
3 39
Where does Microsoft say this? There is no hard and fast rule about what kind of query plan goes with what kind of query, and if Microsoft says...
Victor Feng
08-31-2004 11:53 AM
Steve Kass Go to last post
2 41
I am not certain how to accomplish this task and would appreciate any suggestions with specifics. I currently have SQL script that inserts about...
Kevin L
08-31-2004 11:42 AM
Aaron [SQL Server MVP] Go to last post
8 36
Is there some "global" variable that contains the affected rows from a SQL execution? In other words, where is Query Analyzer getting the info for...
Larry Woods
08-31-2004 11:29 AM
Kalen Delaney Go to last post
2 42
We have Sql2k on windows2003 (With sql2k servicepack3) I have a network drive Z: mapping to \\192.168.2.100 \xyfolder on this server When I try...
Sai
08-31-2004 10:43 AM
Sai Go to last post
6 74
Say I have a group of tables that are all related to each other in a nested tree like manner, where each table has a 'parent id' column that points...
Dot net work
08-31-2004 10:22 AM
Dot Net Work Go to last post
3 25
Hi - I'm have a VB.NET Windows application that uses an MSDE database. I'm trying to code backup, restore, and checkdb/repair functions. Before...
Jeff
08-31-2004 10:09 AM
Jeff Go to last post
5 49
I have a scheduled job that has shown its status as "Performing Completion Actions" for several days now and from as far as I can tell, isn't holding...
Robert Taylor
08-31-2004 09:22 AM
Robert Taylor Go to last post
6 43
Can a computed column use case logic ? Given two column X and Y can I create a computed column Z which basically says if column Y is Null populate...
rob
08-31-2004 08:37 AM
Jacco Schalkwijk Go to last post
3 39
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. my connection string Set...
Savas Ates
08-31-2004 07:45 AM
Ilya Margolin Go to last post
1 44
I am generating a varchar variable and for some reason it fails on the following line of the where clause, and (se.departureDateTime <...
rzirpolo
08-31-2004 07:04 AM
Uri Dimant Go to last post
12 64
Hi, I have a table Notify ------------ NotifyID int Primary Key UserEmail Varchar(64), EstateId int I would like to ask if someone knows how could...
Viktor Popov
08-31-2004 07:00 AM
Wayne Snyder Go to last post
2 29
how can i get the following sample query to insert if 'licence' is not found, but only updatye if it is found update table1 set name = ' TEST' Where...
Peter Newman
08-31-2004 06:42 AM
Daniel Doyle Go to last post
2 38
Hi, I'm new to MSSQL world and I have a little question: I have just added a new field to a table containing some 3000 rows... The new field has...
Peter Osawa
08-31-2004 04:42 AM
Peter Osawa Go to last post
2 34
Hi, I have a table Notify ------------ NotifyID int Primary Key UserEmail Varchar(64), EstateId int I would like to ask if someone knows how could...
Viktor Popov
08-31-2004 04:37 AM
Harag Go to last post
1 38
Hi experts I posted the 'dates in sql' question a while ago but it dosn't seem to have been replied to. I'm still having problems calculating...
jez123456
08-31-2004 04:31 AM
Hugo Kornelis Go to last post
1 39
I need SQL to insert the date when a record is created, but it keeps reverting to full date & time (31/08/2004 09:54:23) - I only want the date, not...
Phil
08-31-2004 04:17 AM
Itzik Ben-Gan Go to last post
1 39
I have two stored proecedures that i wish to have NEVER run at the same time to avoid loosing all my data: sp_archive and sp_restore if they...
Daniel
08-31-2004 04:17 AM
Andres Taylor Go to last post
2 52
Well at least for me ;o) I have this sql here that runs fine SELECT tblCompany.Company, tblCompany.Address, tblCompany.City,
katie
08-31-2004 03:56 AM
Roji. P. Thomas Go to last post
3 69
Hi, I use a cursor in my SP. I have no problem with the FETCH NEXT instruction but I don't know why, the FETCH FIRST and FETCH PRIOR always return...
Herve MAILLARD
08-31-2004 03:28 AM
Tibor Karaszi Go to last post
2 29
Hi, I have two clients that run my VB app and both connect to one sql server. I want to display new records in the client as soon as they're inserted...
Amin Sobati
08-31-2004 03:25 AM
John Bell Go to last post
3 39
I've been working on a stored procedure doing lots of little changes trying to get that little bit more speed. I've been making the change and then...
Derek
08-31-2004 02:29 AM
Uri Dimant Go to last post
1 37
I have a set of data that has two fields, LowNumber and HighNumber. In most cases, LowNumber and HighNumber can readily be converted to int...
Robert May
08-31-2004 01:31 AM
David Portas Go to last post
3 34
Post New Thread

Display Options
Showing threads 52501 to 52550 of 69251
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.