Category "sql-server"

Query to get only numbers from a string

I have data like this: string 1: 003Preliminary Examination Plan string 2: Coordination005 string 3: Balance1000sheet The output I expect is string 1:

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Getting maximum value of float in SQL programmatically

Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou

Getting maximum value of float in SQL programmatically

Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou

Getting maximum value of float in SQL programmatically

Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou

Getting maximum value of float in SQL programmatically

Is there an method for programmatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I wou