There are basically 3 ways to handle storing binaries with sql.

1) Store the files on disc in a folder and then store the file name in sql. You basically just...

boobalanmca07 (12/4/2012)

---

i have using two query in stored procedure, i want to use insert query in some time only

alter proc proc_emp1

@i int,

@pempid int,@pempname varchar(30),@pm1 int,@sm1 int

as

print @i

if @i<=1

begin

--if @i='I'

insert...

Mile Higher Than Sea Level (12/3/2012)

---

Sorry about the cross up in terms. In Access code, we can Execute a query (of a SQL View).

I figured it out with some trial...

You should have somebody there read those...

Mile Higher Than Sea Level (12/3/2012)

---

In MS Access - a query can have a column defined as MyTimeStamp: NOW()

When the Query is run for a MakeTable or Select,...

Hi and welcome to SSC. I would love to help but there are not enough details in what you posted to be much help. Please take a look at the...

You're welcome. Glad that worked for you. 😀

bubby (12/3/2012)

---

I have to SQL Server and one has version,

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c)...

select tableA.Col, COUNT(Tableb.ID) as MyCount

from tableA a

join Tableb b on a.ID = b.ID

group by table.Col

Minnu (12/3/2012)

---

Hi Team,

BEGIN

SELECT RTRIM(

+ISNULL(Col_Name,'')+' : '

+ISNULL(+CAST(ColB AS VARCHAR(10))+' ','')

...

lex9120 (12/1/2012)

---

I'm not sure exactly what the result would look like because they're just asking it from me. However, I'd like to see what the guru's would write...

You're welcome. Glad that worked for you.

The last parameter is the criteria (it acts like a where...

sasansamani (11/30/2012)

---

I made myself confused and you. I need more coffee. I thought you were referrring to another field.

Right now my problem is how do I validate against another table?...

sasansamani (11/30/2012)

---

Actually my autonumber starts at 1000. You are right. How do I automatically assign random numbers for a 4 or 5 digit number? How do I determine if I...