SQL Querey Problem
Dec 27, 2000Hi all,
I want to know
"How could i identify which index is taken for the query"
is there any command or through profiler can we able to find?
please help me.
thanks on reply for advance.
Murali
ADVERTISEMENT
How Can I Querey By Col_id?
Oct 11, 2007If I do a select * from _schema where table_name = "xyz"
I get a list that shows:
table_name, colid, name, etc, etc, etc
What I am wondering is how to write a query where I could use the table colid in place of the table names.
So for example if I wanted to execute the following query:
SELECT premium_payment_individual_id, premium_payment_id, assigned_number, identification_code_id
FROM premium_payment_individual
If the colid for those table column names were 3 8 9 and 11 is there a way to construct it so it was something like:
SELECT colid.3, colid.8, colid.9, colid.11
FROM premium_payment_individual
Querey Not Working
Dec 1, 2007Hi!
This is my table
----------------
create table brand(lno int,date1 datetime,pdes varchar(15))
insert brand values(1,getdate(),'First Pdt')
insert brand values(1,getdate(),'SEc pdt')
insert brand values(2,'2007-11-01 2:13:01.123','Thir desc')
insert brand values(2,'2007-11-01 3:13:01.123','4th desc')
I want this output:
--------------------
pdes date1
-------- ---------
SEc pdt 2007-12-01 10:14:13.263
4th desc 2007-11-01 03:13:01.123
I tried this querey but it is not working! please anyone help me!
select t.pdes,t.date1 from brand t join (select convert(varchar(12),max(date1))as date1 from brand group by lno) t1
on t1.date1=t.date1
Thank You!
Passing Parameters To A Querey With A LIKE Operator
Jun 6, 2008I'm trying to get string data from a database using this bit of code:
string SQL1 = "SELECT Title, Type, MID FROM Movies WHERE Title LIKE '%@Title%'";
SqlCommand MyCommand1 = new SqlCommand(SQL1, Conn1);
MyCommand1.Parameters.AddWithValue("@Title", TXTTitle.Text);
It doesn't seem to be returning anything when I try this. I've never thought to try and parameterize a LIKE before and I'm not sure on the proper syntax.
Thanks in advance!
Find Querey Execution Time
Nov 22, 2007Hi!
How can i find the querey execution time in sql 2000.
If u have any article or books online please suggest me.
Thanks!