|
|
-
Alok Chandra Shahi Received Vote Up 10 Months ago through ASK
try this
[http://www.codeproject.com/Articles/30490/How-to-Manually-Create-a-Typed-DataTable][1]
[1]: http://www.codeproject.com/Articles/30490/How-to-Manually-Create-a-Typed-DataTable...
|
-
Mitesh Modi Commented 10 Months ago through Ask
try below
foreach (DataRow row in datat.Rows)
{ Console.WriteLine(row["ItemName"]); }...
|
-
Mitesh Modi Commented 10 Months ago through Ask
your function convert passing parameter to Nvarchar that's why you are getting same output.
In your function @NEWSTRING is NVARCHAR
SET @NEWSTRING = @INPUT_STRING ;
your step 3 with query is unable to understand because there is no 'N' in '...
|
-
Mitesh Modi Commented 10 Months ago through Ask
try this example may help
SELECT REPLACE(CAST('AE' AS NVARCHAR(10)) ,'æ', '’' );
SELECT REPLACE(CAST('AE' AS VARCHAR(10)) ,'æ', '’' );...
|
-
Mitesh Modi Commented 10 Months ago through Ask
Please Mark this as answer if it is working. so this question is closed....
|
-
Mitesh Modi Commented 10 Months ago through Ask
Or Try Another Simplest
SELECT * FROM @t
WHERE (1= CASE WHEN @a=0 AND @b=0 AND @c=0 THEN 1 ELSE NULL END) OR
(a = CASE WHEN @a=1 THEN 1 ELSE NULL END) OR
(b = CASE WHEN @b=1 THEN 1 ELSE NULL END) OR
(c = CASE WHEN @c=1...
|
-
Mitesh Modi Commented 10 Months ago through Ask
Try this query
SELECT *
FROM @t WHERE
a = CASE WHEN @a=1 OR ( @a=0 AND @b=0 AND @c=0) THEN 1 ELSE NULL END OR
b = CASE WHEN @b=1 OR ( @a=0 AND @b=0 AND @c=0) THEN 1 ELSE NULL END OR
c = CASE WHEN @c=1 OR ( @a=0 AND @b=0 ...
|
-
Mitesh Modi Commented 10 Months ago through Ask
in sqlserver store below string in Test column with varchar(Max) datatype
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial Unicode MS;}}
\viewkind4\uc1\pard\f0\fs17\u2693?\u2734?\u2726?\u2750?\u2741?\u2750?\u2726?\...
|
-
Mitesh Modi Commented 10 Months ago through Ask
try this link
[http://1000projects.org/hospital-management-system-net-project-with-source-code.html][1]
[1]: http://1000projects.org/hospital-management-system-net-project-with-source-code.html...
|
-
Can we define abstract class as a static? ...
|