Topics
Started by
Posts
Last post
I would like to know if there is a sys table to query to see if a foreign key is enforced or not. …
4 replies
I have this sql query (my User defined function, it takes string parameter and returns a table with…
1 replies
How can i convert 'Friday, August 15, 2008, 7:30 pm' to '08/15/2008'?? i need the sql query....i ha…
1 replies
I have had a similar issue recently but cant figure this one out. i have the below data in a table …
5 replies
I have three tables in which i am trying to retrieve orders that have a shipping address which is d…
18 replies
I am creating a table where the rows for one of the columns are rows returned by a stored procedure…
8 replies
Hi.. I'm trying to import data from a CSV file into a table. I've a CSV file (same as Adventurework…
2 replies
How could I find store procs in a database which are using cursors? List of store procs in which cu…
1 replies
I would swear I've done this before, but I'm drawing a blank today. I have a table with lots of row…
19 replies
Hi I have an Access db. I have to pull one of the tables in this db to sql server 2005. This is not…
2 replies
I'm hoping someone knows which system table or view I can query in a stored procedure to get the na…
2 replies
Hi, I'm trying to debug a stored proc that creates temp tables. In 2000 Query Analyzer, I could re…
8 replies
Correlated sub query takes more time to return result...Please help in spiltting this into join... …
11 replies
I have a temporary table that (based on its current values) would fit nicely one-to-one across two …
5 replies
Hello guys, my question is: Is there any performance defects if I use Try...catch blocks in my stor…
12 replies
Viewing 15 topics - 9,271 through 9,285 (of 12,230 total)
You must be logged in to create new topics.