Programming SQL

What instances on this box?
Is there an MS-DOS command for "What MS-SQL Server instances on this box?" I've tried: sqlcmd -L but it lists everything the box can see, not just what's on the box. ... 17 Jul 2008 10:38

Update with Case Statement
Hello Everybody, I am writing a stored proc for generating a report and it has below SQLs. I am attempting to update the Premium and remittance basing on the source id. But its not giving me the desired result. I am trying to update 34 columns basing on the source id. Could anyone please tell me why Premi... 17 Jul 2008 06:31

Retive username / machine name
Hi, How can i retirve information as follows : 1. User name who execute an sql statement. 2. machine name (on which machine sql statement execute). 3. is sql statement execute by directly by management studio/ qa or an application. and if an appliction, can i get the application name? Rahul ... 18 Jul 2008 06:11

stroing results in a variable
declare @max int select count(lastname) from customers where payment>200 I would like to store the results on the query in @max. How can I do that ... 17 Jul 2008 10:38

Getting the opposite of a join table
I need to find out what relationships do NOT exist in a join table -- employee table create table #E (emp int) insert into #E (emp) values (1) insert into #E (emp) values (2) insert into #E (emp) values (3) -- class table create table #C (cls char(1)) insert into #C (cls) values ('a') insert into #C (c... 17 Jul 2008 22:00

Date Function
Is there a TSQL function similar to the MS-Access "DateSerial(Year,Month,Day)" function, that will convert values for a year, month and day to a date? ... 28 Jul 2008 06:55

Capturing SQL Version
Is there a way to capture the current SQL version into a variable? I want to use this to build a conditional in a stored procedure. Do it this way if your on 8.0 or this way if your on 9.0. - Mark ... 17 Jul 2008 13:45

reading image data type
If someone put text in an image data type, is there a way to search that column for specific data (full-text indexing would NOT be on the column)? In particular, it appears the Content column of the tbl_Content table in the TfsVersionControl database contains the source code for the Team Foundation Server. ... 16 Jul 2008 19:15

EXISTS Query vs Sub Query
Hi Group, I have the following query, but I need to add a column from another table in the resultset. No matter what I do I end up with what seems like a cartesian product. I want the same number of records that this query gives me but just with the additional field (accessstatus) from the other table. SE... 16 Jul 2008 14:03

Finding tables with specific columns
How can I display tables with specific columns? Mainly I am looking to find all the tables that have 4 or 5 different columns. If all these columns are not there, I don't want to see them. I also am trying to do just the opposite. Find all the tables that don't have all 4 or 5 columns - which I could do by ... 16 Jul 2008 17:11