Viewing 15 posts - 2,926 through 2,940 (of 3,738 total)
setiv (5/23/2011)
But I don't have links to the source of codes .
In the architecture this situation is usually called eclectic.
Took something, but something forgotten .Today...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 25, 2011 at 8:22 am
You may want the Table Name as well.
SELECT obj.name AS TableName,col.name AS ColumnName,col.definition
FROM sys.Computed_columns AS col
INNER JOIN sys.objects AS obj ON col.object_id = obj.object_id
ORDER BY obj.name, col.name
For better, quicker answers on T-SQL questions, click on the following...
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/
May 25, 2011 at 8:14 am
Is RunDT in your table or is there a trigger on the table?
For better, quicker answers on T-SQL questions, click on the following...
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/
May 25, 2011 at 7:58 am
SELECT name,definition
FROM sys.Computed_columns
For better, quicker answers on T-SQL questions, click on the following...
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/
May 25, 2011 at 7:53 am
I thought that DT_I4 is equivalent to int?
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 4:40 pm
You can't create a view with a parameter.
Create a Stored Procedure.
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 3:42 pm
prashantcomp90 (5/24/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 2:58 pm
prashantcomp90 (5/24/2011)
which information u need. u have the table details output details. other han this if u need information i will provide u please do some thing..
How about the DDL...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 2:32 pm
prashantcomp90 (5/24/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 1:56 pm
If a Global Temporary Table has no connections to it then it is deleted.
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 1:17 pm
A restart of services are required after installing a Service Pack or a Cumulative Update and it is a good practice to reboot the server after installing a Service Pack...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 1:01 pm
What are you collation settings set to in each database? Are they they the same?
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 12:51 pm
prashantcomp90 (5/24/2011)
look I need the output like this:
:
Just because you want the output in a specified output does not mean that the solution is a view.:w00t:
Why not create a Stored...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 24, 2011 at 12:46 pm
You should try installing the Client. Perhaps the application Development Client
That should include the Driver that you are looking for.
This may be trial and error. You may want to try...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 23, 2011 at 12:31 pm
PaulB-TheOneAndOnly (5/22/2011)
Diane Davis (5/19/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 23, 2011 at 12:21 pm
Viewing 15 posts - 2,926 through 2,940 (of 3,738 total)