Viewing 15 posts - 9,886 through 9,900 (of 15,381 total)
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...
December 4, 2012 at 7:43 am
boobalanmca07 (12/4/2012)
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...
December 4, 2012 at 7:35 am
Mile Higher Than Sea Level (12/3/2012)
I figured it out with some trial...
December 3, 2012 at 11:44 am
bbaine (12/3/2012)
Thanks for the reply. The nolocks were there when I came to the company. They love to use them.
You should have somebody there read those...
December 3, 2012 at 11:17 am
Mile Higher Than Sea Level (12/3/2012)
When the Query is run for a MakeTable or Select,...
December 3, 2012 at 11:03 am
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...
December 3, 2012 at 11:01 am
bubby (12/3/2012)
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c)...
December 3, 2012 at 7:46 am
select tableA.Col, COUNT(Tableb.ID) as MyCount
from tableA a
join Tableb b on a.ID = b.ID
group by table.Col
December 3, 2012 at 7:36 am
Minnu (12/3/2012)
BEGIN
SELECT RTRIM(
+ISNULL(Col_Name,'')+' : '
+ISNULL(+CAST(ColB AS VARCHAR(10))+' ','')
...
December 3, 2012 at 7:33 am
lex9120 (12/1/2012)
December 3, 2012 at 7:22 am
sasansamani (11/30/2012)
SELECT DMax("[AssetNumber]","Waste Hauler Number","+1") AS Expr1 FROM [Waste Hauler Number];I am getting two 4001. What I am doing incorrectly?
The last parameter is the criteria (it acts like a where...
November 30, 2012 at 3:12 pm
sasansamani (11/30/2012)
Right now my problem is how do I validate against another table?...
November 30, 2012 at 1:57 pm
sasansamani (11/30/2012)
November 30, 2012 at 1:32 pm
Viewing 15 posts - 9,886 through 9,900 (of 15,381 total)