Viewing 15 posts - 1,126 through 1,140 (of 1,478 total)
You can do it char(1) with check constraint that will limit the values to M or F. BOL has some examples on how to define check constraint (look 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/
February 22, 2009 at 6:38 am
Sorry, I don’t realy know how to get the second recordset using SQL Script. If no one will be able to offer you a way to do it, you...
--------------------------------------------------------------
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/
February 22, 2009 at 5:36 am
The data type that fn_get_sql returns is text. This data type has some restrictions. One of the restrictions is that it can not be used in correlated sub query....
--------------------------------------------------------------
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/
February 22, 2009 at 3:53 am
If you want to check a login, you can run sp_helplogins stored procedure. It will show you (among other things) the mapping users that the login has in all...
--------------------------------------------------------------
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/
February 22, 2009 at 3:30 am
I don’t think that you can pass a column from a query as a parameter to fn_get_sql function. I think that you have to get the sql_handle to a...
--------------------------------------------------------------
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/
February 22, 2009 at 3:25 am
Yes you can. You can setup trust relations between both domains. Take a look at this KB article for more details - http://support.microsoft.com/kb/321247
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/
February 22, 2009 at 2:35 am
I have to admit that I didn’t understand the part about your application, but there are few remarks about your log file. First of all stop shrinking 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/
February 18, 2009 at 10:49 pm
It sounds like after you are writing the script with CREATE TRIGGER statement, you are using the menu or the tool bar to do save operation. This operation just...
--------------------------------------------------------------
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/
February 18, 2009 at 10:34 pm
If I remember correctly, SQL Server did support left and right join using the old syntax (*= or =*), but it didn’t support full outer join using the old syntax.
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/
February 18, 2009 at 1:32 pm
htilburgs (2/18/2009)
Ok..... I didn't understood the first reply from Adi.I've tested and now I've got a good result, but.....
All you had to do as ask for clarifications:-)
Can it be, that...
--------------------------------------------------------------
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/
February 18, 2009 at 1:25 pm
If you'll show us the code that you are using and explain what you are getting, you'll have a much better chance to get help.
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/
February 18, 2009 at 12:43 pm
Michael Valentine Jones (2/18/2009)
jgrubb (2/18/2009)
I just ran the following code on SQL Server 6.5 and it worked fine:
I have to admit that I’m amazed that you have SQL Server 6.5...
--------------------------------------------------------------
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/
February 18, 2009 at 12:32 pm
With windows authentication you don’t pass your credentials at all. SQL Server gets you credentials from the OS. In order to solve your problem you can try to...
--------------------------------------------------------------
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/
February 17, 2009 at 10:42 pm
I think that the correct answer is the answer that shows those dates:
2009-02-01 00:00:00:000, 2009-01-31 00:01:01:000, 2009-01-31 21:59:58:347
All the dates are in the time frame that was in the query...
--------------------------------------------------------------
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/
February 17, 2009 at 1:49 am
Could it be that you are connected to a different server in the management studio?
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/
February 17, 2009 at 1:17 am
Viewing 15 posts - 1,126 through 1,140 (of 1,478 total)