srinit
Last Activity: Apr 6 '10, 11:18 AM
Joined: Jun 22 '07
Location:
-
Can you please tell me how can i write that procedure.... -
Recursive update query
hi
i have a table like
col1 col2 col3 col4
35 R 0 0
36 W 1 35
37 R 0 0
38 W 2 35,36
I am giving col1 value 35 as input
i want to write a update query so that the result
col1 col2 col3 col4
35 C 0 0
36 R 0 0
... -
Execute following system procedures which returns all databases names.
sp_databases
cheers..//Leave a comment:
-
Can you tell me your requirement clearly..and post the code what you tried
cheers..//Leave a comment:
-
you can get loads of data related to encryption and decryption by litle googling .
Go through the below link for certifiction details
http://www.microsoft.c om/learning/mcp/mcts/sql/default.mspx
cheers..//Leave a comment:
-
srinit replied to Selecting Fixed No of rows from table and that rows should be dynamically selectedin SQL ServerHi
Can you tell me your requirement clearly....Leave a comment:
-
what is use of smo
I am working on sql 2005..i want to learn about sql server management objects.
i want to know why i have to use smo if i can same using enterprise manager..
i googled on it but i didnt get the ans..please give me related links...
Thanks -
generating sql server reports
HI
I am working on sql2005. i am trying to genrated a report. the data base is designed in access. i connected to that database and i create a data set .
in that data field.i want get the data between two dates
i write
select * from iodata where iodate>=? and iodata<=?
and i created two report parameters date1 and date2
and in dataset parameters i assign these as ?=parameters!da te1.value... -
importing database from access to sql2005
hi
i am working on sql2005. i am trying to import database from access including relations by using SSIS.any one suggest me or give me the links.
Thanks in advance. -
hi....
you are trying to insert images into table using vb.net ,asp or c# .net .tell me which one...Leave a comment:
-
Hi
You can do by searching in sql books online.
Ok.......add primary key constraint on one column in one table using alter table add constraint.add refference constraint on one column in other table
example:
[code]
CREATE TABLE doc_exe ( column_a INT CONSTRAINT column_a_un UNIQUE) ;
GO
ALTER TABLE doc_exe ADD
-- Add a PRIMARY KEY identity column.
column_b INT IDENTITY...Leave a comment:
-
Hi,
Can you tell me your requirement clearly
send your code...Leave a comment:
-
Yah.
I got the same doubt .is there any to find the time of insertion of a particular row...Leave a comment:
-
hi
I am not clear with your code. try with this code .this is not exactly suit for ur requirement but this idea will help you
[code]
declare cur1 for select VolID from Transactions WHERE TransactionTime BETWEEN @From AND @To
open cur1
fetch next from cur1 into @VolID
while @@fetch_status= 0
begin
SELECT VolFrstNameEN, VolLastNameEN FROM VolMain WHERE VolID= @VolID
fetch...Leave a comment:
-
HI
I am sending an example .It will help you
[code]
create pro pro1(@a int)
as
begin
while(@a>0)
begin
exec('create table table+'+@a)
set @a=@a-1
end
end...Leave a comment:
-
Hi,
Can you send me how you tried it...Leave a comment:
-
Hi Atul,
I am not clear with your requirement.any way use distinct keyword .it may help you...Leave a comment:
-
hi
Can you tell me your requirement clearly.
Use charindex and substring...Leave a comment:
-
Hi Nithya jayaraman,
Username function returns domain name and user name of the current connection...Leave a comment:
-
Hi
Can you explain me your requirement clearly.
And send your code what you tried...Leave a comment:
No activity results to display
Leave a comment: