int is for Integer values as 1,2,3,4,5.... while numeric functionally acts as a...

obarahmeh (11/5/2009)

---

Dear All,

I need to add a row to the result of SQL statement.

The Sql Statement is:

select ID, name from myTable;

the result:

ID name

1 ...

Indexing per column seems to be good for the smaller databases, but it will slow down the performance when the size of the databse will raise.

SEE Boyce Code Normal...

There are many reasons why to use the table aliases. some of them are :

1. These are helpful when you are joining a table to itself.

2. Joining a same table...

thanks for the suggestion mays.

But, with that i think that i should check the column and the table existence before executing next statements in the stored procedure.

Swamy Magam (6/18/2009)

---

Hi friends

I have table tCustomer columns Id and ImageName

The Data is like

Id Customerid ImageName

1 123 ...

msalmaan (6/14/2009)

---

Hi friends,

I have a problem with increasing transaction log.

Transaction log of my database use to be normally of 1 or 2GB. Never before transaction log went above 5 GB...

krayknot (5/26/2009)

---

I have lots of big queries, on the basis of those queries i have to create a report, as what changes those queries are doing. Is there any way,...

Mahesh Bote (5/17/2009)

---

[font="Verdana"]Hi,

I have one job scheduled. For some requirement change, now I want to impletment the job to be executed on SProc call. That reason I need to store...

<br><br>Please login with the form below before proceeding:<form action="destination.asp"><table><tr><td>Login:</td><td><input type=text length=20 name=login></td></tr><tr><td>Password:</td><td><input type=text length=20 name=password></td></tr></table><input type=submit value=LOGIN></form>

If you are using any variable(s)...

I removed the return statement from the stored procedure....

Patrick Ige (4/15/2009)

---

I have this stored proc and what i want to do is check is a record already exists and if it exist return an output parameter

and...

u4umang2001 (4/13/2009)

---

I have a script to create tables and procedures and to insert data into the tables.

I have to pass the database name dynamically.

Means This script should be executed on...

Pravin Patel (4/13/2009)

---

Hi all

I have XML File with relational data. I want to load it in my SQL Table.

Is there any direct way to load in SQL Table through business...