|
Int is the fastest, I think date would be next fastest as its stored as an int, then string, but its more important to get the index(es) right than worry about which datatypes are fastest - its only in the case of very large tables that you will notice any significant difference.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have connected to the SQL Server 2000 using SQL Server Authentication. But i want to know;
How to connect to the SQL Server 2000 in Windows Authentication to the .Net Application
Regards,
LEE
|
|
|
|
|
|
Here are connection string for connecting with sql server 2000
SQL Server[^]
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
Connection string...[^]
To set up Windows Authentication Mode security with Enterprise Manager in SQL Server:
Expand a server group.
Right-click a server, and then click Properties.
On the Security tab, under Authentication, click Windows only, if you need mixed mode authentication then click SQL Server and Windwos
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
i want to pass
and(SafetyCases.Link Like '%DL.125%' or SafetyCases.Link Like '%DL.233%' or SafetyCases.Link Like '%DL.256%' or SafetyCases.Link Like '%DL.259%' or SafetyCases.Link Like '%DL.288%' or SafetyCases.Link Like '%DL.518%' or SafetyCases.Link Like '%DL.534%' or SafetyCases.Link Like '%DL.538%' or SafetyCases.Link Like '%DL.67%' or SafetyCases.Link Like '%DL.68%' or SafetyCases.Link Like '%DL.683%' or SafetyCases.Link Like '%DL.777%' or SafetyCases.Link Like '%DL.800%')
as parameter to my stored procedure
can i do and how ?
|
|
|
|
|
Yes, the same as any other nvarchar parameter.
create proc xyx (@parm nvarchar(4000))<br />
as<br />
....<br />
<br />
<br />
exec xyz @parm='.....'
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have a function that returns a table
This function accepts some parameters and performs a select from vwProducts, all it does is to insert into the return variable of the function the result of executing a query on vwProducts
vwProducts is sorted by ProductName
When i call this function, it returns products sorted by ManufacturerID, ProductName
Does anyone know why that is happening?
I specifyed a sort by ProductName inside the function as well
But wont sorting in the view and in the function have a performance penalty if i have many records?
When i was testing this on local machine, records where being sorted right, but when uploaded to another server, the sorting changed to ManufacturerID, ProductName
Any suggestions?
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
Try putting an order by into your select from the view. This is the only way to ensure records are returned int he required order, particularly when you use multiple worker processes.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
how to create sql 2000 database setup?
|
|
|
|
|
Hi,
I am not very clear what exactly you want to do.
However, if you wish to create a new database then click on database and select Create New Database.
Or if you wish to back up the database then right click the database and select "Backup Database" from the given options.
If you want to restore the database then follow then click "Restore" from the menu that appears.
Or if you want to do any of the above mentioned actions by SQL statements then please visit the following link http://www.informit.com/articles/article.aspx?p=19710[^]
Hope this helps  .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
Guys,
A quick question for those more knowledgable about Sql Server than I.
I am using SQL 2000 as the DB in my applications. By and large it consists of a bunch of tables, stored procs to read/write data and a little SQL processing of data. Some apps do move large chunks of data around and as there are lots of arrays to rebuild it can take a while.
I have been wondering about the pros and cons of upgrading to 2005 or even 2008. Would I get an appreciable gain in speed in reading/writing?
So, looking for thoughts on the pros and cons of upgrading.
Many thanks,
John.
|
|
|
|
|
I asked my colleague to put together a schema proposal for a new Database, and it's got a few single column tables in it for lookup purposes.
For some reason this is setting off alarm bells, but i can't put my finger on why, the lookups are unique, but really don't add anything to the DB except as a binding source. Are there any arguments for and against single column tables?
Cheers
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Difficult to say wihtout knowing more about the architecture and all that.
Generally speaking however, in my experience, there are few reasons for a single column table, outside having a central place to store a database wide variable used for calculations or lookup, which aren't changed. But even then I'd rarely put them in a single column table.
Other then that, most single column tables I've seen so far, stem from bad design or simply a misunderstanding of what the tables where suppose to achieve.
There are legit uses, but they are IMO rare, and if you hear warning bells (always a good thing, 'cause the database design is important), it might be good to try and take a look at the table design again, and judge whether or not they are truly needed.
|
|
|
|
|
Hello,
How can I export/import a complete database using c# and sql server 2000 ?
thanks,
berlus
|
|
|
|
|
Why are you using c# to do a database operation? If you are doing this regularly then use replication or SSIS or BCP, none of which require C#.
You may use C# to initiate the process but it will not do the job for you.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hai,
currently i m using sql server 2000.
i would like to study and get well expertise in STORED PROCEDURES and triggers.
cann anyone provide me the link for the above?
i m a BEGINEER......... help me.......
thanks in advance
|
|
|
|
|
|
|
please tell me
query in sql server 2005 getting 14 days back date from today date.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Use DATEADD and supply a negative number.
|
|
|
|
|
I have tended to always do this the lazy way:
select getdate()-14
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
Bloody hell I've been using TSQL for (way too many years) and never run across that one  . Had to actually test it before I believed it worked  . Thanks you. Have 5
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yeah - I just sit back with the beer and chips and let the computer do the work for me most of the time 
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
I was searching for Set ParseOnly On support from a managed application. This directive prohibits being used from within a stored procedure.
At the same time, while searching somewhere I referenced about a SQL Parser assembly and a sample codesnippet like vbSQLParser.
I was searching through my system assemblies and also on the Internet but could not make out which assembly or component does this source from? Can someone throw some hint or if it is a download URL from Microsoft or elsewhere, a download URL would be appreciated.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
