I would like to find out the listening port number that is on the SQL server. This have to be done via transact sql. Also, is there any way to know whether is this a static or dynamic port?
I\'m maintaining a few projects for different customers. Some of them user Sql Server 2005 and others use 2008.
I have query to find Records in to single records from two rows withFirst AttTimeand Last AttTime using SQL Server 2005
i have one store procedure like : ALTER procedure [dbo].[prcDisplayTpTestimonial] @personname varchar(100),
I cannot seem to get a [comma-]delimited string out of an XML doc using just SQL Server 2005 XQuery.
Ok I have two tables. Table IDAssoc has the columnsbill_id, year, area_id. Table Bill has the columns bill_id, year, main_id, and amount_due.
i have a little question to ask i have a following data in database column . isLoggedIn=False&CurrentReferral=http://ufone.testSite.tv/Messaging.aspx?aspxerrorpath=/abc.aspx&kw=&FirstVis
I have two tables like this: Table1开发者_运维百科Table2 ---------------------------------- Table1Id IDENTITYTable2Id
I have an xml file with some data and inline schema attached to it. If i use it in SSIS (2008 or 2005) xml source component, I get no output to any destination (tried, raw file, flat file, excel, ole
My company has to go back to Sql Server 2005 from 2008R2 (legacy issues with scripts and customer deployment.. ) and I got the task to find out how to do that: is there any automated migration tools (
加载中,请稍侯......