Hi use nvarchar(8000) umesh
soni uma
Posts
-
Problem with Execute query by EXEC(@string) -
ffmpeg video converterHi, From name it's she. It is Indian name
-
ffmpeg video converterHi, I had read your last post.What you told was right but i thing she was not understand what u want to said.
-
ffmpeg video converterHI,Vidya No need to worry about exe. It is show only in local. When you are setup project on live than from client site this exe is not show. You have to just show only process that file conversion is going on. Regard, umesh soni
-
Rank() function is not working in sql server 2000.It is available only in sql server 2005
-
showing videosIn your code i think "8K_NQe57C-k" is video name For Daynamicaly take a one string variable like (strMediaFile) in witch your video is dynamically assign And at the design side in object use like this wmode="transparent" width="425" height="350"/>
-
Dropdawn list ValueUse QueryString
-
ASPYou can search a vb script code for the task scheduling.Put this vbs file in your task scheduling at specific time at every day.
-
What is the disadvantage of using select * from table name??Common reason is for execution time.If our data base is large and number of records are more than it is better to specify the column name rather than * .
-
auto completeFor this you have to user javascript or any third pary tool or use icallback
-
Retrieve duplicate and non duplicate querySELECT * FROM tblName WHERE (Id IN (SELECT Id FROM tblName GROUP BY Id HAVING COUNT(Id) = 1)) --> This query gives you a non duplicate rows SELECT * FROM tblName WHERE (Id IN (SELECT Id FROM tblName GROUP BY Id HAVING COUNT(Id) > 1)) --> This query gives you a duplicate rows
-
how to extrack string from a sentence?You can doing it with using for loop.Check '<' in string array if array is not contain that than store that sting with ++
-
how to extrack string from a sentence?Try using this way string myString = "http://www.codeguru.com/icom\_includes/feeds/codeguru/rss-all.xml" + "CodeGuru.comsomething" + "http://lifehacker.com/index.xmlLifehackersomething"; string[] test = new string[15]; myString = myString.Replace("", "#"); myString = myString.Replace("", "#"); test = myString.Split(Convert.ToChar("#"));
-
Please help me move these records to another table...It's my pleasure to help you. :cool:
-
Please help me move these records to another table...Remove 'Values' for select statement and also one ')' at the end of select statement like insert into Table() (select from table1) :cool:
-
How to give both Bold & Italic fontstyle to ont fontFollowing will work. FontStyle fs = FontStyle.Bold | FontStyle.Italic; :cool:
-
file downloading prblmDear, This code working perfectly i had already tried it. You should try google and also try that code in different browser
-
file downloading prblmtry using this code it may help you for downloading System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; response.ClearContent(); response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Disposition", "attachment; filename=" ); response.Flush(); response.WriteFile("File"); response.End(); :cool:
-
[Message Deleted]Try using DateDiff function DATEDIFF(day, pubdate, getdate()) :cool:
-
I need query for the employees who joined a weak agoTry the following query Select * from Employees where EmpCreatedDate between select DATEADD(DAY, -(DATEPART(dw,GETDATE())-1),GETDATE()) and getdate() :cool: