Why do the old the old avatars remain after being replaced by the new ones?
MS SQL database development
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What is interesting here?
• Duels
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Register!

QAIX > MS SQL database developmentGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

  Top users: 
  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Модератор:
Yesterday — Tuesday, 16 March 2010
key column information is insufficient or incorrect Dinu 12:16:13
 Dear Friends,
I have table contain 2000 out of those some are
duplicate when i select duplicate records by using Enterprise Manager
and make modification to one of those duplicate records the following
message flashes/display.

key columen information is insufficient or incorrect.Too many rows were
affected by update

pls suggest what is this and how to solve this problem

Thanks in advance

Dinesh Patwal

comment 4 answer | Add comment
The day before yesterday — Monday, 15 March 2010
Recovery model problem; db properities Matik 18:34:06
 Hello,


I've follow problem - thing to consider.

SQLServer 200 sp3a, ms win 2003 server
db simple recovery

There is a production database, wich is around 20gb big. Db is backed
up each day completely, but it takes up to 30 minutes.
Because there is a simple recovery model, there is no transaction log
backup (it fails anyway), and we do not have up-to-point recovery.

I'm considering to switch to full recovery model, but ....
The problem is, I do not want to affect performance (when the backup is
running, database is hardly avalible).

So my question will be: does the full recovery model, will be better
for db performance (for acces and blocking db; means, does it will take
shorter?)
Strategy will be (I hope ok) to back up during the week only
transaction log (incremental), and once at the weekend, full database
backup.

Generaly, which one is better for performance?
Which strategy will be the best, to keep performance at high level, but
also have the possibility to restore data (in case of emergency) from
the newest possible backup.

Thanks for help

Matik

comment 3 answer | Add comment
Sunday, 14 March 2010
e-cracker Guest 03:48:53
 Hi Friend can some1 tell me where iwil gat e-cracker where i can free download im waiting4 ur all answer thanks GOD Bless u All=^B­
Add comment
Tuesday, 9 March 2010
Restore database April CTP 2005 Failed? DMAC @ devdex . com 19:51:53
 The following failed in EM (or whatever it is called now management
studio I think) and I scripted it out and ran it in a query window to
get more info. This works fine in SQL 2000 but not in 2005. I also tried
to 'create' the database first then ran this command below but with the
'force restore over existing database' checked on but this failed also
which is odd as well. Any ideas. This is my very first play with 2005 so
it is not off to a great start although to be fair, i seem to have gor
lucky on the install as it all went OK. BTW, is there a more approriate
newsgroup for this query?

Thanks

RESTORE DATABASE [bob] FROM DISK = N'C:\BigFujiCopies\­Bob.bak' WITH
FILE = 1,
MOVE N'bob_Data' TO N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\b­ob_Data.MDF',
MOVE N'bob_Log' TO N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\b­ob_Log.LDF',
NOUNLOAD, STATS = 10
GO


Msg 5122, Level 16, State 1, Line 1
Directory lookup for the file "c:\Program Files\Microsoft SQL
Server\MSSQL\Data\b­ob_Data.MDF"
failed with the operating system error 3(error not found).
Msg 3156, Level 16, State 3, Line 1
File 'bob_Data' cannot be restored to 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\b­ob_Data.MDF'.
Use WITH MOVE to identify a valid location for the file.
Msg 5122, Level 16, State 1, Line 1
Directory lookup for the file "c:\Program Files\Microsoft SQL
Server\MSSQL\Data\b­ob_Log.LDF" failed with the operating system error
3(error not found).
Msg 3156, Level 16, State 3, Line 1
File 'bob_Log' cannot be restored to 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\b­ob_Log.LDF'. Use WITH MOVE to identify a valid
location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement.
Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.



*** Sent via Developersdex http://www.develope­rsdex.com ***
comment 3 answer | Add comment
Friday, 20 November 2009
unable to connect to ,ms sql server from visual c++ athi 19:37:15
 hi
I am trying to connect from my small c++ program to my ms sql server, but Not able to. I tried going to the configuration manager and enabled the namedpipes, but still not able to.

I am using the default instance in the server.

someone please enlighten me.

thnks
athi
comment 1 answer | Add comment
Friday, 4 September 2009
Move from SBS2003 MSDE to MS SQL 2005 Express Brian Smither 23:32:59
 I have SBS2003-SP1 (with MSDE) installed. I have read several "How-To's" on
upgrading MSDE to 2K5Express, but none have directly answered the
SBS2003/MSDE install scenario: is MSDE a "module" of Sharepoint/SBS-
Monitoring, or is it an MSI install, brought in with the OS install?

The How-To's state that if you can see it in Add/Remove programs, then it
is an MSI install and 2K5Express will see it and upgrade it and the
databases as appropriate. If it's not in Add/Remove, then it was installed
as a module. In SBS2003, it is listed in Add/Remove as "Microsoft SQL
Server Desktop Engine (SBSMonitoring)" and "... (Sharepoint)".

After the install of 2K5Express, because they are *still* in the Add/Remove
panel, did 2K5Express update everything necessary, or am I still needing to
execute the detach/re-attach steps and then figure out where the MSDE
engine is and how to delete it? Run an OS component reconfiguration setup?

[gripe]
I wish experts in a subject matter would delve a bit deeper and offer
advice on a wider range of situations in their How-To's than what appears
to be simply parroting MS's own white papers and KB articles.
[/gripe]

When I run the Management Studio Express, I am able to connect to three
choices: server/SBSMONITORIN­G, server/SHAREPOINT, and server/SQLEXPRESS.
The first two show one version number (8.0.2039), while the last shows a
different version number (9.0.2047). Is there anything I need to concern
myself with this?


--
Remove INVALID from e-mail address.

Brian Smither
Smither Consulting
comment 1 answer | Add comment
Wednesday, 12 August 2009
SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!? Jack 06:19:51
 Hello,

I had SQL2000 server running fine on the windows 2003 box. I then installed
SQL 2005 Express. They both worked together fine. I then uninstalled SQL
2005 Express and installed SQL 2005 Server. But when I open SQL Server
Management Studio, I can only connect to the SQL 2000 engine. In the Object
explorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I can
see the existing SQL 2000 databases).

How can I get SQL Server Management Studio to 'see' the SQL 2005 database
engine so I can create tables? I *think* its running because there is the
'sqlservr.exe' process running, and during installation there is no issues.

When I open SQL Server Management Studio, I choose 'Database Engine', then
my local Servername with Windows Authentication. How do I connect to the SQL
2005 instance?

Thanks,
Jack.



comment 6 answers | Add comment
Monday, 13 July 2009
dependent assembly microsoft.vc80.mfcl­oc could not be found B Tarrance 18:17:49
 Hi. Looking for any help I can find!
I have a brand new virtual server running Windows Server 2003,
Enterprise Edition with Plesk Control Panel 7.5 . I just installed the
first program on the server of SQL Server 2005 Enterprise Edition. In
the system event viewer log I have the following errors:
___________________­____________________­____________________­________________
Event Type:Error
Event Source:SideBySide
Event Category:None
Event ID:32
Date:8/12/2006
Time:12:24:35 PM
User:N/A
Computer:SDSERVER
Description:
Dependent Assembly Microsoft.VC80.MFCL­OC could not be found and Last
Error was The referenced assembly is not installed on your system.
___________________­____________________­____________________­________________
_Event Type:Error
Event Source:SideBySide
Event Category:None
Event ID:59
Date:8/12/2006
Time:12:24:35 PM
User:N/A
Computer:SDSERVER
Description:
Resolve Partial Assembly failed for Microsoft.VC80.MFCL­OC. Reference
error message: The referenced assembly is not installed on your system.
___________________­____________________­____________________­________________
Event Type:Error
Event Source:SideBySide
Event Category:None
Event ID:59
Date:8/12/2006
Time:12:24:35 PM
User:N/A
Computer:SDSERVER
Description:
Generate Activation Context failed for
C:\WINDOWS\WinSxS\x­86_Microsoft.VC80.MF­C_1fc8b3b9a1e18e3b_8­.0.50727.42_x-ww_DEC­6DDD2\MFC80U.DLL.
Reference error message: The referenced assembly is not installed on
your system.
___________________­____________________­____________________­________________

Can anyone please provide any guidance of any kind what so ever
regarding this??? (Can you tell I'm desperate?? :-)­

I have google'd this and have found similar errors, but nothing that I
could take from. I really appreciate any help.

TIA

comment 5 answers | Add comment
Monday, 20 April 2009
Selecting on multiple tables Henrik Goldman 21:20:50
 Hi there,

I'm new to sql and thus I'm having problems with a specific query which I
hope you guys can help me with.

Basicly I have a few tables which I'm trying to do a query on:

Table groups contains information about specific groups e.g. "Windows" or
"Unix".
Table users contains information about specific users e.g. "a", "b" or "c".
Table users_groups contain information about group relationship (a user can
be in multiple groups) e.g. (a, Windows), (b, Unix), (a, Unix).
In this case user c is ungrouped.

Now I'd like to find the users which does belong to group Windows and those
who do not:

select distinct username from users_groups where groupname = "Windows" order
by username asc;

This works pretty well for finding users in the specific group. In this case
the result is a.



However I'd like to get the opposite result (b and c) but I'm stuck.

The problem is that I'd like a list of all users excluding those which are
in "Windows"

Here is a partial query:

select distinct users.username from users left join users_groups on
users.username = users_groups.userna­me where users_groups.userna­me is null
order by users.username asc;

This only gives me those users who are not grouped at all. This mean that
user b is not in those results.



Please advise.

Thanks in advance.



-- Henrik






comment 2 answer | Add comment
Sunday, 29 March 2009
Import multiple csv into multiple tables Chicagoboy27 20:55:40
 Is there a way to import multiple csv files from a directory into sql
2005? The situation I have right now is that I have a folder with
multiple csv files that i need to import into sql 2005. I can do it
with the import wizard but it takes to long. The files will be updated
monthly. The first row in the files contains all the header information
which may change monthy. What I am looking to do is import all of these
csv into tables. One csv file into for one table. Ideally I would like
to use the name of the csv file as the name of the table. Any bump in
the right direction would be apprecieted

comment 2 answer | Add comment
Monday, 1 December 2008
SQL Server 2005: CLR functions vs SQL functions Guest 03:09:14
 I was playing around with the new SQL 2005 CLR functionality and
remembered this discussion that I had with Erland Sommarskog concerning
performance of scalar UDFs some time ago (See "Calling sp_oa* in
function" in this newsgroup). In that discussion, Erland made the
following comment about UDFs in SQL 2005:
The good news is that in SQL 2005, Microsoft has addressed several of
these issues, and the cost of a UDF is not as severe there. In fact for
a complex expression, a UDF in written a CLR language may be faster
than
the corresponding expression using built-in T-SQL functions.<<

I thought the I would put this to the test using some of the same SQL
as before, but adding a simple scalar CLR UDF into the mix. The test
involved querying a simple table with about 300,000 rows. The
scenarios are as follows:

(A) Use a simple CASE function to calculate a column
(B) Use a simple CASE function to calculate a column and as a criterion
in the WHERE clause
(C) Use a scalar UDF to calculate a column
(D) Use a scalar UDF to calculate a column and as a criterion in the
WHERE clause
(E) Use a scalar CLR UDF to calculate a column
(F) Use a scalar CLR UDF to calculate a column and as a criterion in
the WHERE clause

A sample of the results is as follows (time in milliseconds):

(295310 row(s) affected)
A: 1563

(150003 row(s) affected)
B: 906

(295310 row(s) affected)
C: 2703

(150003 row(s) affected)
D: 2533

(295310 row(s) affected)
E: 2060

(150003 row(s) affected)
F: 2190

The scalar CLR UDF function was significantly faster than the classic
scalar UDF, even for this very simple function. Perhaps a more complex
function would have shown even a greater difference. Based on this, I
must conclude that Erland was right. Of course, it's still faster to
stick with basic built-in functions like CASE.

In another test, I decided to run some queries to compare built-in
aggregates vs. a couple of simple CLR aggregates as follows:

(G) Calculate averages by group using the built-in AVG aggregate
(H) Calculate averages by group using a CLR aggregate that similates
the built-in AVG aggregate
(I) Calculate a "trimmed" average by group (average excluding highest
and lowest values) using built-in aggregates
(J) Calculate a "trimmed" average by group using a CLR aggregate
specially designed for this purpose

A sample of the results is as follows (time in milliseconds):

(59 row(s) affected)
G: 313

(59 row(s) affected)
H: 890

(59 row(s) affected)
I: 216

(59 row(s) affected)
J: 846

It seems that the CLR aggregates came with a significant performance
penalty over the built-in aggregates. Perhaps they would pay off if I
were attempting a very complex type of aggregation. However, at this
point I'm going to shy away from using these unless I can't find a way
to do the calculation with standard SQL.

In a way, I'm happy that basic SQL still seems to be the fastest way to
get things done. With the addition of the new CLR functionality, I
suspect that MS may be giving us developers enough rope to comfortably
hang ourselves if we're not careful.

Bill E.
Hollywood, FL
-------------------­--------------------­--------------------­------------


-- table TestAssignment, about 300,000 rows
CREATE TABLE [dbo].[TestAssignment](
[TestAssignmentID] [int] NOT NULL,
[ProductID] [int] NULL,
[PercentPassed] [int] NULL,
CONSTRAINT [PK_TestAssignment] PRIMARY KEY CLUSTERED
(
[TestAssignmentID] ASC
)


--Scalar UDF in SQL
CREATE FUNCTION [dbo].[fnIsEven]
(
@intValue int
)
RETURNS bit
AS
BEGIN
Declare @bitReturnValue bit

If @intValue % 2 = 0
Set @bitReturnValue=1
Else
Set @bitReturnValue=0
RETURN @bitReturnValue
END

--Scalar CLR UDF
/*
using System;
using System.Data;
using System.Data.SqlClie­nt;
using System.Data.SqlType­s;
using Microsoft.SqlServer­.Server;

public partial class UserDefinedFunction­s
{

[Microsoft.SqlServer.Server.SqlFunction(IsDeterministic=true,IsPrecise=true)]
public static SqlBoolean IsEven(SqlInt32 value)
{
if(value % 2 == 0)
{
return true;
}
else
{
return false;
}
}
};
*/

--Test #1
--Scenario A - Query with calculated column--
SELECT TestAssignmentID,
CASE WHEN TestAssignmentID % 2=0 THEN 1 ELSE 0 END AS
CalcColumn
FROM TestAssignment

--Scenario B - Query with calculated column as criterion--
SELECT TestAssignmentID,
CASE WHEN TestAssignmentID % 2=0 THEN 1 ELSE 0 END AS
CalcColumn
FROM TestAssignment
WHERE CASE WHEN TestAssignmentID % 2=0 THEN 1 ELSE 0 END=1

--Scenario C - Query using scalar UDF--
SELECT TestAssignmentID,
dbo.fnIsEven(TestAs­signmentID) AS CalcColumn
FROM TestAssignment

--Scenario D - Query using scalar UDF as crierion--
SELECT TestAssignmentID,
dbo.fnIsEven(TestAs­signmentID) AS CalcColumn
FROM TestAssignment
WHERE dbo.fnIsEven(TestAs­signmentID)=1

--Scenario E - Query using CLR scalar UDF--
SELECT TestAssignmentID,
dbo.fnIsEven_CLR(Te­stAssignmentID) AS CalcColumn
FROM TestAssignment

--Scenario F - Query using CLR scalar UDF as crierion--
SELECT TestAssignmentID,
dbo.fnIsEven_CLR(Te­stAssignmentID) AS CalcColumn
FROM TestAssignment
WHERE dbo.fnIsEven(TestAs­signmentID)=1


--CLR Aggregate functions
/*
using System;
using System.Data;
using System.Data.SqlClie­nt;
using System.Data.SqlType­s;
using Microsoft.SqlServer­.Server;


[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedAggregate(Format.Native)]
public struct Avg
{
public void Init()
{
this.numValues = 0;
this.totalValue = 0;
}

public void Accumulate(SqlDoubl­e Value)
{
if (!Value.IsNull)
{
this.numValues++;
this.totalValue += Value;
}

}

public void Merge(Avg Group)
{
if (Group.numValues > 0)
{
this.numValues += Group.numValues;
this.totalValue += Group.totalValue;
}

}

public SqlDouble Terminate()
{
if (numValues == 0)
{
return SqlDouble.Null;
}
else
{
return (this.totalValue / this.numValues);
}
}

// private accumulators
private int numValues;
private SqlDouble totalValue;

}

[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedAggregate(Format.Native)]
public struct TrimmedAvg
{
public void Init()
{
this.numValues = 0;
this.totalValue = 0;
this.minValue = SqlDouble.MaxValue;­
this.maxValue = SqlDouble.MinValue;­
}

public void Accumulate(SqlDoubl­e Value)
{
if (!Value.IsNull)
{
this.numValues++;
this.totalValue += Value;
if (Value < this.minValue)
this.minValue = Value;
if (Value > this.maxValue)
this.maxValue = Value;
}


}

public void Merge(TrimmedAvg Group)
{
if (Group.numValues > 0)
{
this.numValues += Group.numValues;
this.totalValue += Group.totalValue;
if (Group.minValue < this.minValue)
this.minValue = Group.minValue;
if (Group.maxValue > this.maxValue)
this.maxValue = Group.maxValue;
}

}

public SqlDouble Terminate()
{
if (this.numValues < 3)
return SqlDouble.Null;
else
{
this.numValues -= 2;
this.totalValue -= this.minValue;
this.totalValue -= this.maxValue;
return (this.totalValue / this.numValues);
}
}

// private accumulators
private int numValues;
private SqlDouble totalValue;
private SqlDouble minValue;
private SqlDouble maxValue;

}
*/

--Test #2

--Scenario G - Average Query using built-in aggregate--
SELECT ProductID, Avg(Cast(PercentPas­sed AS float))
FROM TestAssignment
GROUP BY ProductID
ORDER BY ProductID

--Scenario H - Average Query using CLR aggregate--
SELECT ProductID, dbo.Avg_CLR(Cast(Pe­rcentPassed AS float)) AS Average
FROM TestAssignment
GROUP BY ProductID
ORDER BY ProductID

--Scenario I - Trimmed Average Query using built in aggregates/set
operations--
SELECT A.ProductID,
Case
When B.CountValues<3 Then Null
Else Cast(A.Total-B.MaxV­alue-B.MinValue AS
float)/Cast(B.Count­Values-2 As float)
End AS Average
FROM
(SELECT ProductID, Sum(PercentPassed) AS Total
FROM TestAssignment
GROUP BY ProductID) A

LEFT JOIN

(SELECT ProductID,
Max(PercentPassed) AS MaxValue,
Min(PercentPassed) AS MinValue,
Count(*) AS CountValues
FROM TestAssignment
WHERE PercentPassed Is Not Null
GROUP BY ProductID) B

ON A.ProductID=B.Produ­ctID
ORDER BY A.ProductID

--Scenario J - Trimmed Average Query using CLR aggregate--
SELECT ProductID, dbo.TrimmedAvg_CLR(­Cast(PercentPassed AS real)) AS
Average
FROM TestAssignment
GROUP BY ProductID
ORDER BY ProductID

comment 10 answers | Add comment
Wednesday, 6 August 2008
Reads and writes to a sql server database per table Guest 06:47:14
 Is it possible to find the reads/writes to a sql server table ?

comment 3 answer | Add comment
Monday, 28 July 2008
Insert Function Help Riley Derrick 14:08:02
 Hello All

I have been looking over the various forums and threads trying to learn
as much as I can. Here is my issue. I am trying to do the following:

Write a function that involves the following: Calculates the
following. 2 user inputted dates. (Ex. Jan 1 2000 -- Jan 1 2004).
Figures out the number of months between the 2 dates. That number is
then multiplied by a user input price that outputs some number. Problem
is I am new to SQL and having some trouble getting started. Any hepl
would be appreciated.

comment 3 answer | Add comment
Friday, 4 July 2008
format files for use with bulk insert Ted 14:01:39
 I used bcp to produce the apended format file.

How can it be modified to recognize the quotes that surround the text
fields and not insert the quotes along with the text? Invariably, the
first four columns have text surrounded by quotes and are terminated by
tabs. If the first column has "abc", only abc ought to be inserted
into that field in the table.

Thanks

Ted

==================f­ormat file===============­=========
<?xml version="1.0" ?>
- <BCPFORMAT
xmlns="http://schem­as.microsoft.com/sql­server/2004/bulkload­/format"
xmlns:xsi="http://w­ww.w3.org/2001/XMLSc­hema-instance">
- <RECORD>
<FIELD ID="1" xsi:type="CharPrefi­x" PREFIX_LENGTH="2" MAX_LENGTH="6"
COLLATION="Latin1_G­eneral_CI_AI" />
<FIELD ID="2" xsi:type="CharPrefi­x" PREFIX_LENGTH="2" MAX_LENGTH="7"
COLLATION="Latin1_G­eneral_CI_AI" />
<FIELD ID="3" xsi:type="CharPrefi­x" PREFIX_LENGTH="2" MAX_LENGTH="48"
COLLATION="Latin1_G­eneral_CI_AI" />
<FIELD ID="4" xsi:type="NativeFix­ed" LENGTH="4" />
<FIELD ID="5" xsi:type="CharPrefi­x" PREFIX_LENGTH="2" MAX_LENGTH="8"
COLLATION="Latin1_G­eneral_CI_AI" />
<FIELD ID="6" xsi:type="NativePre­fix" PREFIX_LENGTH="1" />
</RECORD>
- <ROW>
<COLUMN SOURCE="1" NAME="f_supplier_co­de" xsi:type="SQLVARYCH­AR" />
<COLUMN SOURCE="2" NAME="f_product_cod­e" xsi:type="SQLVARYCH­AR" />
<COLUMN SOURCE="3" NAME="f_product_nam­e" xsi:type="SQLVARYCH­AR" />
<COLUMN SOURCE="4" NAME="f_asset_class­es_id" xsi:type="SQLINT" />
<COLUMN SOURCE="5" NAME="f_size" xsi:type="SQLVARYCH­AR" />
<COLUMN SOURCE="6" NAME="f_dist_unit" xsi:type="SQLFLT8" />
</ROW>
</BCPFORMAT>

comment 7 answers | Add comment
Thursday, 26 June 2008
Allow NULL or Define DEFAULT Value Binder 14:00:50
 I am designing a new table with a few columns that may or may not have
a value on each row that is inserted.

What issues determine whether to allow a NULL value to be inserted for
that column or define a default value to be used?

I want to think through the repercussions of this decision before I get
into production.

comment 4 answer | Add comment
Friday, 20 June 2008
Move Log File Locations Tim Pascoe 15:42:06
 I am trying to split the log and data files between two drives on a new
SQL-Server 2000 installation. I followed the instructions from the MS
article 224071 (Moving SQL Server databases to a new location with
Detach/Attach).

Unfortunalty, when I try to move the Master database, as per
instructions, access to SQL-Sever is lost;the service will never start
again. I've tried this twice after re-installing with the same results.

Anyone have any ideas as to what is going wrong?

Tim

comment 4 answer | Add comment
Tuesday, 26 February 2008
Divide by Zero Joriveek 21:20:40
 When I specify a formula between Computed Column Specification, I have two
zero values, getting Divide by Zero error, any idea how can I avoid this? I
still want SQL Server to display Zero if it is 0/0, is this possible in SQL
Server database?

Thanks
J.


comment 20 answers | Add comment
Sunday, 25 November 2007
Syntax Question Guest 16:51:45
 SQL Server 2000

When joining tables, some use:
AliasTableName.Colu­mnName = AliasTableName.Colu­mn
while others use
LEFT/RIGHT etc JOIN .......

Is one better than the other in cases where the join is a simple JOIN
of equality ?

Curious ...

Thanks,

Craig

comment 3 answer | Add comment
Tuesday, 28 August 2007
Re: Re: Re: connectionopen (SeCDoClientHandsha­ke().]SSL Security Pigeon 09:51:10
 "Erland Sommarskog" wrote:>pigeon (DoNotEmail@dbForum­z.com) writes:>> Ok.. it looks like we can only initiate a secure transaction>> serverside.. when we try to initiate a secure connection clientside>> (of course serverside encrypttion has to be off).. then we get the>SSL>> security error.>
I have never worked with encryption, so I don’t know. I did>actually>play with it recently for a test script, and I think I arrived at a>similar conclusion. But I did not even have a certificate. (What I>wanted>to test was whether a module that I have handles the Encyption option>correctly, but I had to leave that out.)>
I’ve relayed your posts to our internal MVP forum, to see if>anywhere there>knows about this.>

Great thanks!

I figured it out.. and I think it is just a bug

the solution to my problem was to
create a key in the registry named "certificate" and put my
certificate’s thumbprint in the key.

This is somewhat normal..

but the other wierd thing is...

In order to have encrypted or unencrypted traffic, I have to tell SQL
to ’force encryption’ via creating a certificate named "encrypt" and
putting this value to 1

w2k
ms sql 2000 sp4

--
Posted using the http://www.dbforumz­.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz­.com/General-Discuss­ions-connectionopen-­SeCDoClientHandshake­-SSL-Security-error-­ftopict235551.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz­.com/eform.php?p=819­787
comment 2 answer | Add comment
Wednesday, 6 June 2007
Free Online SQL Formatter Billy bb 14:05:34
 We have just release a free Online SQL Formatter
which can beautify different sql dialects for you on the fly with many
format options.
and translate it to other languages such as C#, Java,Delphi

Try it here:
http://www.wangz.ne­t/gsqlparser/sqlpp/s­qlformat.htm

*** Sent via Developersdex http://www.develope­rsdex.com ***
comment 3 answer | Add comment
Tuesday, 5 June 2007
Login failed for user 'null' Dobrzak 19:23:03
 Hello,
I have problem with linked servers (MS SQL Server 2k)- when I try to execute
query(update, insert..) with linked servers, I have message Login failed for
user 'null'. This is very strange problem, some computers in AD (2k3 std)
don't have this error, when the other have this problem for few hours and
some have this error all the time. Network Protocols is TCP/IP.

Any idea ?


comment 4 answer | Add comment
Monday, 20 November 2006
float numbers Guest 20:04:44
 Hi!

How do I do to make t-sql not rounding the result that i returned?

For example:
0.9616458*60 = 57,698748 (in any calculator)

while following:
-------------------­-------------
declare @a float
declare @b int

set @a=0.9616458
set @b=60

print @a*@b
-------------------­--------------
will show :57.6987

How do I do to make MSSQL to show me the value whothout rounding it?

Thanks!

comment 25 answers | Add comment

Add new topic:

How:  Register )
 
Login:   Password:   
Comments by: Premoderation:
Topic:
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.


QAIX > MS SQL database developmentGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

see also:
Stepping (CPU)?
dell PSU fan noisy
Kloss & Trigem.. What's Up With Them?
pass tests:
see also:
{Wind in a head..}
{Happy New Year}
{At me today birthday}

  Copyright © 2001—2010 QAIX
Идея: Монашёв Михаил.
Авторами текстов, изображений и видео, размещённых на этой странице, являются пользователи сайта.
See Help and FAQ in the community support.qaix.com.
Write in the community about the bugs you have noticedbugs.qaix.com.
Write your offers and comments in the communities suggest.qaix.com.
Information for parents.
Пишите нам на .
If you would like to report an abuse of our service, such as a spam message, please .
Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .