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!
-
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!
-
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...- nacrotek
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
-
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()... -
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...- nacrotek
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
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- nacrotek
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
