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
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)
I want to insert in a table .The rows inserted are return by select query.
Insert into table1(col1)
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
.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
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.
I want to run dynamic query in if expression like
if exists ((execute(@sql))
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.