Viewing 15 posts - 1,336 through 1,350 (of 1,479 total)
Thanks, I also thought that this is a very good resource and it helped me in the past when I worked with linked servers. Although I didn’t write it,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2008 at 10:21 pm
Paul (12/9/2008)
Weird
Also, when you say refer to the users language, I take it you mean the SQL Server user? I've looked...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2008 at 7:11 am
There is a good explanation about it in this URL - http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2008 at 7:01 am
The date’s format in SQL Server is determined according to the user’s default language, so if 2 different users execute this line:
INSERT INTO table1(id, datefield) VALUES(1, '2008-12-09 11:00:00')
They could have...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2008 at 6:38 am
select table_name
from information_schema.views
where view_definition like '%FunctionName%'
Instead of FunctionName write the real function's name
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2008 at 1:07 am
laubenth (12/8/2008)
ishaan99 (12/8/2008)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 8, 2008 at 10:35 pm
As I wrote you before, default language setting will only change the default date format that you'll see and the error message's language. If you want you can try...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 8, 2008 at 9:58 pm
You can use both ascii and unicode on the same database and even on the same table. When you create the table the data type that you use for...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 8, 2008 at 3:04 am
It should change the date format and error messages' language.
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 8, 2008 at 12:47 am
As others already recommended - don't reuse the delete primary key. It will only lead to integrity problems, but I am curios to know why you want to reuse...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2008 at 3:13 am
I've had the same issue few times a while ago. I don't remember the exact numbers but it was similar to your case (the QA shows few hundreds logical...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 3, 2008 at 9:33 am
You can't send parameters into a trigger, but I think that you have anything that you need. You know which table was modified, you have both versions of the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 3, 2008 at 4:37 am
lav (12/3/2008)
Actualy i m developing one web application When user login in my web application i do anything i want to sotre in a table for eg, he...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 3, 2008 at 4:12 am
pickgoods (12/2/2008)
Converting varchar to datetime T-SQL.Hi, experts
How do I convert a varchar hhmm into a datetime 13:30:00 if the varchar hhmm = 1330?
Thank you.
Jeff's answer will work...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 3, 2008 at 2:41 am
I'm sorry, but I couldn't understand what you want. Can you try to post your question again with a better description of what you want to achieve?
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 3, 2008 at 2:33 am
Viewing 15 posts - 1,336 through 1,350 (of 1,479 total)