home
Is it possible in SQL someway not to return select statements in sp if there is raiseerror or throw...
I've tested the CHECKSUM() on SQL Server 2008, 2012, 2016: SELECT ABS( CHECKSUM(...
I'm creating an application that will create a database. I found some code on stackoverflow for...
So I'm making a library information system, and I stumbled across a problem. When I want to give...
I have 2 tables mpayment and account. When someone updates data in mpayment, then the trigger...
Can someone remove the @sql variable and Replace function for @ClientID & directly write the...
How do we convert and add trailing and leading zeros to a number? For example 123.45. I need to...
I have fixed the connection string, so it give me errors show here: : 'A network-related or...
I am a beginner hacker and i would like to see somebody's lines of code to hack the box on...
Been trying to solve this without success... I have a table with data: CREATE TABLE [dbo].[test]( ...
Hi there, I am writing an SQL query to derive closing balance and value of which shall be used to...
I have a solution that bulk loads data via a datatable from c#, like this : private void...
I want to create new table rows. I take an entry from my original table and copy this item into a...
11 hours ago

Creating an UDF in SQL

I want to create an optimized UDF in SQL to remove more than to repeated characters from records in...
This question already has an answer here: There are no primary or...
May I ask how to get the whole statement query from running session? I'd like to check its actual...
I am using "POST" method to send and save user data,.. what would the method be for logging back on...
I'm building an SPA on Angular2 (front-end) and back-end web API 2 with OWIN and Identity for...
If I put "if, foreach, and else statement under comment //", the program works and Reduces book...
New here, long time reader but first time poster :) I'm trying to generate a unique id/timestamp...
I'm attempting to take a string, determine if it is a date (date time or time) and then convert it...
I have the following code that has an intentional syntax error for purposes of testing. const...
24 hours ago

SQL Server concat

I have 3 variables: declare @A NVARCHAR(MAX), @B NVARCHAR(MAX), @C NVARCHAR(MAX) @A is filled...
Is it possible to declare and assign the result from an sp in one statement? If we can do,...
I am not able to show checkbox value in JSP page and it shows some random data. after saving, ...
I created a SQL Server database first (2 tables) and then tried to load data through SSIS data flow...
This question is an exact duplicate of: SQL Server : I'm getting...
How can I achieve pivot in sql server 2000
I have a SQL Server temporal table "person" with a record like this: name |...
If I use this query: SET DATEFORMAT dmy; SELECT DATEPART(dw,CAST('02-08-2018' AS date)) AS...