1.How many columns a SQL table can hold.

2.How many string functions are there in SQL.

3.How many non-clustered indexes a SQL table can have.

4.What is the port to be used to...

You can use the un-documented SP "sp_MSforeachdb" for this

IF OBJECT_ID('tempdb..#tmp_Indexes') IS NOT NULL

DROP TABLE #tmp_Indexes

DECLARE@strSQLVARCHAR(2000)

DECLARE@IndexName VARCHAR(1000)

CREATE TABLE #tmp_Indexes

(

DatabaseNameVARCHAR(100),

IndexNameVARCHAR(1000)

)

SET@IndexName = 'mst_Employees_IX01' -- You can enter the name of the index here

SET@strSQL...

Probably something like this

SELECTCounts AS Num_Users_in_Acc, COUNT(Acc_no) AS [COUNT]

FROM(

SELECTCOUNT( users ) AS Counts, Acc_no

FROMTemp_1

WHEREarea = 'PMB'

GROUP BY Acc_no

) T

GROUP BY Counts

Please describe the problem you have along with DDL, some sample data and the expected results

Check the link in my signature if don't know how to do this

Check the data types of date columns in your SELECT list

I assume you have some column with CHAR or VARCHAR as their datatype, convert them to SMALLDATETIME or DATETIME

With this approach, I am sure...

greeshma.patla (9/11/2012)

---

MERGE INTO LKP_PARAM_TYPE AS C

USING (

...

What are the expected results based on your data?

No. There is no specific syntax available for this purpose.

You will have to manually type in the column names or use some tools like SQL Prompt which will list out...

Do you have any trigger on the table "deposits_daily_balance"?

raghuldrag (7/27/2012)

---

Hi,

Above the my procedure query giving output,i m splitting the amount column has credit and debit,closing_bal column is sum of account is E=>debit-credit,

...

raghuldrag (7/27/2012)

---

hey friend my actual table ve lakhs of data per month,after making the query,I m expexting ve to display account only one time per month and its has been...

SELECTSESSIONPROPERTY('ANSI_PADDING')

If you have a UNIQUE KEY constraint on the column Col1 of table T1, then its possible to define a FOREIGN KEY as you have mentioned

But, if the column is...

Yes. Excel is another good option.

I use a combination of both, sometimes Excel and sometimes Dynamic SQL.