Topics
Started by
Posts
Last post
create table mytable (policyid int, trandate datetime, amount money) insert mytable (policyid, tran…
3 replies
;WITH emps(empID,Percent) AS ( SELECT empID, case when COUNT(DISTINCT payid)>…
3 replies
hi members, how to create a table in a different server apart from the server your working thanks, …
3 replies
I have the following code: DEclare @Level10bit Set @Level10 = 1 IF (@Status = 'All Active') BEGI…
19 replies
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
Viewing 15 topics - 9,271 through 9,285 (of 12,234 total)
You must be logged in to create new topics.