Viewing 15 posts - 706 through 720 (of 1,478 total)
SQL Server has no arrays or lists. You can try sending it as XML and then use Xquery to get the values that were sent. Another alternative is...
--------------------------------------------------------------
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/
January 7, 2010 at 5:16 am
Saravanan T (1/7/2010)
Hi all,To Encrypt all stored procedures in a database.
Regards,
Saravanan
Is there any question in this statement? If there is can you try to explain...
--------------------------------------------------------------
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/
January 7, 2010 at 4:32 am
jinesh.i (1/7/2010)
When I tried
DECLARE @Table TABLE
(
Matrix_User_ID INT --PRIMARY KEY IDENTITY(1,1)
,OldFirst_Name VARCHAR(20)
,NewFirst_Name VARCHAR(20)
)
BEGIN TRAN
UPDATE MSTR_User
SET First_Name=UPPER(First_Name)
OUTPUT inserted.Matrix_User_ID,deleted.First_name,inserted.First_name INTO @Table
WHERE Matrix_User_Id =1294
SELECT * FROM @Table
ROLLBACK TRAN
SELECT * FROM @Table
It returned row...
--------------------------------------------------------------
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/
January 7, 2010 at 4:30 am
Sanz (1/6/2010)
Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291
There are no matching rows on which to report.
Correct me...
--------------------------------------------------------------
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/
January 6, 2010 at 6:06 am
Did you try using sp_helprotect?
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/
January 6, 2010 at 4:28 am
VALEK (1/6/2010)
There is not enough information.
You should not require any database...
--------------------------------------------------------------
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/
January 6, 2010 at 4:26 am
I’m sorry, but this question is not a good one. With the information that we got from the question, there is no way that can know how many...
--------------------------------------------------------------
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/
January 6, 2010 at 1:24 am
Dave Ballantyne (1/5/2010)
declare @l integer
select @l = 1
while(@l<10) begin
declare @x integer
...
--------------------------------------------------------------
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/
January 5, 2010 at 4:09 am
You can check it with the procedure sp_change_users_login (you can read about it in BOL). If the needed logins don’t exist in the new database, you’ll need to create...
--------------------------------------------------------------
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/
January 5, 2010 at 3:59 am
Personally I have to admit that I’m surprised that you don’t get a run time error saying that you are declaring a variable that was already declared. I guess...
--------------------------------------------------------------
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/
January 5, 2010 at 2:12 am
This is what it means, but this is because January first 1952, is out of range for both smalldatetime and datetime data types, while January first 1953 is not out...
--------------------------------------------------------------
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/
January 4, 2010 at 9:42 pm
Personally, I’d do it in 2 different triggers because I’m doing completely different actions in both scenarios. Having said that, you can create 1 trigger and check if 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/
January 4, 2010 at 6:20 am
Notice that using the IsDate function has some issues. Sometimes it can lead to surprising results as you can see from the small script bellow:
if isdate(1752) = 1
select convert(datetime,...
--------------------------------------------------------------
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/
January 4, 2010 at 6:06 am
This is because your function is returning a string instead of datetime (or smalldatetime). You should return a datetime datatype and compare it to your dates.
One...
--------------------------------------------------------------
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 30, 2009 at 4:19 am
I’m sorry but your message is not very clear. From what I understand, you want to know if you can install SQL Server 2000 and SQL Server 2005 on...
--------------------------------------------------------------
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 30, 2009 at 3:56 am
Viewing 15 posts - 706 through 720 (of 1,478 total)