I have partitioned view .I m able to select from the view but not able to insert using view .It gives error cannot insert into partiotioned view...
I have many tables having same structure . I use partitioned view to select data from this tables . I need to change this view after i create new...
I make a partitioned view which consist of about 500 tables all have the same structure . I also need to create similar table and then alter view .i...
I have a table which has about 1-20 million rows .I execute query againt this table in my where clause i have like against 2 columns .I want to...
In my application i have 2 database .I database2 i have separate tables for each entity .This are currently 1000 .I create new tables also but this...
I have table tble1 which has 2 columns I want to write query like which gives output like col1 col2 col3 11 aa 1 23 efd 2 56 rt 3...
I can't understand why this script throw error Syntax error converting datetime from character string. declare @d datetime,@sql nvarchar(500) set...
I want to insert in a table .The rows inserted are return by select query. Insert into table1(col1) select col1 from table2 When select query return...
I has a table which has col1,col2,col3. i can retrive it using select col1,col2,col3 from tbl but i want result like this col1 col2 col3 .I can do it...
We have 3 tables .Table is updated very frequently very fast about 500 update query per second .This table is has very rare insertion.for selection...
I have column which is of type float .I want to write a query which return data upto 2 decimal places .e.g. if data is 324.999999 then it gives...
When i delete records(about 10 lakh rows) from table space on hard disk decreases .I guess this is because of the log written by sql server .What are...
I have field(nvarchar) in table which has maximum length of 8 characters .My need is that suppose if i have string 45 then sql server itself attach...
When i delete rows from table it still consume space in disk .I want to free that space . Thanks
I select from table which has datetime field which may contain null value. When i select this field from table and convert into format 113 what is...
I have table which has say field1,field2.I want that when i execute a query it gives me the sum of 2 fields .Both fields are nvarchar. Thanks
I want to run dynamic query in if expression like if exists ((execute(@sql)) begin print 'h' end else print 'o' end above code gives error.I have...
I am new to parallel query processing .In one of my application many query are fired one by one and this takes time .If i am able to process query...
I have table which has one field has datetime. I receive data in dd-mmm-yyyy hh:mm ampm .How i should write query so that only rows which has later...
In a jobsite jobseekers entered keywords .using this keywords search are performed .keywords can be more than 1 .I think but not able to perform...
Separate names with a comma.
