Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nacrotek

    Append varchar columns from multiple rows?

    Is there a way to concatenate all the varchar values in a result set? I'm looking for an aggregate function that I could use with a group by. Say I've got the following data. ID FK Comment 1 1 Some string value 2 1 Some other string value 3 2...
  2. nacrotek

    Ruby reg exp matching question

    That's what I needed thanks
  3. nacrotek

    Ruby reg exp matching question

    Is it possible to get a complete list of matches made from a regular expression? Here is an example of what I'm trying to do: sTestStr = "exec Trace_p @Comment = 'this is a test string will it work?" reTestRE = Regexp.new("(this|work)") mdMatch = reTestRE.match(sTestStr) puts mdMatch.to_a()...
  4. nacrotek

    Stoping Batch Execution by Conditional

    I have created a batch script that creates stored procedures, alters and creates tables, etc. For a security measure I want to build in a check at the beginning of the batch file to ensure that the batch will only be run against the correct database. Here is what I have tried: declare...
  5. nacrotek

    SQL Server : Select current DB name

    Is there a hidden @@ variable, sp_ proc, or other feature which you can query to get the name of the current DB? I'm looking for something like: declare @currentDBName varchar(100) select @currentDBName = <get current DB name> Thanks in advance

Part and Inventory Search

Back
Top