-
Hi Can anyone tell me how can i get recorded time stamps using UTC based on ISO 8601 in Sql server 2005 Example: "1994-11-05T08:15:30-05:00". if i want to achieve this i must specify each element in the format ? Thankx for you valuable time !
-
There are lot resources regarding the xml datatype in SQL 2005. For a start please go thru the links below http://weblogs.sqlteam.com/travisl/archive/2005/01/04/3931.aspx http://www.sql-server-performance.com/articles/dev/xml_data_2005_p1.aspx Amal
-
Is there any way to apply version control in SQL Server using VSS? In SQL Server management studio there is some options available to add the solution to Source control. But I couldn't find any check-in / checkout options for SPs. I saw some blog posts about Version control of SPs via VS 2003, but...
-
Nesting limit is 32 levels, SQL Server has no limit on the number of stored procedures that can be invoked from a given stored procedure, provided that the subordinate stored procedures do not invoke other subordinate stored procedures and the maximum nesting level is never exceeded. You can view the...
-
When your database grows, the index fragmentation becomes too high,that will scale down the performance of the sql server. To overcome that we need to re-build the index, that should be done at the down time of the server.Here there is a query that will list all the index to be recreated/rebuild.It uses...
-
Hi, For your client application to programmatically connect to SQL Server 2005 database residing in a remote server, all you need in the client computer is the .net framework. If you use the classes in System.Data & System.Data.SQLClient namespaces in your code, you should be able to connect to the...
-
Hi If I write JOIN in a UPDATE Query in SQL SERVER 2005, Wil there be any performance Issues !? . EX: UPDATE MasterTable SET Column = NewValue FROM MasterTable INNER JOIN SecondTable ON MasterTable.Key = SecondTable.Key Please post your valuable Comments !!
-
In my current project, I was using "sa" user to connect to SQL Server. But I don't think it is a good practise. So I thought of implementing a new user for the Database instead of "sa" . What are the minimum roles / previlages required for a user to connect and Execute SPs. I...
-
No that is the reverse process that i know,bulk copy program importing from table to file.In my scenario i need the reverse,i'm having some user and associated roles in an excel file that should be imported to a temp table and the SP should loop through that record. Regards Renju.R http://blog.renjucool...
-
Hi I have to take and save the date and time of Different US Regions. I have 3 different Types 1) My client Time 2) Server Time 3) DB Server Time. In DB i can take the GETUTCDATE() function to get the UTC time and Convert them to Client time during the Client request. But .. during the Day light saving...