Topics
Started by
Posts
Last post
NOT NULL Constraint Ignored During BULK INSERT I am having trouble with a BULK INSERT that is not g…
2 replies
Hi, I'm trying to transfer data from table A to table B (cant be a temp table must be an actual ta…
1 replies
I have a HUGE table (TableA), and I need to insert data from TableA to TableB. I have developed thi…
17 replies
Can somebody help me with a stored proc that will go through a table and perform updates based on m…
5 replies
Hi I have added the following code on the modify trigger: USE [Testdb] GO /****** Object: Trigger …
6 replies
I have 2 similar tables with a date column haveing defaultvalue to get date but when i script these…
1 replies
suppose i have three tables called Department ------------- DeptID DeptName ------ --------- 1 …
4 replies
Hi, I'm trying to grab some stats on Database up time. I can't seem to get this to parse out the l…
8 replies
when we load xml into cursor then we specify column name and their datatype and size in with block.…
1 replies
I have a table (table PS) with 20 fields e.g. currentvalue1, currentvalue2 ...etc These fields are …
5 replies
Hi, I am trying to import data from an excel spreadsheet (2003) into SQL SERVER 2005 using openrows…
2 replies
Hi All, i need help to create the store procedure. below is the table, id int name varchar(7), Addr…
1 replies
I have the following set of T-SQL -- can anyone see a method of changing it to a set based operatio…
117 replies
I have the query below which will be used in ssrs. the problem i have is that i need to query data …
3 replies
Hi All, I need help about the syntax of the sql as below When I try to Execute the tsql as below I …
7 replies
Viewing 15 topics - 1,981 through 1,995 (of 12,234 total)
You must be logged in to create new topics.