Hay everyone, i need your help , i have one function and one SP both are working fine, but the problem is my host server didn't allow me to create...
Hello everyone, i want to show the data of previous 3 months but week wise, Here is my query which show the data of last 3 months but the date wise....
I m using SQL server 2005, i want to apply a trigger after insert, update that will update a tinyint column "IsUpdated" to 1 but when it will...
Hello everyone, i m suing SQLServer 2005, my server works fine, but now when i trying to logi to my web application, it gives me error, when i opend...
Hello everyone, i m using SQL Server 2005, my system databse "msdb" mark suspected coz of light fluctuations, i have no back up to recover this, i...
Here is my SP, i m using SQL Server 2000, In the Severity Column, i have 3 values : Critical, Information and Error But when i run my SP :...
Here is my SP, i m using SQL Server 2000, in the Severity Column, i have 3 values : Critical, Information and Error, But when i run my SP : Exec...
Hello everyone, I m using SQL Server2005, I have a Complex view whichcontains lot of tables and Inner, Right and Left Outer Join used, ThisView...
Hello everyone, i m using SQLServer2005 . select count(TvsRecordID),FormImage from TvsRecords group by FormImage Here is the query when i run...
Hello everyone, is there any SQL stmt to access log? Can i go into log file just as we go in MDF file "select , delete from xyz..... " As i want...
Hello evryone, i m using SQLServer 2005, in this while generating script (for backup purposes), it generates the script but without the drop stmts of...
hello everyone, i m using SQL Sevrver 2005, here is my query , in this all the where clause filter applied on all columns in the select stmt , so my...
Hello everyone, I m suing SQL Server 2005, here is my query, which displays the last 7 days data in this i used the order by clause for sorting my...
Hello everyone, i m using SQL Server 2005, here is my Search SP, here is a bit problem , the fileds @RangeFrom and @RangeTo shows the Form no...
Hello everyone, i m using SQL Server 2005, i need help for designing my query. I have 5 checkboxes with different fields in my front end application...
Hello everyone, I m using SQL SERVER 2005, here is my query that retuns the FormsCount of last 7 days from the current date, but this query returns...
hello everyone , i m using SQL Server 2005, here are my 2 tables: Table TVSRecords: TvsRecodID int (pk) TvsFormNo Int (unique index) CreateDate...
Hello everyone, i want to truncate my database log file, but not want to drop all log, as i want to drop let say previous last 3 months log . Plz...
Hello everyone, here is my SP: Create Procedure Test @Criteria int As if (@Criteria =1) begin -- All Categories SELECT...
Hello everyone , me using SQL Server 2000, the tables structure are Transactions: 1) TransactionID int (PK) VehicleCategoryCode int(FK)...
Separate names with a comma.
