|
You need to use ## for a global temporary table. A temporary table whose name begins with a single # is a local temporary table and is local to the connection.
SQL Server 2005 documentation says:
"There are two types of temporary tables: local and global. They differ from each other in their names, their visibility, and their availability. Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user, and they are deleted when the user disconnects from the instance of SQL Server. Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server."
|
|
|
|
|
Hi good people.
I'm trying to update a table in mysql.
Here is the code:
For Each file12 In files<br />
<br />
array12 = System.IO.Path.GetFileNameWithoutExtension(file12).Trim<br />
<br />
<br />
Dim FileSize As UInt32<br />
Dim rawData() As Byte<br />
Dim fs As FileStream<br />
fs = New FileStream(cale12 & "\" & array12 & ".buf", FileMode.Open, FileAccess.Read)<br />
FileSize = fs.Length<br />
<br />
rawData = New Byte(FileSize) {}<br />
fs.Read(rawData, 0, FileSize)<br />
fs.Close()<br />
<br />
par.ParameterName = "?BinData"<br />
<br />
cmd.CommandText = "update notiz set Bindata=" & par.ParameterName & " where Nr=" & Chr(39) & array12 & Chr(39)<br />
<br />
par.Value = rawData<br />
<br />
cmd.Parameters.Add(par)<br />
cmd.ExecuteNonQuery()
It works for the first field but when I try to update the second field I have the error:
Parameter '?BinData' has already been defined.
Please help.
Thanks
|
|
|
|
|
Hi,
I think the problem is because you create parameter name on every cycle.
Why don't you try to create parameter name only once at first cycle
|
|
|
|
|
Hi,
Thanks for the idea.
It works.
Regards.
|
|
|
|
|
Is there a utility or simple way to determine the size (number of bytes) of records in a table?
I'm trying to determine what I would save in disk space if certain records were removed/archived out of a SQL Server 2000 DB.
I understand that record size depends on contents (VARCHAR(30) vs CHAR(30)).
Thanks.
|
|
|
|
|
How about running:
exec sp_spaceused 'MyTableName' That gives you the number of rows, and the amount of space taken-up by the data and indexes.
|
|
|
|
|
That's exactly what I needed, Andy. Thank you.
|
|
|
|
|
There is a code which displays results of SQL-query in dataGridView:
dataGridView1.DataSource = bindingSource1;<br />
dataAdapter = new OleDbDataAdapter("SQL-query", connectionString);<br />
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);<br />
DataTable table = new DataTable();<br />
dataAdapter.Fill(table);<br />
bindingSource1.DataSource = table;
Whether probably in a similar way to display results of SQL in the table in reportViewe?
Thanks.
|
|
|
|
|
I planned to update a set of values in a stored procedure and what the procedure will return if there is an error and how can i get it from C#
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
If you are using c# dot net catch a "SqlException" . In SQL procedure you can use RaisError function.
Regards,
Vimal
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
if <error_occurs> then
begin
RaisError('error....',16,1)
end
The name is Sandeep
|
|
|
|
|
Thank you
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
Hi all,
i want to know How to find exact record in my table.
ex : in a table having 10 records.
i want 5 th record. with out knowing details containg in a table how can i find it. only know table name.
pls help me.
|
|
|
|
|
Here u get the 5th record
SELECT TOP 1 FName
FROM
(
SELECT TOP 5 FName
FROM Names
ORDER BY FName Desc
)
|
|
|
|
|
hi Prasad,
Thanks for u r valuable solution, its working by making some modifications.
this is working properly
SELECT TOP 1 sal
FROM prs where sal in (SELECT TOP 4 sal
FROM prs
ORDER BY sal )order by sal desc
all the best
|
|
|
|
|
Are you trying to get nth Max or Min value
or trying to fetch specific row by number.
Regards
KP
|
|
|
|
|
How can i set the default value to the column while designing the table in SQL Express 2005 GUI
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
[Created] [datetime] NOT NULL CONSTRAINT [DF_PurchaserTransactionMaster_Created] DEFAULT (getdate())
[Total] [decimal](12, 2) NOT NULL CONSTRAINT [DF_PurchaserTransactionMaster_Total] DEFAULT (0)
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Dear Sylvester,
I want to know how i can achieve this in GUI i.e which property of the column can i use. is it by default value or binding and while doing this i can simply specify the value alone know, otherwise should i prefix the value with any special characters.
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
when you create a column you can see a detailed section in the bottom. There you can set the default value.
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hello
Is it possible to drop two tables located on two databases in different servers using a single query ?
|
|
|
|
|
why you need to do it in a single query...
you can do it in two seperate quires....
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
vimal_yet wrote: you can do it in two seperate quires....
Thank you. But I don't want to do this. If I am satisfied with doing this, what is the necessity of posting a question here on this topic .
|
|
|
|
|
try using this
drop table [servername].[instancename].username.<tablename>
example:
drop table [dbserver].collegedetails.dbo.stud
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
I have the following Stored procedure. There is column named
"tcktreceived" in my database and I want to pass all the rows one by
one to the parameter @starttime. I don't know how to do it.
CREATE PROCEDURE [twcsan].[usp_DateDiff]
-- Add the parameters for the stored procedure here
@starttime DateTime
AS
BEGIN
DECLARE @Diff Varchar(15)
DECLARE @Day INT
DECLARE @Hour INT
DECLARE @Minute INT
DECLARE @Start_Date DateTime
DECLARE @End_Date DateTime
DECLARE @itemReceived DateTime
DECLARE @ID INT
DECLARE @message VARCHAR(50)
DECLARE @table TABLE
(
ItemReceived DateTime,
ID INT,
message text,
Differnce VARCHAR(20)
)
SET NOCOUNT ON;
SET @Start_Date = @starttime
SET @End_Date = GETDATE()
SET @Day = DATEDIFF( day, @Start_Date, @End_Date)
SET @Hour = DATEDIFF(hour , @Start_Date, @End_Date)
SET @Minute = DATEDIFF(minute , @Start_Date, @End_Date)
SET @Minute = @Minute-(@HOUR* 60)
SET @Hour = @Hour-(24* @Day)
SET @Diff = CONVERT(Varchar, @Day) +'d ' + CONVERT(Varchar , @Hour) +
'h ' + CONVERT(Varchar , @Minute) +'m'
INSERT INTO @table(ItemReceived, ID, message, Differnce)
select tck.tcktreceived, tck.ticketid,tckmsg.tcktmessage,@Diff
from tbtickets tck inner join tbticketsmessages tckmsg
on tck.ticketid = tckmsg.ticketid
select * from @table
END
seema
|
|
|
|