Programming SQL

some problem using schema
Hello there I change some of my procedures as schema It works fine. but when i saw the definition of these procedures in sys.sql_modules the create statement still goes to DBO. why? ... 12 Jul 2010 17:25

Slide database image
Hii i need to slide images which are coming from database. and also i need to slide image with the button click. can anybody help me? ... 12 Jul 2010 17:25

Help about numeric type field. Thanks.
I created a SQL Server 2005 CE DB ( .sdf, version 3.0) with vs2005. And I created a table which has 2 fields: fld1 - int, fld2 - numeric(38,25). But I encounted an error messagebox when I tried to insert a record (4005,9000000). The msgbox said Conversion overflows. The setting for my numeric fld2 is (precis... 12 Jul 2010 06:20

Help with Query
Hi I need help building a query. Hi have this table: Cunter day 09-07-2010 Reg_Numb DateTime value 1 09-07-2010 09:00 5000 2 09-07-2010 10:00 5010 3 09-07-2010 11:00 5050 4 09-07-2010 12:00 5100 5 09-07-2010 13:00 5150 6 09-07-2010 14:00 5200 7 09-07-2010 15:00 5... 12 Jul 2010 06:20

SqlTransaction Problem
Hi all In my web application I have following code: SqlConnection con = new SqlConnection("Data Source=.;Connect Timeout=15; Initial Catalog=SaamicAcc1;Integrated Security=True"); SqlCommand com = new SqlCommand("",con); com.Parameters.AddWithValue("@A", "somevalue"); com.CommandText = "Insert into Test... 12 Jul 2010 17:25

using insert with output
Hello there. I have two tables i need to insert table2 to table1. the field: ID (unique identity) on table2 exist already on table1. So i need insert the data to table1 and get new identity for each rows and get table of the new identity vs old identity: for examlple vstable old_iden, new_iden 5 , 12... 12 Jul 2010 06:20

What is the best way to write a sp to insert a row having more than 200 columns?
Hi, I have two tables having many columns. One has 215 columns and another has 95 columns. I am writing insert sp for these two tables. I think it is no good way to pass in 215 parameters into a insert sp. But what is the best way? Pass XML? Thanks. Peter ... 12 Jul 2010 05:16

Index/Query Optimization Question
I have the following query from a single table with 50,000 rows select col1,col2,col3,col4,col5,col6 from mytable where col3<2 and col4 is null or col3<2 and col4 is not null and col5 is null and datediff(hour,col6,sysdatetimeoffset() ) > 1 col3 is type int (could be a smallint or a tinyint, but it is a... 12 Jul 2010 05:16

setting [] in like operator
Hello there the current sql: declare @T varchar(100); set @T = '[my name]' select * from dbo.TBL_clients where client_name like '%' + @T + '%' returns all the table why? ... 12 Jul 2010 05:16

question about replace function
Hello there I have table of 100,000 records I made a replace on each record in some fields. It works fine but it cost almost 100% cpu. does someone knows why? ... 11 Jul 2010 18:12