Topics
Started by
Posts
Last post
Hi, in the store proc xp_cmdshell to run a vbs.script which count number of files in a folder…
5 replies
Some one please tell me the T SQl syntax of 1-Disconnecting the Users of a DB 2-Killing the session…
6 replies
I have to build a dynamic query, now again the problem is the size limitation of VARCHAR i.e 8000. …
13 replies
I have 2 store procs: procA and procB, procA is in database dbA and proB is in dbB. procB is called…
5 replies
After my last post (MUCK tables)... please be gentle. (Yes, I owe her dinner!) I am trying to…
6 replies
hi, I need help building the SQL for this one... I have 2 tables, one a lookup tbl, the other tbl h…
2 replies
Probably we can't trick the nature, but anyhow. Is there any way (tips) to optimize query with LIKE…
15 replies
I have a s_p that retrieves data from the post table Bu i want to have a subquery between for examp…
12 replies
Is there a way to select the last n records inserted into a table? I have a table with just a singl…
12 replies
I have a database with two tables. I'll call then table1 and table2 to ease. When data has been ins…
2 replies
Hi, I am creating an ASP.NET application to create a database programmatically. The applicatio…
9 replies
This is how my current cursor looks like and i need someone's expertise to show me if this is possi…
7 replies
Hi All, I have a case statement subquery, and it returns a resultset containing many null values wh…
6 replies
I am joining two tables based on two fields such as: a.CustomerID = b.CustomerID and a.LocationID =…
6 replies
Good morning, Being a complete newbie to SQL, I would like your advise on how to write a simple tri…
7 replies
Viewing 15 topics - 8,806 through 8,820 (of 17,082 total)
You must be logged in to create new topics.